DocumentationCampaignCampaign Classic v7 Documentation

Configure access to Microsoft SQL Server configure-fda-sql

Last update: Thu Apr 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

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.

  1. Configure Microsoft SQL Server on CentOS.
  2. Configure Microsoft SQL Server on Linux.
  3. Configure Microsoft SQL Server on Windows.
  4. Configure the Microsoft SQL Server external account in Campaign

Microsoft SQL Server on CentOS sql-centos

NOTE
Microsoft SQL Server is available on CentOS 7 and 6.

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

  1. Download and install SQL ODBC driver with the following command:

    code language-none 
    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

  2. 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 sql-linux

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

  1. Download the MS ODBC driver from this page.

  2. Run the following command as root user:

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

  3. 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 sql-windows

To configure Microsoft SQL Server on Windows:

  1. In Windows, click Control Panel ‘>’ System and Security ‘>’ Administrative Tools’>’ ODBC Data Sources (64-bit).

  2. From the ODBC Data Sources (64-bit) new window, click Add….

  3. Check if SQL Server Native Client v11 is listed in the Create New Data Source window.

  4. If the SQL Server Native Client is not listed, you can download it in this page.

  5. 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 sql-external

You need to create a Microsoft SQL Server external account to connect your Campaign instance to your Microsoft SQL Server 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. Under Configuration, select Microsoft SQL Server from the Type drop-down.

  5. 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

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

    note note
    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.

  7. 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
601d79c3-e613-4db3-889a-ae959cd9e3e1