title: 'Oracle Catalog Connector' sidebar_label: 'Oracle' description: 'Connect to an Oracle database as a catalog provider for federated SQL query.' sidebar_position: 11 pagination_prev: null pagination_next: null tags:
Connect to an Oracle (opens in a new tab) database as a catalog provider for federated SQL query. The Oracle Catalog Connector automatically discovers schemas and tables within an Oracle database and makes them available for querying in Spice. Supports on-premises instances, Oracle Cloud User-Managed Databases, and Oracle Cloud Autonomous Databases (ADB).
For connecting to individual Oracle tables, see the Oracle Data Connector documentation (opens in a new tab).
fromThe from field specifies the catalog provider. For Oracle, use oracle.
nameThe name field specifies the name of the catalog in Spice. Tables from the Oracle database will be available under this catalog name. The schema hierarchy of the Oracle database is preserved in Spice.
includeUse the include field to specify which tables to include from the catalog. The include field supports glob patterns to match multiple tables. For example, *.my_table_name would include all tables with the name my_table_name from any schema. Multiple include patterns are OR'ed together.
paramsConnection can be configured using a connection string or individual parameters. In both cases, oracle_username and oracle_password are required.
| Parameter Name | Description |
|---|---|
oracle_connection_string | An Oracle connection string. E.g. //myhost:1521/ORCLPDB1. |
oracle_username | The Oracle username for authentication. |
oracle_password | The Oracle password for authentication. |
| Parameter Name | Description |
|---|---|
oracle_host | The Oracle host address. |
oracle_port | The Oracle port number. Default: 1521. |
oracle_service_name | The Oracle service name. Default: XEPDB1. |
oracle_username | The Oracle username for authentication. |
oracle_password | The Oracle password for authentication. |
| Parameter Name | Description |
|---|---|
oracle_wallet | Path to the Oracle wallet directory used for mTLS connections. Also used as the destination directory when oracle_wallet_sso_cert is set. Default: .oracle. |
oracle_wallet_sso_cert | Base64-encoded cwallet.sso (wallet auto-login certificate) content. The runtime writes the decoded certificate to oracle_wallet. |
Spice integrates with multiple secret stores to help manage sensitive data securely. For detailed information on supported secret stores, refer to the secret stores documentation (opens in a new tab). Additionally, learn how to use referenced secrets in component parameters by visiting the using referenced secrets guide (opens in a new tab).