Configure access to Amazon Redshift configure-access-to-redshift
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.
- Configure Amazon Redshift database
- Configure the Amazon Redshift external account in Campaign
Amazon Redshift on Linux redshift-linux
To configure Amazon Redshift on Linux, follow the steps below:
-
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
-
-
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
-
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
-
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
-
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.
-
In Campaign Classic, configure your Amazon Redshift external account. From the Explorer, click Administration / Platform / External accounts.
-
Click New.
-
Select External database as your external account’s Type.
-
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
-
-
Click Save.