How to configure Oracle’s data source in Unica for User Tables?

To import Oracle’s table into Unica Marketing Platform, you have to create Oralce data source. Following steps are required to successfully establish connection with Oracle database.

Step 1: Adding Data Source to User

Settings > Users > Edit Data Sources > Add New
Data Source: <Select the name of your data source>
Data Source Login: <the user, you are using to connect with database>
Data Source Passoword: <the password of the above user, you are using to connect with database>

Save your changes and navigate to Settings > Configuration

Step 2: Adding Data Source in Configuration

Navigate to dataSources (Affinium|Campaign|partitions|partition1|dataSources). If you have already imported Oracle data source template, you will notice it there. If it’s not there, you have to import data source template. Refer to Chapter 6 of IBM Unica Campaign 8.6 Installation Guide Chapter 6. Configuring Campaign After Deployment > To import data source templates.

configTool -i -p "Campaign|partitions|partition1|dataSources" -f <Unica_Installaion_Home>/Campaign/conf/OracleTemplate.xml

You can find configTool utility in <Unica_Installation_Home>/Platform/tools/bin

ora_ds_config

Now configure following properties:

ASMUserForDBCredentials

The unica user, where you added the data source. (e.g. asm_admin)

DSN

This is data source name. I am using IBM Websphere and added datasources there. You will mention exact name here that you mentioned in WAS.

JndiName

While creating data source in Websphere, you also mention the JNDI name. That JNDI name will be used here.

OwnerForTableDisplay

This is schema owner of database. Execute select * from all_all_tables. OWNER is the field that you will mention here.

SystemTableSchema

This is database user that you are using to connect Oracle database. This user is the same that you mentioned in Data Source Login in Users.

Step 3: Import tables to map

To check successful connection of Oracle’s databse with Unica, navigate to Campaign Settings > Manage Table Mapping > Show User Tables > New Table

It will ask user name and password, you have to give DB credentials here.

unica_table_mapping

Now you can map user tables to Unica.

Comments are welcomed.