Amazon Redshift is a fast, fully-managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.
Read more about Amazon Redshift.
Etlworks Integrator fully supports Amazon Redshift.
Configuring the Firewall
Typically, the TCP port
5439 is used to access Amazon Redshift. If Amazon Redshift and Eltworks Integrator are running on different networks, it is important to enable inbound traffic on port
Learn how to open an Amazon Redshift port for inbound traffic.
Configuring permissions for Redshift
- The user used to access the Redshift must have INSERT privilege for the Amazon Redshift table.
- If you are going to be loading data into Redshift from an Amazon S3 bucket, you will need to grant access to S3 for the Redshift user.
- For access to Amazon S3 with the ability to use
UNLOAD, choose either the
AmazonS3ReadOnlyAccessrole or the
Connecting to Redshift
In order to work with Redshift you will need to create a connection to Amazon Redshift.