How to configure Oracle Database (OracleDB) as a destination in Mage to write data to a specified schema using the thin or thick client.
Key | Description | Example Value | Required |
---|---|---|---|
host | Hostname or IP address of the Oracle database server. | oracledb.example.com | ✅ |
port | Port on which the Oracle listener accepts client connections. Typically 1521 . | 1521 | ✅ |
service | Oracle service name (not SID). The listener uses this to direct connections to the correct pluggable database. | xepdb1 | ✅ |
user | Username with permission to connect and write to the target schema. | oracle_user | ✅ |
password | Password for the Oracle user. | xyz123 | ✅ |
database | Name of the Oracle database where the table will be created or updated. | orcl | ✅ |
mode | Oracle client mode. Set to either thin (default) or thick depending on the installed driver. | thin or thick | ✅ |
Key | Description | Example Value |
---|---|---|
lower_case | If true , all column names will be converted to lowercase. Default is true . | true |
mode
parameter determines how the Oracle client connects:
thin
for lightweight connections (e.g., with the Oracle Instant Client).thick
when a full Oracle client is installed and native libraries are required.service
name is preferred over SID in modern Oracle setups, especially with pluggable databases (PDBs).