Exporting queries to a file using ETL

The -toFile <outfile> command-line option can be used in ETL to export SQL queries to a file instead of updating the reporting database directly. This enables you to review or run the scripts later. You can also use the -db_type <db_type> parameter to specify the database type that must be generated. The mssql, oracle, and psql db types are supported.

Use any text editor tool such as Notepad or Notepad⁺⁺, to read the <outfile> and run the queries for the database specified in the ETL.xml configuration file.

The ETL.xml file is located in the etl directory under XMDBTool and includes these subfolders:

• bin – contains these scripts to run the tool:
  • For Windows: load_etlScript.bat <outfile>
  • For Linux: load_etlScript.sh <outfile>
  The <outfile> is the output file generated using -toFile <outfile> option.
• conf – contains the ETL.xml configuration file
• lib – contains the required library JAR files