Configure access to Snowflake

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

1. Configure Snowflake on CentOS, Windows or Debian
2. Configure the Snowflake external account in Campaign

Snowflake on CentOS

To configure Snowflake on CentOS, follow the steps below:

1. Download the ODBC drivers for Snowflake. Click here to start downloading.

2. You then need to install the ODBC drivers on CentOs with the following command:

   rpm -Uvh unixodbc
   rpm -Uvh snowflake-odbc-2.20.2.x86_64.rpm
   

3. After downloading and installing the ODBC drivers, you need to restart Campaign Classic. To do so, run the following command:

   /etc/init.d/nlserver6 stop
   /etc/init.d/nlserver6 start
   

4. In Campaign, you can then configure your Snowflake external account. For more on how to configure your external account, refer to this section.

Snowflake on Windows

1. Download the ODBC driver for Windows. Note that you need administrator-level privileges to install the driver. For more on this, refer to this page

2. Configure the ODBC driver. For more on this, refer to this page

3. In Campaign, you can then configure your Snowflake external account. For more on how to configure your external account, refer to this section.

Snowflake on Debian

1. Download the ODBC drivers for Snowflake. Click here start downloading.

2. You then need to install the ODBC drivers on Debian with the following command:

   apt-get install unixodbc
   apt-get install snowflake-odbc-x.xx.x.x86_64.deb
   

3. After downloading and 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
   

4. In Campaign, you can then configure your Snowflake external account. For more on how to configure your external account, refer to this section.

Snowflake external account

You need to create a Snowflake external account to connect your Campaign instance to your Snowflake external database.

1. From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts.

2. Click New.

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

4. Configure the Snowflake external account, you must specify:

   • Type: Snowflake

   • Server: URL of the Snowflake server

   • Account: Name of the user

   • Password: User account password

   • Database: Name of the database

   

5. Click the Parameters tab then the Deploy functions button to create functions.

   

The connector supports the following options: