Preparing Oracle datasource for Unica Campaign
From V12.1 Fixpack 4 onwards, Unica Campaign supports Oracle for both System and User databases
- Create System and User Datasource in odbc.ini file
- Edit odbc.ini file
- Add entry for system and User Datasource
- Make sure DSN entry, Servername in ODBC.ini file should be exactly matching to the
TNS entry in tnsnames.ora file
e.g.
[ORCL]
Driver = /u01/oracle19c/product/db_home/lib/libsqora.so.19.1
Servername = orcl
Port = 1521
- Add following NLS & ODBCINI variables in setenv file
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SSXFF'
export ODBCINI=<Path_to_odbc.ini>
- Test the connection using Campaign CxnTest utility.