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 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 in the etl directory in XMDBTool and along with 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 the -toFile <outfile> option.
• conf: Contains the ETL.xml configuration file
• lib: Contains the required library JAR files