Redpoint Interaction v7.x Documentation
Redpoint Interaction v7.x Documentation
Breadcrumbs

Admin: AWS Redshift configuration

This section describes how to create and configure an AWS Redshift Data Source Name (DSN). Please follow the steps below. Please note that you may skip steps from 1–4 if you have already installed the ODBC driver.

  1. In a web browser, navigate to https://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html to download the driver.

  2. Locate https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.5.9.1011/AmazonRedshiftODBC64-1.5.9.1011.msi to download the 64bit Amazon Redshift ODBC installer.

  3. In the download folder, double-click the AmazonRedshiftODBC64-1.5.9.1011.msi file.

  4. In the Amazon Redshift ODBC Driver 64-bit Setup Window, select Next and follow the required steps to install the driver.

  5. Once you have successfully installed the ODBC driver, go to Control Panel\All Control Panel Items\Administrative Tools and select Data Sources (ODBC).

  6. In the ODBC Data Source Administrator Window, select the System DSN tab.

  7. Choose the Add... button to create a new Data Source.

  8. Find and select Amazon Redshift (x64) and select Finish.

  9. In the Amazon Redshift ODBC Driver DSN Setup Window, configure the following details:

    • Data Source Name: the name of the data source.

    • Server: the Amazon Redshift cluster endpoint URL, i.e., "xxx.xxx.endpointregion.redshift.amazonaws.com".

    • Port: the cluster port number. Only numerical values are supported. The default is 5439.

    • Database: the database’s name.

    • Auth Type: must be set to "Standard".

    • User: the database username.

    • Password: the database password.

    • Encrypt Password For: must be set to "All Users of This Machine".

    • Additional Options: change the radio button selection to Use "Multiple Statements".

  10. Select the Test button. Once the connection has been made successfully, choose the OK button to create the DSN.

  11. Once completed, launch Server Workbench and login.

  12. In the Install Client at Data warehouse pane, select AWS Redshift as the database provider.

    1. Enter the Server name. This can be either the DNS (Domain Name System) or an IP address of the server.

    2. Enter the Database provider.

    3. Enter the Data Source Name.

    4. Enter the Database schema.

  13. Check the End User License Agreement checkbox and then select Next.