About Consolidation Use Cases

This chapter shows typical consolidation use cases through a predefined application. This means that you do not have to create the data model nor the mashup application pages. You only have to create and configure connectors, transformation and aggregation consolidation processors.

This page discusses:

What Are Our Data Sources

For this tutorial, we use two kinds of data sources both contained in <INSTALLDIR>/docs/cvapp-coffee-sample/coffee_data.zip:

  • the coffee.db sample SQLite database contains four tables and the country_id field as primary key (PK) to make inner joins between them.
    Note: organization does not have country_id as primary key.
  • A set of pdf files containing text and graphics.

Database Schema for the Sample Database

What We Want to Do Functionally

We want to use this database and these PDF files to consolidate data in a prepackaged application contained in <INSTALLDIR>/docs/cvapp-coffee-sample/cvapps_coffee_v1_4.zip. Through several use cases, we will try to expose the various capabilities offered by the Consolidation Server.

About Code Samples

The code samples in this chapter use cases are written in Groovy. Groovy allows you to add inline coding within the product is therefore easier for Training purpose.

Recommendation: For production deployment and maintainability, use Java language.