Running ETL transforms
Use the 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.
ETL job items, job groups, and job schedulers
ETL job items define an ETL transformation script or rebuild hierarchy process that is used to capture information from the Maximo Real Estate and Facilities database, transform it, and load it into fact tables. ETL job groups are simply collections of ETL job items. Job schedulers define when ETL job items and job groups are to run. A job schedule must be activated to run the jobs that are associated with it.
Creating or modifying ETL job items
ETL job items define the scripts that capture information from the Maximo Real Estate and Facilities database, transform it, and load it into fact tables or flattened hierarchy tables.
Adding or modifying job groups
To simplify job scheduling, use job groups to make collections of ETL job items to be run on the same schedule.
Creating or modifying job schedulers
Use job schedulers to schedule when IBM Maximo Real Estate and Facilities runs ETL job items and job groups. You can schedule jobs to run on an hourly, daily, weekly, or monthly basis.