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.

    The documentation link in a Foundry-provided driver source configuration page

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

Configuration options

ParameterRequired?Description
URLYesThe JDBC URL that is used by the driver. Comes pre-populated with a template that may need to be modified to ensure correct behavior. Refer to the source system's documentation for the JDBC URL format, and review the Java documentation ↗ for additional information.
JDBC propertiesYesLists out all required and recommended properties that the driver needs. Hovering over a required or recommended property will allow you to navigate to the official documentation. You can add any additional properties by hitting the + Add property button.

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.

A link to documentation appears in a tooltip when hovered over the driver name.

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, which will be saved to the output dataset in Foundry.

Exceptionally, this query can invoke stored procedures that produce data as a result. Read below for more details.

The SLQ Query input on the Edit syncs page for a JDBC connector.

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.

Certificate authentication

Many CData drivers support certificate authentication, in particular for Azure-based systems.

To connect using a certificate, you must define the following JDBC properties in addition to the connection-specific configuration requirements:

  • AuthScheme: AzureServicePrincipalCert
  • OAuthJWTCertType: PFXBLOB
  • OAuthJWTCert: base64-encoded_cert/pfx/pem_file_content
  • (Optional) OAuthJWTCertPassword: password_for_the_cert/pfx/pem_file

To transform the certificate file into Base64 format on a Windows machine, use the following command: [Convert]::ToBase64String([IO.File]::ReadAllBytes("\path\to\file.pfx"))

Microsoft Exchange driver with private certificate authentication configured.

Stored procedures

Some CData drivers connecting to file-based source systems like Amazon Marketplace or Microsoft OneDrive rely on the ability to invoke stored procedures to ingest data.

Microsoft OneDriver sync extracting a file using a stored procedure.

Running the stored procedure will produce a table where the file content is stored as a Base64 encoded string. You can decode it in a downstream data transformation, for example in Pipeline Builder using a Base64 decode board.

Available drivers

Driver
Act! CRM
Act-On
ActiveCampaign
Acumatica
Adobe Analytics
Adobe Commerce
ADP
Airtable
AlloyDB
Amazon DynamoDB
Amazon Marketplace
Apache CouchDB
Apache HBase
Apache Hive
Apache Phoenix
Authorize.Net
Avalara
Azure Active Directory
Azure Cosmos DB
Azure Data Catalog
Azure DevOps
Azure Synapse
Azure Table Storage
Basecamp
BigCommerce
Blackbaud Raisers Edge NXT
Bugzilla
Bullhorn CRM
Cassandra
Certinia
Cloudant
CockroachDB
Confluence
Couchbase
Databricks
DocuSign
Domino
eBay
eBay Analytics
EnterpriseDB
Epicor Kinetic
Exact Online
Facebook
Facebook Ads
FreshBooks
Freshdesk
GitHub
Gmail
Google Ad Manager
Google Ads
Google Analytics
Google Calendar
Google Campaign Manager
Google Contacts
Google Data Catalog
Google Directory
Google Drive
Google Search
Google Spanner
GraphQL
Greenplum
Highrise
IBM Cloud Data Engine
IBM Cloud Object Storage
Instagram
Jira Service Management
Kintone
LDAP
LinkedIn
LinkedIn Marketing Solutions
Mailchimp
Marketo
MarkLogic
Microsoft Access
Microsoft Ads
Microsoft Bing
Microsoft Dataverse
Microsoft Dynamics 365
Microsoft Dynamics 365 Business Central
Microsoft Dynamics CRM
Microsoft Dynamics GP
Microsoft Dynamics NAV
Microsoft Excel
Microsoft Excel Online
Microsoft Exchange
Microsoft Office 365
Microsoft OneDrive
Microsoft OneNote
Microsoft Planner
Microsoft Power BI XMLA
Microsoft Project
Microsoft SharePoint Excel
Microsoft SQL Server
Microsoft SQL Server Analysis Services
Microsoft Teams
Monday
MYOB
OData
Odoo
Oracle
Oracle Eloqua
Oracle Fusion Cloud Financials
Oracle Fusion Cloud HCM
Oracle Fusion Cloud SCM
Oracle Sales
Oracle Service Cloud
Outreach
Paylocity
PayPal
Pinterest
Pipedrive
Presto
Quickbase
QuickBooks Desktop
QuickBooks Online
QuickBooks POS
Raisers Edge NXT
Reckon
Reckon Accounts Hosted
Redis
Redshift
RSS
Sage 200
Sage 300
Sage 50 UK
Sage Business Cloud Accounting
Salesforce Marketing Cloud
Salesforce Marketing Cloud Account Engagement
Salesloft
SAP Business One
SAP BusinessObjects BI
SAP ByDesign
SAP Cloud for Customer
SAP Concur
SAP Fieldglass
SAP HANA XSA
SAP SuccessFactors
SAS Data Sets
SAS Xpt
SendGrid
ServiceNow
ShipStation
Shopify
SingleStore
Slack
Smartsheet
Snapchat Ads
Snowflake
Spark SQL
Splunk
Square
Streak
Stripe
SugarCRM
SuiteCRM
SurveyMonkey
SybaseIQ
Tableau CRM Analytics
Tally
TaxJar
Trello
TSheets
Twilio
Twitter Ads
Veeva Vault
Wave Financial
WooCommerce
WordPress
Workday
xBase
Xero
Xero WorkflowMax
YouTube Analytics
Zendesk
Zoho Books
Zoho Creator
Zoho CRM
Zoho Inventory
Zoho Projects
Zuora