This roadmap ensures that the tasks needed to add a new Target for the end-user. The target area can be:

  • Dimensional model for your BI dashboards.
  • File delvery to your partners.
  • Tables or files for your data scientist.

In the Business- and Target-area you can specify a model which is specific for your business.
The tasks of the ‘BI Data Lake to TRG – Roadmap‘ are schematically displayed as follows:

This roadmap describes the goal, the end result and the work which has to be performed for each task.

The roadmap can be read as a ‘cookbook’.

BMM-PPK; Define the metadata for the Business-area with the Business Metadata Manager (BMM).
• Fill the BMM tables with default metadata based on available database tables.
• Modify the BMM tables.
BMM-CHK; Check the consistency of the BMM Business metadata definitions.
The consistency is checked before the productivity boosters are using the BMM metadata for generating the database DDL- and python ETL software.

BUS-DLL; Generate DDL for the Business-area
Generate the DDL script for implementing the database objects (tables, sequences and views) for the Business-area in the database.
BUS-ETL; Generate ETL for the Business-area
Generate the ETL scripts for loading the source data in the Business-area in the database.
BUS-DEP; Deploy the DDL for the Business-area.
Implement the generated database DDL in your Cloud- or On-Premise database.
BUS-RUN; Run ETL for the Business-area.
Execute the ETL to load the load from the BI Data lake into the Business-area tables.

TMM-PPK; Define the metadata for the Target-area with the Target Metadata Manager (TMM).
• Fill the TMM tables with default metadata based on available database tables.
• Modify the TMM tables.
TMM-CHK; Check the consistency of the TMM Target metadata definitions.
The consistency is checked before the productivity boosters are using the TMM metadata for generating the PostgreSQL DB and ETL software.

TRG-DLL; Generate DDL for the Target-area
Generate the DDL script for implementing the database objects (tables, sequences and views) for the Target-area in the database.
TRG-ETL; Generate ETL for the Target-area
Generate the ETL scripts for loading the source data in the Target-area.
TRG-DEP; Deploy the DDL for the Target-area in the database.
Implement the generated database DDL in your Cloud- or On-Premise database.
TRG-RUN; Run ETL for the Target-area.
Execute the ETL to load the load from the BI Data lake into the Target-area tables.