Documentation Campaign Campaign Classic v7 Documentation

Configure access to Microsoft SQL Server

Last update: April 11, 2024

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

Configure Microsoft SQL Server on CentOS.
Configure Microsoft SQL Server on Linux.
Configure Microsoft SQL Server on Windows.
Configure the Microsoft SQL Server external account in Campaign

Microsoft SQL Server on CentOS

NOTE

Microsoft SQL Server is available on CentOS 7 and 6.

To configure Microsoft SQL Server on CentOS, follow the steps below:

Download and install SQL ODBC driver with the following command:

sudo su
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
exit
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql

In Adobe Campaign, you can then configure your Microsoft SQL Server external account. For more on how to configure your external account, refer to this section.

Microsoft SQL Server on Linux

NOTE

If you are running an older version of Adobe Campaign (prior to 7.2.1), you need to install unix ODBC drivers.

Download the MS ODBC driver from this page.

Run the following command as root user:

# install the mssql odbc that was downloaded
dpkg -i msodbcsql17_17.7.1.1-1_amd64.deb
# accept the license terms

In Adobe Campaign, you can then configure your Microsoft SQL Server external account. For more on how to configure your external account, refer to this section.

Microsoft SQL Server on Windows

To configure Microsoft SQL Server on Windows:

In Windows, click Control Panel ‘>’ System and Security ‘>’ Administrative Tools’>’ ODBC Data Sources (64-bit).
From the ODBC Data Sources (64-bit) new window, click Add….
Check if SQL Server Native Client v11 is listed in the Create New Data Source window.
If the SQL Server Native Client is not listed, you can download it in this page.
In Adobe Campaign, you can then configure your Microsoft SQL Server external account. For more on how to configure your external account, refer to this section.

Microsoft SQL Server external account

You need to create a Microsoft SQL Server external account to connect your Campaign instance to your Microsoft SQL Server external database.

From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts.
Click New.
Select External database as your external account’s Type.
Under Configuration, select Microsoft SQL Server from the Type drop-down.
Configure the Microsoft SQL Server external account authentication:
- Server: URL of the Microsoft SQL Server server.
- Account: Name of the user.
- Password: User account password.
- Database: Name of the database (optional).
- Timezone: Timezone set in Microsoft SQL Server. Learn more
Click the Parameters tab then the Deploy functions button to create functions.

NOTE
For all functions to be available, you need to create the Adobe Campaign SQL functions in the remote database. For more information, refer to this page.
Click Save when your configuration is finished.

The connector supports the following options:

Option

Description

Authentication

Type of authentication supported by the connector. Current supported value: ActiveDirectoryMSI.
For more on this, refer to example 8 of Microsoft documentation.

Encrypt

Specifies whether connections use the TLS encryption over the network. Possible values are yes/mandatory (18.0 and later), no/optional (18.0 and later), and strict (18.0 and later). The default value is set to yes in version 18.0 and later and no in previous versions.
For more on this, refer to Microsoft documentation.

TrustServerCertificate

Enables encryption using a self-signed server certificate, when used with Encrypt.
Accepted values: yes or no (default value, which means that the server certificate will be validated).

recommendation-more-help