Connecting to Amazon Redshift

WestOderman

1 Navigate to System > Integrations > Databases, then select CREATE CONNECTION on the Global Action Bar.

2 From the Database Integration window, provide a Connection Name. Then from the Database Type options, select ODBC. 

3 Provide the Connection String in the following format while making sure that each value following an equal sign corresponds with the Cluster's values: 

Driver={Amazon Redshift (x64)}; Server=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com; Database=dev; UID=masteruser; PWD=insert_your_master_user_password_here; Port=XXXX

4 Click the PICK OR CREATE ODBC DB TYPE button, then select and PICK the corresponding Connection Flow. 

5 Click TEST to ensure that the connection is properly set up, then click OK to save the Integration and exit.

 from: https://documentation.decisions.com/v9/docs/connecting-to-amazon-redshift