Palantir-provided drivers for JDBC sources

You can connect your Foundry enrollment to various external sources using a JDBC driver that appears as Foundry sources in Data Connection. These sources are wrappers around JDBC drivers that allow for customization, and they come with recommended and required properties and links to official documentation.

If you want to upload your own JDBC driver to Foundry, review the documentation on configuring a custom JDBC driver

Setup

1. Open the Data Connection application and select +New Source in the upper right corner of the screen.

2. Find your specific source from the listed options. View a complete list of Foundry-provided drivers.

3. Choose to use a direct connection over the Internet or to connect through an intermediary agent.

4. Select Documentation ↗ to review official documentation for the driver source.

   

5. Follow the additional configuration prompts to continue the setup of your connector using the information in the sections below.

Configuration options

JDBC properties

You can add properties ↗ to your JDBC connection to configure behavior. Certain properties are mandatory for a particular driver. These mandatory properties are populated by default and must be set before you can save your source. You can also view recommended properties that you can add by selecting +Add property and viewing the Recommended section.

Hover over the name of a Required or Recommended property to visit the official documentation page for the selected driver.

Configure Foundry-provided driver syncs

SQL queries

A single SQL query can be executed per sync. This query should produce a table of data as an output and should not perform operations like invoking stored procedures. The results of the query will be saved to the output dataset in Foundry.

CData

Many of the Foundry-provided drivers are developed by CData ↗. CData provides full documentation for each driver including, in-depth instructions for generating credentials on the source system. You can navigate to these instructions from the documentation page for any CData driver.

Available drivers