Database

The database server can run on any given operating system regardless of the operating system used by the application server or servers, as long as there is network connectivity between them.

The operating system of the database server is not important so long as connectivity with the different components of Adobe Campaign is available.

Also check the Database access layers section.

Microsoft SQL Server

The native client must be installed on the Adobe Campaign application servers.

You can check for the native client on the server via the ODBC driver configuration panel, under SQL Server Native Client 11.0.

The following access DLL must be present: sqlncli11.dll.

Access DLLs are found on the Microsoft website.

NOTE

Access to Microsoft SQL Server from an application server running in Linux is not supported.

Oracle

NOTE

Column names with multi-byte characters are not supported.

The NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET parameters need to be correctly properly configured in order for the database to work in Unicode or ANSI.

Adobe Campaign uses default Oracle encoding. Using other encoding may trigger compatibility issues: in this case, please contact technical support.

To find out about your encoding, use the following sqlplus command:

SELECT * FROM nls_database_parameters ;

  • For a Unicode installation, the encodings supported are:

    NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_CHARACTERSET         AL32UTF8

  • For an ANSI installation (non-unicode), only the following encoding is supported:

  NLS_CHARACTERSET WE8MSWIN1252

To log on to sqlplus, use the Oracle user profile:

su - oracle
sqlplus
[login] [password]

You can also refer to Oracle Client in Linux.

PostgresSQL

We recommend that you install the UTF-8 support when installing the database engine. This way you will be able to create Unicode databases.

Related topic

On this page