Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Oracle connections
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

Oracle Connector overview

Oracle Connector overview

You can use Oracle Connector to connect to Oracle databases from
Data Integration
. 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
synchronization
tasks, mappings,
mapping
tasks,
replication
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
synchronization
task, mapping, or
mapping
task, you can use the Oracle bulk API to perform insert operations.