You can't use this until you register with us!




Description

Execute an SQL Query against a MySQL database and store the results on an FTP server.


Purchasing Options



Available Actions

Download Data with Datetime Parameters

Export data from a MySQL database to an FTP server using an SQL Query and date range parameters specified.


Variables

Source Parameters
target_db required

Database to run the SQL Query on.

sql_steps required

SQL Query to run. Statements are separated by a semicolon.

post_sql_query

SQL Steps to run after data has been stored in the FTP server.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.

custom_nnd_id

Specific custom_nnd_id parameter to use in your SQL queries, if needed.


Range Parameters
range_start_point required

Datetime stamp where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_data_offset

Fixed amount to adjust the Next Run Start Point.

range_end_point_query

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.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
ftp_connection

FTP, FTPS or SFTP Server where the data will be stored.

ftp_folder_path

Path to the folder where the data will be stored.


File Parameters
file_name required

Specify the non-dynamic portion of the file name.

allow_overwrite

Specify whether or not existing files should be overwritten.

compression

Select the compression, if any, applied to the files.

format_type required

Select the format of the data in the files.

add_quotes

Specify whether or not string data values should be enclosed in files with delimited data format.

quote_char

Specify the character used enclose string data values in files with delimited data format, if Add Quotes is enabled.

delimiter

Specify the character used to separate data values in files with delimited data format.

escape

Specify the character used to represent an escaped value in files with delimited data format.

null_as

Specify the characters used to represent a null value in files with delimited data format.

append_date

Enable to append the creation date to the file name.

file_format_config

Optional shared configuration to specify file parameters. If selected, all of the values in the other fields in this section will be ignored.


Download Data with Integer Parameters

Export data from a MySQL database to an FTP Server using an SQL Query and integer range parameters specified.


Variables

Source Parameters
target_db required

Database to run the SQL Query on.

sql_steps required

SQL Query to run. Statements are separated by a semicolon.

post_sql_query

SQL Steps to run after data has been stored in the FTP server.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.

custom_nnd_id

Specific custom_nnd_id parameter to use in your SQL queries, if needed.


Range Parameters
range_start_point required

Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_end_point_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
ftp_connection

FTP, FTPS or SFTP Server where the data will be stored.

ftp_folder_path

Path to the folder where the data will be stored.


File Parameters
file_name required

Specify the non-dynamic portion of the file name.

allow_overwrite

Specify whether or not existing files should be overwritten.

compression

Select the compression, if any, applied to the files.

format_type required

Select the format of the data in the files.

add_quotes

Specify whether or not string data values should be enclosed in files with delimited data format.

quote_char

Specify the character used enclose string data values in files with delimited data format, if Add Quotes is enabled.

delimiter

Specify the character used to separate data values in files with delimited data format.

escape

Specify the character used to represent an escaped value in files with delimited data format.

null_as

Specify the characters used to represent a null value in files with delimited data format.

append_date

Enable to append the creation date to the file name.

file_format_config

Optional shared configuration to specify file parameters. If selected, all of the values in the other fields in this section will be ignored.