Using the ETL tool

These are the recommended parameters used to create the reporting database. This includes creating the reporting database tables and transformation of the data from the transactional database to the reporting database up to the current date.

run_etl.sh -deploy_tables Y -mapping_classes "USER_HIERARCHY"

The SQL script files can be applied to enhance the report viewing performance after creating the reporting database. The scripts create database indices based on standard reports. Additional indices can get created on the reporting database based on the reports that can be viewed periodically. The script files are located in the XM_INSTALL_DIR/apache-tomcat-9.0.x/tools/etl/conf/createScripts/?_index_creation.sql directory, where ‘?’ indicates the database vendor.

These examples the process of running the ETL process to handle incremental updates:

Use this parameter to override the date range of an incremental transformation. This command transforms the data from the transactional database to the reporting database. Only the data that has been modified between the start and end date based on the timestamp column in the transactional database, is transformed. The ETL process transforms the transactional tables to the reporting tables if the timestamp is between the specified start and end date.

run_etl.sh -startDate "Jan 01, 1996" -endDate "Jan 01, 2002"

Specify this to perform incremental transformation using the start and end date stored in the reporting database. In most cases, this is the recommended method to run the ETL process for incremental updates to the reporting database which enables the ETL process to automatically specify the start and end date.

run_etl.sh