ETL integration architecture

Maximo® Real Estate and Facilities uses an ETL environment to create the ETL scripts that populate the fact tables. The ETL development environment is the Pentaho Data Integration tool, Spoon. The ETL development environment enables the creation of SQL queries that read data from the Maximo Real Estate and Facilities business object tables and map and transform the results to the fact table fact and dimension columns.

The following diagram shows the flow of data between the source data, ETL development environment, and the IBM® Maximo Real Estate and Facilities Workplace Performance Management data model layers:

ETL job items are the business objects that reference the ETL scripts that are used to populate the fact tables.

Maximo Real Estate and Facilities Workplace Performance Management uses standard Maximo Real Estate and Facilities tools.

The following diagram shows the application platform tools: