SSIS Amazon Redshift Integration Pack

SSIS Amazon Redshift Integration Pack is your one stop solution for Redshift integration scenarios. Using simple drag and drop interface you can load millions of rows into Amazon Redshift from any on-premises data source (e.g. SQL Server, Flat files, MySQL, Oracle). Execute ad-hoc DDL, DML sql commands against Redshift database such as CREATE/ALTER table, GRANT, DROP. This pack also includes task to manage your Redshift Cluster (e.g. Automate cluster creation/deletion/resize/snapshot).

Features

Extremely fast way to load on-premises data to Amazon Redshift in few clicks.
Load millions of records in few minutes to Amazon Redshift from any database system (e.g. SQL Server, Oracle, MySQL, DB2)
Load data to Amazon Redshift from Flat Files
Support for Client side and Server Side Encryption
Support for multiple threads for parallel loading
Automatic file compression support to reduce bandwidth and cost
Rich error handling and logging support to troubleshoot Redshift Datawarehouse loading issues
Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: Amazon Redshift related articles

Download

Buy

View All Tasks

SSIS Amazon Redshift Data Transfer Task

SSIS Amazon Redshift Data Transfer Task can be used for bulk import data to Amazon Redshift. Source data can be Flat File, ODBC, OLEDB or ADO.net source. This task uses multiple threads to upload data in parallel and optionally compress data files to speedup process.

Go to top

SSIS Amazon Redshift ExecuteSQL Task

SSIS Redshift Execute SQL Task can be used to send any sql queries to Redshift Cluster without needing ODBC driver. You can Issue various sql commands such as DROP, COPY, UNLOAD, CREATE etc.

Go to top

SSIS Amazon Redshift Source

SSIS Amazon Redshift Source Connector can be used to read data from Amazon Redshift. You can use simple Table mode or write custom SQL Query to extract desired data.

Go to top

SSIS Amazon Redshift Cluster Management Task

SSIS Amazon Redshift Cluster Management Task can be used to automate most common Redshift Cluster Management Tasks such as Create Cluster, Delete Cluster, List Cluster Properties, Create Snapshot, Delete Snapshot etc.

Download View All Tasks