The Warehouse referred to in this example, is not the physical property you might imagine, but a data warehouse for business analytics purposes.
This project illustrates a simple Extract-Transform-Load workflow, using an Excel spreadsheet as an input source. It is used to illustrate: (1) how you set up Business Objects (BOs) to easily extract data from a wide variety of data sources into the Jabatix Workbench; (2) transform this data into useful information (integration, aggregation, calculation); and (3) to make it available (load) for further "downstream" processing or visualization.
Make sure that you are connected to the right database and schema for this project (accept the defaults):
To execute the project WarehouseCreationFromETL, all the required files and scripts are provided, but the mappings between data sources, business objects, and destinations need to be (re)established before running the process flow.
When you first load the WarehouseCreationFromETL project, your data sources and business objects are not mapped: you need to do so manually. (In a real-world scenario, you would probably create a script to effect these connections, but for the sake of learning, we will have you do so manually in this example.)
If your mappings are missing, you will see errors when trying to run the work process associated with the project (or an individual script):
To restore the requisite mappings, follow these steps:
- Select the a business object, by double clicking on its entry in the Project Explorer:
This BO maps to a database table in the local Derby database.
You see the Edit Business Object mapping tab, and the small indicator to the left-bottom of the database table indicates that the mapping is not established. If the mapping type is Flat file,
Press the Create Table button to (re)establish the mapping. Repeat this for each destination table.
Once the mappings are live, you can run the entire project from the Process Flow Explorer (which you bring up by selecting the respective process flow WarehouseProcess and from the Context Menu, the option Show in Process Flow Explorer:
This will generate the following logger outputs.
16:10:08 Notice BOs cleared
16:10:10 Notice CustomerID: 1 added!
16:10:10 Notice CustomerID: 2 added!
16:10:10 Notice --- End of accounts extract --
16:10:11 Notice accountID: 1001 added!
16:10:11 Notice accountID: 1002 added!
16:10:11 Notice accountID: 2001 added!
16:10:11 Notice accountID: 2002 added!
16:10:11 Notice --- End of accounts extract --
16:10:12 Notice --- End of CreateSnapshot ---
To view the BIRT report, double-click on the file warehouseSnapShot.rptdesign, which will bring up the report design editor panel (alternatively, select the Report Design perspective), and now you can view the report bay selecting the HTML view from the report viewing options (they are marked by the globe icon and only visible when the .rptdesign file is loaded in the editor pane).
In our example we selected the option View Report as HTML Now the report will be displayed in a new browser window: