Connect Foundry to Oracle Database to read and sync data between Oracle databases and Foundry.
If your external data source uses a version of the Oracle database that is older than 12.1 (which was released in 2013), you should use the general JDBC connector, and upload your own driver. The Oracle Database connector described below implements the Oracle JDBC 21.x driver. Learn more about the JDBC driver interoperability matrix for Oracle database versions in the official Oracle documentation ↗.
The Oracle Database connector is a Palantir-provided driver connector. Review the official documentation for this driver ↗.
| Capability | Status |
|---|---|
| Exploration | 🟢 Generally available |
| Batch syncs | 🟢 Generally available |
| Incremental | 🟢 Generally available |
| Change data capture syncs | 🟢 Generally available |
| Table exports | 🟡 Beta |
Learn more about setting up a connector in Foundry.
The Oracle Database connector supports authentication using a username and password. We recommend using service credentials rather than individual user credentials.
If using an agent connection, the agent must be allowed to connect to the Oracle database. This means that the agent must be able to reach the destination IP address, and the destination system must be configured to allow connections from the agent.
If using a direct connection, be sure to add the appropriate egress policies to the connector:
| Domain/Host | Required |
|---|---|
| Oracle host/IP | Always |
The default port for Oracle database connections is 1521, but your specific configuration may use a different port.
| Option | Required? | Description |
|---|---|---|
Host type | Yes | The type of host identifier being provided. Can be either hostname or ipv4. |
Hostname | Yes | The hostname or IP address of your Oracle database server. |
Port | Yes | The port number of your Oracle database (default is 1521). |
Service identifier type | Yes | The type of service identifier to use. Can be either SID or Service name. |
TLS | No | Enable TLS encryption ↗ for the connection. When enabled (default), the connection will use TLS to encrypt all communication with the Oracle database. |
Username | Yes | The username to authenticate with the Oracle database. |
Password | Yes | The password to authenticate with the Oracle database. |
Client certificates & private key | No | Client certificates and private keys may or may not be required by your source to secure the connection. |
Server certificates | No | Server certificates may or may not be required by your source to secure the connection. |
This section provides additional details around using virtual tables from an Oracle Database source. This section is not applicable when syncing to Foundry datasets.
| Virtual tables capability | Status |
|---|---|
| Manual registration | 🟢 Generally available |
| Automatic registration | 🔴 Not available |
| Pushdown compute | 🔴 Not available |
When using virtual tables, remember the following source configuration requirements:
username/password.