Connecting to Amazon Redshift
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