Skip to main content

​
Overview

Use OracleDB as a destination in Mage to write pipeline data directly into a table within an Oracle database. Mage supports both thin and thick connection modes, allowing flexibility for local clients, instant clients, or full Oracle installations. This destination is ideal for enterprise data integration with existing Oracle systems, including Oracle XE, Oracle Cloud Infrastructure (OCI), and on-premise Oracle servers.

​
Configuration Parameters

You must provide the following credentials when configuring the OracleDB destination:

​
Optional Parameters

​
Notes

  • The mode parameter determines how the Oracle client connects:
    • Use thin for lightweight connections (e.g., with the Oracle Instant Client).
    • Use thick when a full Oracle client is installed and native libraries are required.
  • Ensure the Oracle listener is correctly configured to accept service name–based connections.
  • Use of the service name is preferred over SID in modern Oracle setups, especially with pluggable databases (PDBs).