Setting up SQL Enhanced Query exports
Use the steps to set up an SQL Query Export.
To display the hidden fields, see the steps in Displaying the hidden SQL Enhanced Query Export parameters.
To set up secured exports, see Setting up secured SQL Enhanced Query exports.
- Specify this information to create a scheduled task in the Job Scheduler:
- Task Type
- Export Query Enhanced Task
- Configure these parameters for the Export Query Enhanced Task Parameters:
- Folder
- Specify the path for the file to be exported, using the absolute path with respect to the Job Scheduler or file server.
- File Name
-
Provide a file name.
Note: If required, include a date and time reference as part of the file name. For example, Filename_yyyyMMdd_HHmmss.
- Export Type
- Select an export type from the drop-down field. Options include CSV, XLS, and HTML.
- Write Headers
-
Select this option to include headers in output file.
Note: This option works with all formats.
- Disable Double Quotes
-
Select this option to disable automatic double-quote enclosing in the exported CSV file. This option is hidden by default.
See Displaying the hidden SQL Enhanced Query Export parameters.
- Delimiter
-
Select a delimiter character for the exported CSV file. You can select among Comma, Equals, Semicolon, Tab, space, or Pipe. The delimiter defaults to a comma if left empty. This field is hidden by default.
See Displaying the hidden SQL Enhanced Query Export parameters.
- Selection Query
-
Provide your own custom select query. The results of the selection query are used as a filter in the export query.
Note: This field is not required. However, we recommend you provide a selection query for the export.
- Batch Size
- Specify a batch size. The default is 20. The maximum allowed is 200.
- Export Query
- Provide your own custom export query. This is the primary query. This field is required.
- Click Submit.