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.

  • Automate Amazon Redshift Cluster Create Action in few clicks. You can also add Access Security Rule.
  • Automate Amazon Redshift Cluster Delete Action
  • Fetch Amazon Redshift Cluster Property to SSIS Variable (e.g. Fetch Cluster Status)
  • Fetch all cluster and their properties as DataTable (Use ForEach Loop and iterate through all clusters)
  • Automate Redshift Cluster Snapshot Creation
  • Automate Redshift Cluster Snapshot Delete Action
  • Support for Wait until Cluster operation is done
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: Amazon Redshift related articles

Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements

Just Drag and Drop Components from SSIS Toolbox

SSIS Amazon Redshift Cluster Management Task - Create Redshift Cluster, Delete Redshift Cluster, Loop through Redshift Cluster Properties, Create Sanpshot, Delete Snapshot
SSIS Amazon Redshift Cluster Management Task – Create Redshift Cluster, Delete Redshift Cluster, Loop through Redshift Cluster Properties, Create Sanpshot, Delete Snapshot

How to Create Redshift Cluster

SSIS Amazon Redshift Cluster Management Task - Create Cluster Option
SSIS Amazon Redshift Cluster Management Task – Create Cluster Options

In the General Tab you can set Wait until Maximum Time

SSIS Amazon Redshift Cluster Management Task - Create Cluster Wait Options
SSIS Amazon Redshift Cluster Management Task – Create Cluster Wait Options

How to Delete Redshift Cluster

SSIS Amazon Redshift Cluster Management Task - Create Cluster Option
SSIS Amazon Redshift Cluster Management Task – Delete Cluster Options

How to get attribute or cluster using Amazon Redshift Management Cluster Task

SSIS Amazon Redshift Cluster Management Task - Create Cluster Option
SSIS Amazon Redshift Cluster Management Task – Fetch Attribute Options (Single Attribute)

How to Create Snapshot using Amazon Redshift Management Cluster Task

SSIS Amazon Redshift Cluster Management Task - Create Snapshot Options
SSIS Amazon Redshift Cluster Management Task – Create Snapshot Options

How to Delete Snapshot using Amazon Redshift Management Cluster Task

SSIS Amazon Redshift Cluster Management Task - Delete Snapshot Options
SSIS Amazon Redshift Cluster Management Task – Delete Snapshot Options

Finally, almost you are done with each Action configurations, just need to Execute Package

Almost you are done with each Action configurations, just need to Execute Package

Almost you are done with each Action configurations, just need to Execute Package

Articles / Tutorials


How to Read / Write Amazon DynamoDB in SSIS

How to Read / Write Amazon DynamoDB in SSIS

Introduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.). We will discuss how to use SSIS DynamoDB Source Connector […]

Articles/Posts

Amazon Redshift

MySQL to Redshift Data Load Using SSIS

Introduction – MySQL to Redshift Load Before we talk about data load from MySQL to Redshift using SSIS, first lets talk what is Amazon Redshift (or AWS Redshift). Amazon Redshift is a Cloud based Data warehouse service. This type of system also referred as MPP (Massively Parallel Processing). Amazon Redshift uses highly modified version of […]

Amazon Redshift

SQL Server to Redshift Data Load Using SSIS

Introduction – SQL Server to Redshift Load Before we talk data load from SQL Server to Redshift using SSIS lets talk what is Amazon Redshift (or sometimes referred as AWS Redshift). Amazon Redshift is a Cloud based Data warehouse service. This type of system also referred as MPP (Massively Parallel Processing). Amazon Redshift uses highly […]

References

See Also

Click here to learn more about System Requirements
Download View All Tasks Like This