# Structured data stores

> Structured data stores - View the connectors and JDBC drivers currently supported by DataRobot for
> structured data, as well as a list of deprecated connections.

This Markdown file sits beside the HTML page at the same path (with a `.md` suffix). It summarizes the topic and lists links for tools and LLM context.

Companion generated at `2026-08-30T06:11:46.109818+00:00` (UTC).

## Primary page

- [Structured data stores](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/index.html.md): Full documentation for this topic (Markdown sidecar).

## Sections on this page

- [Deprecated connections](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/index.html.md#deprecated-connections): In-page section heading.

## Related documentation

- [Reference documentation](https://docs.datarobot.com/en/docs/reference/index.html.md): Linked from this page.
- [Data](https://docs.datarobot.com/en/docs/reference/data-ref/index.html.md): Linked from this page.
- [Connectivity](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/index.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/wb-adls.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/wb-maxcompute.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-redshift.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-athena.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-s3.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-azure.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-databricks.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/wb-databricks.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-exasol.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-bigquery.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-kdb.html.md): Linked from this page.
- [OAuth provider management](https://docs.datarobot.com/en/docs/platform/acct-settings/manage-oauth.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-ms-sql-srvr.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-mysql.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-oracle.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-postgresql.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-presto.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-salesforce.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/wb-sap.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-sap-hana.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-snowflake.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-treasure.html.md): Linked from this page.
- [Required parameters and connection details](https://docs.datarobot.com/en/docs/reference/data-ref/connectivity/data-sources/dc-trino.html.md): Linked from this page.
- [Manage JDBC drivers](https://docs.datarobot.com/en/docs/platform/admin/manage-cluster/manage-drivers.html.md): Linked from this page.

## Documentation content

Structured data is highly organized and follows a strict schema or "blueprint". Examples of this include numeric, dates, strings, and boolean values.

**Connector vs. Driver**

Each data store connects to DataRobot through either a driver or a connector, and is indicated in the tables for supported unstructured and structured data stores.

| Type | Description | Recommended use |
| --- | --- | --- |
| Connector | DataRobot connects through the data store's native API using an integration built and maintained by DataRobot. The connection is defined by connection fields instead of a JDBC URL, supports authentication methods such as OAuth and service principals, and, for many data stores, supports unstructured data. Connectors require a registered data store. | Recommended when you want to configure connections and credentials once and reuse them. They are also the preferred option when credentials or other sensitive configuration are stored in DataRobot and should not be embedded in your code. Connectors are also recommended for all agentic workflows due to lower latency and unstructured data support. |
| Legacy JDBC Driver | DataRobot connects using the JDBC driver provided by the database vendor. The connection is defined by a JDBC URL and JDBC parameters, authenticates with basic credentials, and supports structured (tabular) data. For Self-Managed AI Platform installations, an administrator uploads and manages the driver files. Requires a registered data store. | Recommended only for custom connection types that are not supported by connectors or a DataRobot-managed JDBC driver. |
| DataRobot-managed JDBC driver | DataRobot ships and manages the driver set as part of the install (bundled in the browser-jdbc service). There are three main differences from the legacy driver: No data store required. Access is via the public /api/v2/jdbcPreviewQuery endpoint (and its write sibling /api/v2/jdbcExecuteUpdate); the caller passes the JDBC URL, credentials, and SQL directly. This is the lowest-latency path.No admin-uploaded drivers. We rely on a predefined, DataRobot-managed driver set.Any authentication the driver itself supports, not only basic credentials - creds and connection properties are passed as JDBC URL parameters.This driver currently supports Postgres, MySQL, SQL Server, BigQuery, Snowflake, Databricks, Trino, SAP Datasphere drivers. | Recommended when you are prepared to manage the connection configuration and credentials directly in the your code. |

The following table lists all data stores—both native connectors and JDBC drivers—supported by DataRobot for structured data ingest:

| Connection | Connection type | Version | Credential type | Notes |
| --- | --- | --- | --- | --- |
| ADLS Gen2 | Connector | 2023.11.221435 | OAuth, OAuth service principal | Required parameters and connection details |
| Alibaba Cloud MaxCompute | Driver | 3.6.0 | Basic | Required parameters and connection details |
| Amazon Redshift | Driver | 2.1.0.14 | Basic | Download JDBC driverRequired parameters and connection details |
| AWS Athena | Driver | 2.0.35 | Basic | Download JDBC driverRequired parameters and connection details |
| AWS S3 | Connector | 2022.1.1670354484 | AWS credentials (both temporary and not temporary) | Required parameters and connection details |
| Azure SQL | Driver | 12.4.1 | Basic | Download the JDBC driverRequired parameters and connection details |
| Azure Synapse | Driver | 12.4.1 | Basic | Download the JDBC driverRequired parameters and connection details |
| Databricks | Driver | 2.6.40 | Basic, access token | Download the JDBC driverRequired parameters and connection details |
| Databricks | Connector |  | Personal access token, service principal | Required parameters and connection detailsWhen connecting to Databricks, the native connector is the recommended connection type. |
| Exasol | Driver | 7.1.2 | Basic | Download the JDBC driverRequired parameters and connection details |
| Google BigQuery | Connector |  | Google Cloud OAuth, service account | Required parameters and connection details |
| InterSystems | Driver | 3.0.0 | Basic | Download the JDBC driver |
| KDB+ * | Driver | 2019.11.11 | Basic | Download JDBC driver (Log in to GitHub before clicking this link.)Required parameters and connection details |
| Managed cloud OAuth | Connector |  | Managed cloud OAuth | OAuth provider management |
| Microsoft SQL Server 6.4 | Driver | 12.2.0 | Basic | Download JDBC driverRequired parameters and connection details |
| MySQL | Driver | 8.0.32 | Basic | Download JDBC driverRequired parameters and connection details |
| Oracle 6 | Driver | oracle-xe_11.2.0-1.0 | Basic | Download JDBC driverRequired parameters and connection details |
| Oracle 8 | Driver | 12.2.0.1 | Basic | Download JDBC driverRequired parameters and connection details |
| PostgreSQL | Driver | 42.5.1 JDBC 4.2 | Basic | Download JDBC driverRequired parameters and connection details |
| Presto | Driver | 0.216 | Basic | Download JDBC driverRequired parameters and connection details |
| Salesforce | Connector |  | Client ID/secret | Required parameters and connection details |
| SAP Datasphere (Premium) | Connector |  | Basic | Required parameters and connection details |
| SAP HANA | Driver | 2.20.17 | Basic | Download JDBC driverRequired parameters and connection details |
| Snowflake | Driver | 3.15.1 | Basic, key pair, OAuth, external OAuth | Download JDBC driverRequired parameters and connection details |
| TD-Hive | Driver | 0.5.10 | Basic | Download JDBC driverRequired parameters and connection details |
| Treasure Data | Driver | Select the query engine you contracted for | Basic | Configure the data integrationRequired parameters and connection details |
| Trino | Connector |  | Basic | Required parameters and connection details |

* Only supported with JDBC, not with KDB native query language `q`

> [!NOTE] Self-Managed AI Platform
> See [Manage JDBC drivers](https://docs.datarobot.com/en/docs/platform/admin/manage-cluster/manage-drivers.html.md) for steps to upload JDBC drivers to your organization.

## Deprecated connections

Support is deprecated for these drivers and connectors:

| Connection | Connection type | Version |
| --- | --- | --- |
| ADLS Gen2 | JDBC | 2021.2.1634676262008; 2020.3.1605726437949 |
| Apache Hive * | JDBC | All |
| Amazon S3 | JDBC | 2020.3.1603724051432 |
| Elasticsearch | JDBC | All |
| Google BigQuery | JDBC | spark-1.2.23.1027 |
| Microsoft SQL Server | JDBC | 6.0 |

* The Apache Hive JDBC driver is only deprecated for multi-tenant SaaS installations.

> [!NOTE] Note
> Older driver versions may still exist, but DataRobot recommends that you use the latest supported version of a connection.