Creating ODBC or native connections

Create ODBC or native connections so that the Campaign server can access the Campaign database. Create ODBC or native connections on the computer where you installed the Campaign server.

The computer on which the Campaign server is installed must have an ODBC or native connection to the following databases:

The database or schema that contains the Campaign system tables

The database or schema that contains the customer tables.

Use the following guidelines to create these ODBC or native connections:

For databases on UNIX™: You create native connections for DB2® and Oracle databases or ODBC connections for other databases, such as SQL Server, Teradata, Netezza®, and so on. The procedure for creating a native data source differs depending on the data source type and the version of UNIX™. See the data source and operating system documentation for specific ODBC driver installation and configuration instructions.

For databases on Windows™: You create a new ODBC connection in the Control Panel's Administrative Tools > Data Sources (ODBC) section.

Record the ODBC name in the Campaign installation worksheet.