Setting up SQL Query Exports

To set up an SQL Query Export:

  1. Specify this information to create a scheduled task in the Job Scheduler:
    Task Type
    Export Task (CSV Query)

    The SQL Query Export Interface lets you perform an SQL query on application tables and export the results to a comma separated value (CSV) or a fixed width text file.

  2. Configure these parameters for the (CSV Query) Export Task Parameters task type:
    SQL Query
    Specify the SQL query to execute.
    File Name
    Specify the path and file name to be exported, using the absolute path with respect to the application server.
    Add Date and Time to Each File Name
    Optionally, select this check box if you want to append the date and time to the export file. The format is: Filename_yyyyMMdd_HHmmss.txt.
    Performs Difference
    Optionally, select this check box if you want the export task to perform a difference between the current SQL query results and the last SQL query results of the same Export Task (CSV Query) task. Only the information that is different is written to the new SQL query CSV file.

    When you run the initial export task, the application creates two directories: /compare and /new. These directories reside in the same location of the exported output file. For each running of the same export task, the new exported file is placed in the /new directory and is compared with the file in the /compare directory (if any exists). The resulting difference file is placed in the main folder.

    The file in the /new directory is copied to the /compare directory for future runs of the same export task.