Connecting to Amazon Redshift

Overview 

Amazon Redshift is an Amazon AWS-based Cloud Data Warehouse that can be leveraged to gain an understanding of an organization and its customer base. Through the use of an ODBC Connection, users may establish a connection with and integrate with an Amazon Redshift Account. The following document discusses and demonstrates how to properly establish Integration with Amazon Redshift. 

Example 

Prerequisite 

The following example requires that the user has a preexisting Amazon Web Services (AWS) Account. To create a new AWS Account, navigate to AWS Console - Signup, then proceed to the sign up process.

1. Download and Install the Amazon Redshift Driver on the desired Server. 
   Amazon Redshift Driver

   To download the Amazon Redshift Driver, navigate to 64-bit ODBC driver version 1.4.34.
   
   Fore more information on configuring an ODBC connection on an Amazon Redshift Cluster, see Configuring an ODBC connection - Amazon Redshift. 

2. Log into the Decisions Studio. 

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

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

5. 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

   
   

6. Under ODBC DB TYPE, Pick the corresponding Connection Flow. 

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