Configuration
To set up the OracleDB source, provide the following configuration parameters:
| Key | Description | Sample Value |
|---|
host | OracleDB host. | oracledb.example.com |
port | OracleDB port (defaults to 1521). | 1521 |
service | Listener service name on the database server for client connections. | xepdb1 |
password | Password for the user. | xyz123 |
user | Username with permission to connect and query the database. | xyz123 |
mode | Connection mode for the Oracle client. Accepted values are thin or thick. | thick |
Optional Configuration
| Key | Description | Sample Value |
|---|
batch_fetch_limit | Number of rows to fetch per batch (defaults to 50,000). Adjust higher if your instance has more memory. | 50000 |
