ETL integration
Maximo® Real Estate and
Facilities uses the Pentaho
ETL development environment, Spoon, to generate transform XML files. These transforms, when run
through the API, move data from source to destination tables.
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.ETL integration process Prerequisite setup for ETL integration IBM® Maximo Real Estate and Facilities , a business object and a form manage the transforms. The source tables and destination fact table must be defined and the mappings understood to create the transformation.Defining and maintaining ETL transforms Maximo Real Estate and Facilities and from the system.Running ETL transforms IBM Maximo Real Estate and Facilities Job Scheduler to run the ETL job items and job groups that are used to move data into the Maximo Real Estate and Facilities fact tables or flattened hierarchy tables.Customizing transform objects IBM Maximo Real Estate and Facilities provides ETL job items and transform objects. Rather than defining a new transform object, you can customize an existing ETL job item transform object. If you use an existing transform object, then you must define or maintain the transform. However, you do not need to define or maintain the business objects, forms, or workflow tasks, as they are already defined.