Configuration

To set up the OracleDB source, provide the following configuration parameters:

KeyDescriptionSample Value
hostOracleDB host.oracledb.example.com
portOracleDB port (defaults to 1521).1521
serviceListener service name on the database server for client connections.xepdb1
passwordPassword for the user.xyz123
userUsername with permission to connect and query the database.xyz123
modeConnection mode for the Oracle client. Accepted values are thin or thick.thick

Optional Configuration

KeyDescriptionSample Value
batch_fetch_limitNumber of rows to fetch per batch (defaults to 50,000). Adjust higher if your instance has more memory.50000