Configuring the SiebelUnicodeDB Custom Property
4-72
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Error Database
Log Table Database
If the above attribute values are not inherited from the attributes defined at the
connection level, you must specify them.
9.
In the Attributes list, specify values for Error Table and Log Table.
4.13 Configuring the SiebelUnicodeDB Custom Property
If your source to target data movement configuration is Unicode to Unicode, you need
to create a custom property called SiebelUnicodeDB on Integration Services. If your
source to target data movement configuration is either Code Page to Code Page or
Code Page to Unicode, you do not need to create this property. For more information
on supported source to target configuration modes, and how to determine the source
to target configuration for your environment, see
Section 4.3.3, "Code Page and Data
Movement Requirements."
To create and set the SiebelUnicodeDB custom property on Integration Services
1.
Log into Informatica Administrator. For information on how to log into
Informatica Administrator, see
Section A.8, "How to Log Into Informatica
Administrator."
2.
Select the Integration Service.
3.
In the Properties tab, scroll down to the Custom Properties area, and click Edit.
4.
In the Name field, enter the following:
SiebelUnicodeDB
5.
In the Value field, enter the following:
[user_OLTP]@[connectString_OLTP] [user_OLAP]@[ConnectString_OLAP]
Where:
[user_OLTP] is the database user for the OLTP source database. It must match
exactly the value you entered for the User Name field when creating the relational
connection for the OLTP in Informatica Workflow Manager.
[ConnectString_OLTP] is the connect string for the OLTP. It must match exactly the
value you entered for the Connect String field when creating the relational
connection for the OLTP in Informatica Workflow Manager.
[user_OLAP] is the database user for the Oracle Business Analytics Warehouse
database. It must match exactly the value you entered for the User Name field
when creating the relational connection for the data warehouse in Informatica
Workflow Manager.
[ConnectString_OLAP] is the connect string for the data warehouse. It must match
exactly the value you entered for the Connect String field when creating the
relational connection for the data warehouse in Informatica Workflow Manager.
For example, oltp@db204007.host.com olap@db204008.host.com.
Note:
This procedure is not specific to the Siebel source system. It
must be performed for all types of source systems.