DocumentationCampaignCampaign Classic v7 Documentation

Configure access to Amazon Redshift

Last update: Thu Apr 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
  • Topics:
  • Installation
  • Federated Data Access

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.

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