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




Description

Execute an SQL Query or Script against a database and optionally store the results in a desired location.


Purchasing Options



Available Actions

Run SQL Script with Date Parameters

Execute an SQL Script with the date range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Query or Script on.

sql_steps required

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

user_params required

Parameters to use in your SQL Query or Script, if any.


Range
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

Datetime stamp where the processing of your sequentially sorted data should end. 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.


Run SQL Script with Integer Parameters

Execute an SQL Script with the integer range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Query or Script on.

sql_steps required

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

user_params required

Parameters to use in your SQL Query or Script, if any.


Range
range_start_point required

Integer where the processing of your 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.


Export Data with Date Parameters

Export data from a database to a target location using an SQL Query and date range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Query or Script on.

sql_steps required

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

user_params required

Parameters to use in your SQL Query or Script, if any.


Range
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

Datetime stamp where the processing of your sequentially sorted data should end. 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.


S3 Info
s3_bucket_connection
s3_folder_path

Folder path from the Folder Path Prefix in the S3 Connection document to the folder where the data will be exported.


FTP Info
ftp_connection

Export data to this FTP location.

ftp_folder_path

Folder path from root to the folder where the data will be exported.


File/Formatting Options
file_name required

Name for the file containing the exported data.

allow_overwrite

Overwrite files with the same name.

format_type required

Format applied to the exported data.

delimiter

Delimiter you want to use to separate columns. Default is tab delimited.

escape

Escape character used to precede special characters. Default is backslash.

null_as

The string you want to use to indicate a null value. Default is nothing.

add_quotes

For delimited format export data, wrap strings in quotes. Recommended for source data containing double quote characters.


Export Data with Integer Parameters

Export data from a database to a target location using an SQL Query and integer range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Query or Script on.

sql_steps required

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

user_params required

Parameters to use in your SQL Query or Script, if any.


Range
range_start_point required

Integer where the processing of your 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.


S3 Info
s3_bucket_connection
s3_folder_path

Folder path from the Folder Path Prefix in the S3 Connection document to the folder where the data will be exported.


FTP Info
ftp_connection

Export data to this FTP location.

ftp_folder_path

Folder path from root to the folder where the data will be exported.


File/Formatting Options
file_name required

Name for the file containing the exported data.

allow_overwrite

Overwrite files with the same name.

format_type required

Format applied to the exported data.

delimiter

Delimiter you want to use to separate columns. Default is tab delimited.

escape

Escape character used to precede special characters. Default is backslash.

null_as

The string you want to use to indicate a null value. Default is nothing.

add_quotes

For delimited format export data, wrap strings in quotes. Recommended for source data containing double quote characters.