v7

Configure access to Amazon Redshift

Last update: 2023-11-23

Use Campaign Federated Data Access (FDA) option to process information stored in an external databases. Follow the steps below to configure access to Amazon Redshift.

  1. Configure Amazon Redshift database
  2. Configure the Amazon Redshift external account in Campaign

Amazon Redshift on Linux

To configure Amazon Redshift on Linux, follow the steps below:

  1. Before the ODBC installation, check that the following packages are installed on your Linux distribution:

    • For Red Hat/CentOS:

       yum update
       yum upgrade
       yum install -y grep sed tar wget perl curl
      
    • For Debian:

       apt-get update
       apt-get upgrade
       apt-get install -y grep sed tar wget perl curl
      
  2. Before running the script, you can have access to more information with the --help option:

    cd /usr/local/neolane/nl6/bin/fda-setup-scripts/
    ./redshift_odbc-setup.sh --help
    
  3. Access the directory where the script is located and run the following script as a root user:

      cd /usr/local/neolane/nl6/bin/fda-setup-scripts
      ./redshift_odbc-setup.sh
    
  4. After installing the ODBC drivers, you need to restart Campaign Classic. To do so, run the following command:

    systemctl stop nlserver.service
    systemctl start nlserver.service
    
  5. In Campaign, you can then configure your Amazon Redshift external account. For more on how to configure your external account, refer to this section.

Amazon Redshift external account

The Amazon Redshift external account allows you to connect your Campaign instance to your Amazon Redshift external database.

  1. In Campaign Classic, configure your Amazon Redshift external account. From the Explorer, click Administration / Platform / External accounts.

  2. Click New.

  3. Select External database as your external account’s Type.

  4. Configure the Amazon Redshift external account, you must specify:

    • Type: Amazon Redshift

    • Server: Name of the DNS

    • Account: Name of the user

    • Password: User account password

    • Database: Name of your database if not specified in DSN. It can be left empty if specified in the DSN

    • Working schema: Name of your working schema. Learn more

    • Time zone: Server time zone

  5. Click Save.

On this page