Execute an SQL Query against a MySQL database and store the results on an FTP server.
Export data from a MySQL database to an FTP server using an SQL Query and date range parameters specified.
Variables
Database to run the SQL Query on.
SQL Query to run. Statements are separated by a semicolon.
SQL Steps to run after data has been stored in the FTP server.
Parameters to use in your SQL Query, if any. Refer to slide out help for more information.
Specific custom_nnd_id parameter to use in your SQL queries, if needed.
Datetime stamp where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.
Fixed amount to adjust the Next Run Start Point.
SQL Query to use to determine the end point of the data to process. Leave this field blank to process all records with a Datetime stamp after the starting point.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
FTP, FTPS or SFTP Server where the data will be stored.
Path to the folder where the data will be stored.
Specify the non-dynamic portion of the file name.
Specify whether or not existing files should be overwritten.
Select the compression, if any, applied to the files.
Select the format of the data in the files.
Specify whether or not string data values should be enclosed in files with delimited data format.
Specify the character used enclose string data values in files with delimited data format, if Add Quotes is enabled.
Specify the character used to separate data values in files with delimited data format.
Specify the character used to represent an escaped value in files with delimited data format.
Specify the characters used to represent a null value in files with delimited data format.
Enable to append the creation date to the file name.
Optional shared configuration to specify file parameters. If selected, all of the values in the other fields in this section will be ignored.
Export data from a MySQL database to an FTP Server using an SQL Query and integer range parameters specified.
Variables
Database to run the SQL Query on.
SQL Query to run. Statements are separated by a semicolon.
SQL Steps to run after data has been stored in the FTP server.
Parameters to use in your SQL Query, if any. Refer to slide out help for more information.
Specific custom_nnd_id parameter to use in your SQL queries, if needed.
Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
FTP, FTPS or SFTP Server where the data will be stored.
Path to the folder where the data will be stored.
Specify the non-dynamic portion of the file name.
Specify whether or not existing files should be overwritten.
Select the compression, if any, applied to the files.
Select the format of the data in the files.
Specify whether or not string data values should be enclosed in files with delimited data format.
Specify the character used enclose string data values in files with delimited data format, if Add Quotes is enabled.
Specify the character used to separate data values in files with delimited data format.
Specify the character used to represent an escaped value in files with delimited data format.
Specify the characters used to represent a null value in files with delimited data format.
Enable to append the creation date to the file name.
Optional shared configuration to specify file parameters. If selected, all of the values in the other fields in this section will be ignored.