Creating ODBC or native connections

Create ODBC or native connections so that the Campaign server can access the database that contains the Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM® SPSS® Modeler Advantage Enterprise Marketing Management Edition test run tables of the design time environment. Create ODBC or native connections on the computer where you installed the Campaign server.

About this task

If you use the Campaign customer (user) tables as your test run tables, then the ODBC connection is already created when Campaign was installed.

If the Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition design time environment test run tables are not the same as your customer (user) tables, use the following guidelines to create the ODBC or native connection to the database that holds them:

  • For databases on UNIX™: Create a new native data source in an ODBC.ini file. 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™: Browse to Control Panel and click Administrative Tools > Data Sources (ODBC) to create an ODBC data source.

Record the connection names in the Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition installation worksheet.