Connecting to Amazon Redshift Database

Amazon Redshift is one of the most popular, fully managed cloud data warehouse services. Astera Centerprise offers native connectivity to Amazon Redshift databases at both source and destination points. These databases can also be connected for use in other functionalities such as Database Lookup, SQL Query Lookup, and Database Write Strategies.

In this article, we will learn how Amazon Redshift can be connected as a Database Table Source in Astera Centerprise.

1. Drag and drop the Database Table Source object from the toolbox onto the dataflow designer. Right-click on its header and select Properties from the context menu.

../_images/1.png

Once you select the Properties option from the context menu, a Database Connection window will open.

../_images/2.jpg

This is where you configure the properties to establish connection with the database.

2. On the Database Connection screen, you will find a drop-down list next to the Data Provider option.

Select RedShift < Beta > as your data provider from this list.

../_images/3.png

  • Put in the required credentials for your RedShift < Beta > data provider account.

../_images/4.png

  • Test Connection to make sure that the database connection is successful and click OK.

../_images/5.png

../_images/6.png

The connection to Amazon Redshift as your database provider has been successfully established. You can now pick a source table on the next screen from Amazon RedShift database and use that data in your dataflow.

To learn more about how to pick a table from a database source and specify other reading options, click here.

This concludes connecting to Amazon Redshift (Beta) database in Astera Centerprise.