[On-premise/hybrid only]{class="badge yellow" title="Applies to on-premise and hybrid deployments only"}

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

Oracle oracle

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 ;

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