Connecting to Amazon Redshift Database

Using the Amazon Redshift connection type, you can connect an Amazon Redshift database.

Click Data Source button in the configuration panel to add a new data connection.

data source

Click CREATE NEW to launch a new connection from the connection type panel.

data source button1

Click Amazon Redshift connection button in the connection type panel.

amazonredshift_button

Set the server Name and port number where the Amazon Redshift service is running.

Enter the user name and password to connect to the Amazon Redshift.

Enter the database name and click the Connect button to connect the Amazon Redshift.

amazonredshift_connectiontype

The selected database will be opened in the data design view window.

Oracle6

Drag and drop the table from table list, and click Save button to save the data source with valid name.