How does Informatica PowerCenter (in versions 8 and 9.5) connect to its Oracle database?
Step 1 - PowerCenter reads its
nodemeta.xml config file, to find the domain connection info:
This becomes displayed in the Administrator (domain properties) as something along the following lines:
Note the use of a custom driver - a wrapper around the Oracle standard driver:
This means that Oracle’s OID configuration cannot be directly used here, by the way.
Step 2 - PowerCenter gets the repository connection data from the domain schema & connects to the repository schema:
Again, you can see this in the Administrator.