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:

KeyDescriptionExample ValueRequired
hostHostname or IP address of the Oracle database server.oracledb.example.com
portPort on which the Oracle listener accepts client connections. Typically 1521.1521
serviceOracle service name (not SID). The listener uses this to direct connections to the correct pluggable database.xepdb1
userUsername with permission to connect and write to the target schema.oracle_user
passwordPassword for the Oracle user.xyz123
databaseName of the Oracle database where the table will be created or updated.orcl
modeOracle client mode. Set to either thin (default) or thick depending on the installed driver.thin or thick

Optional Parameters

KeyDescriptionExample Value
lower_caseIf true, all column names will be converted to lowercase. Default is true.true

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).