Use Campaign Federated Data Access (FDA) option to process information stored in an external database. Follow the steps below to configure access to Snowflake.
Snowflake connector is available for hosted and on-premise deployments. For more on this, refer to this page.
To configure Snowflake on CentOS, follow the steps below:
Download the ODBC drivers for Snowflake. Click here to start downloading.
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
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
In Campaign, you can then configure your Snowflake external account. For more on how to configure your external account, refer to this section.
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
Configure the ODBC driver. For more on this, refer to this page
In Campaign, you can then configure your Snowflake external account. For more on how to configure your external account, refer to this section.
Download the ODBC drivers for Snowflake. Click here start downloading.
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
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
In Campaign, you can then configure your Snowflake external account. For more on how to configure your external account, refer to this section.
You need to create a Snowflake external account to connect your Campaign instance to your Snowflake external database.
From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts.
Click New.
Select External database as your external account’s Type.
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
Click the Parameters tab then the Deploy functions button to create functions.
The connector supports the following options:
Option | Description |
---|---|
workschema | Database schema to use for work tables |
warehouse | Name of the default warehouse to use. It will override the user’s default. |
TimeZoneName | By default empty, which means that the system time zone of the Campaign Classic app server is used. The option can be used to force the TIMEZONE session parameter. For more on this, refer to this page. |
WeekStart | WEEK_START session parameter. By default set to 0. For more on this, refer to this page. |
UseCachedResult | USE_CACHED_RESULTS session parameter. By default set to TRUE. This option can be used to disable Snowflake cached results. For more on this, refer to this page. |