Configure access to Amazon Redshift
- 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.
- Configure Amazon Redshift database
- Configure the Amazon Redshift external account in Campaign
Amazon Redshift on 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:
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
-
-
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
-
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
-
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
-
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.
-
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.