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