Writing data to an ASCII file

In addition to transforming the data from the transactional database to the reporting database, the ETL tool can write the output of the transformed data to an ASCII file instead of to the reporting database.

To invoke this functionality:

  • The configuration of the ETL.xml is required.
  • Additional command line parameters must be specified; specifically these parameters:
    -to_file, -sql_end_delimeter, -startDate, -to_file_db_type


run_etl.sh -to_file "full_path_filename" 
-sql_end_delimeter "GO" -startDate "01-15-1970" 
-to_file_db_type "mssql"

Note:  The destination database connection information is not required.