SSIS Amazon Redshift Integration Pack

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 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
  • Articles/Tutorials: Amazon Redshift related articles
Download Buy View All Tasks

SSIS Amazon Redshift Data Transfer Task

SSIS AWS Redshift Connector 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. 

Read more

SSIS Amazon Redshift ExecuteSQL Task

SSIS Redshift Execute SQL 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. 

Read more

SSIS Amazon Redshift Cluster Management Task

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. 

Read more

 

Download View All Tasks