Because Oracle is a relational database, you do not need to create a data map from the PowerExchange Navigator. You can define the bulk data movement entirely from the PowerCenter Designer and Workflow Manager. In the PowerCenter Designer, you can import Oracle source or target metadata from PowerExchange to create the source or target definitions.

If the Oracle database is on a system that is remote from the system or systems where the PowerExchange Navigator, PowerCenter Client, and PowerCenter Integration Service run, you can use either Oracle SQL*Net, also called Net8, or a PowerExchange Listener to communicate with the remote Oracle database.

PowerExchange bulk data movement does not support Oracle 12

c

Multitenant environments.