SQL Server to Blob Storage Downloader

Description

Execute an SQL Query against a SQL Server database and store the results in a Blob Storage container.

Purchasing Options

SQL Server to Blob Storage Downloader - $49.99 / month

Available Actions

Download Data with Datetime Parameters

Export data from a SQL Server database to a Blob Storage container using an SQL Query and the date range parameters specified.

Variables

Source Parameters

db_connection 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 is processed.

user_params

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

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

blob_storage_connection required

Credentials to use to access the Blob Storage container.

container required

Name of the Azure Blob Storage container where the files will be created.

target_folder_name required

Path to the virtual folder within the Azure Blob Storage container where the files will be created.

File Parameters

file_format_config required

Shared configuration to specify file parameters.

Download Data with Integer Parameters

Export data from a SQL Server database to a Blob Storage container using an SQL Query and the integer range parameters specified.