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
Now configure following properties:
The unica user, where you added the data source. (e.g. asm_admin)
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.
While creating data source in Websphere, you also mention the JNDI name. That JNDI name will be used here.
This is schema owner of database. Execute
select * from all_all_tables. OWNER is the field that you will mention here.
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.
Now you can map user tables to Unica.
Comments are welcomed.