Kettle application scenarios in projects

These days, the implementers collaborate on Bi projects.

The development of the project is coming to an end. The work in the future is mainly to define indicators and multi-dimensional analysis models and ETL processes. The following is a summary of the work:

Environment:

System:

ERP, his and other subsystems ------- mainly business data and some data dictionaries (sqlserver2005)

Bi SYSTEM -------------------------- metadata and basic data (Oracle 10 Gb)

Data Exchange Platform -------------------- Bi auxiliary platform: Mainly completes the ETL process and imports business tables and data dictionaries into the Bi SYSTEM (server2005)

Why do you want to do some work:

Because Bi mainly analyzes the indicators proposed by the customer, but these indicators are all in other systems (distributed in different databases), We need to extract the data, therefore, data migration is completed through the Data Exchange Platform.

 

Kettle application scenarios in projects