You can use Oracle Connector to connect to Oracle databases from
. Use Oracle Connector to read data from or write data to an Oracle database. You can also Oracle Connector to read from or write data to Oracle Database Cloud Service and Oracle databases that are enabled for advanced security.
You can also use an Oracle connection to read from or write data to Oracle Autonomous Data Warehouse Cloud.
You can use Oracle objects as sources and targets in
tasks, and PowerCenter tasks.
You can configure SSL authentication to establish one-way or two-way secure communication with the Oracle server. You cannot configure the SSL authentication when you use the Hosted Agent.
You can create, update, or delete records when you use Oracle Connector to write to Oracle databases. When you create a
task, mapping, or
task, you can use the Oracle bulk API to perform insert operations.