DocumentationCampaignCampaign Classic v7 Documentation

Configure access to Amazon Redshift configure-access-to-redshift

Last update: Thu Apr 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

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 redshift-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:

      code language-none 
       yum update
 yum upgrade
 yum install -y grep sed tar wget perl curl

    • For Debian:

      code language-none 
       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:

    code language-none 
    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:

    code language-none 
      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:

    code language-none 
    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 redshift-external

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.

recommendation-more-help
601d79c3-e613-4db3-889a-ae959cd9e3e1