Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Connections for Oracle
  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

Introduction to Oracle Connector

Introduction to Oracle Connector

You can use Oracle Connector to connect to Oracle databases from
Data Integration
to read
and write
data.
You can also use Oracle Connector to connect to the following databases:
  • Oracle Database Cloud Service and Oracle databases that are enabled for advanced security
  • Oracle Autonomous Database
  • Azure Oracle private endpoint on a virtual network
You can use Oracle objects as sources
and targets
in
synchronization
tasks,
mappings,
mapping
tasks,
replication
tasks, PowerCenter tasks,
and data transfer 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.
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.

0 COMMENTS

We’d like to hear from you!