Supported data stores
Data store vs. data connection
In DataRobot, data store and data connection are used interchangeably, and both refer to where your data is stored and managed as well as the dynamic link to that data. You will see both terms in the UI.
Below is a list of all the supported data stores, along with the latest certified version of their JDBC drivers. Some of the connectors are in preview.
| Connection |
Connection type |
Version |
Unstructured data support? |
Credential type |
Notes |
| ADLS Gen2 |
Connector |
2023.11.221435 |
Yes |
OAuth, OAuth service principal |
Required parameters and connection details |
| Alibaba Cloud MaxCompute |
Driver |
3.6.0 |
No |
Basic |
Required parameters and connection details |
| Amazon Redshift |
Driver |
2.1.0.14 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| AWS Athena |
Driver |
2.0.35 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| AWS S3 |
Connector |
2022.1.1670354484 |
Yes |
AWS credentials (both temporary and not temporary) |
Required parameters and connection details |
| Azure SQL |
Driver |
12.4.1 |
No |
Basic |
Download the JDBC driver
Required parameters and connection details |
| Azure Synapse |
Driver |
12.4.1 |
No |
Basic |
Download the JDBC driver
Required parameters and connection details |
| Box |
Connector |
|
Yes |
JWT |
Required parameters and connection details |
| Confluence |
Connector |
|
Yes |
Basic (username/API token) |
Required parameters and connection details |
| Databricks |
Driver |
2.6.40 |
No |
Basic, access token |
Download the JDBC driver
Required parameters and connection details |
| Databricks |
Connector |
|
Yes |
Personal access token, service principal, Azure service principal |
Required parameters and connection details |
| Exasol |
Driver |
7.1.2 |
No |
Basic |
Download the JDBC driver
Required parameters and connection details |
| Google BigQuery |
Connector |
|
No |
Google Cloud OAuth, service account |
Required parameters and connection details |
| Google Drive |
Connector |
|
Yes |
Google Cloud OAuth, service account |
Required parameters and connection details |
| InterSystems |
Driver |
3.0.0 |
No |
Basic |
Download the JDBC driver |
| Jira |
Connector |
|
Yes |
Basic (username/API token) |
Required parameters and connection details |
| KDB+ * |
Driver |
2019.11.11 |
No |
Basic |
Download JDBC driver (Log in to GitHub before clicking this link.)
Required parameters and connection details |
| Managed cloud OAuth |
Connector |
|
Yes |
Managed cloud OAuth |
OAuth provider management |
| Microsoft SQL Server 6.4 |
Driver |
12.2.0 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| MySQL |
Driver |
8.0.32 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| Oracle 6 |
Driver |
oracle-xe_11.2.0-1.0 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| Oracle 8 |
Driver |
12.2.0.1 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| PostgreSQL |
Driver |
42.5.1 JDBC 4.2 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| Presto |
Driver |
0.216 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| SAP Datasphere (Premium) |
Connector |
|
No |
Basic |
Required parameters and connection details |
| SAP HANA |
Driver |
2.20.17 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| SharePoint |
Connector |
|
Yes |
Azure OAuth, Azure service principal |
Required parameters and connection details |
| Snowflake |
Driver |
3.15.1 |
No |
Basic, key pair, OAuth, external OAuth |
Download JDBC driver
Required parameters and connection details |
| TD-Hive |
Driver |
0.5.10 |
No |
Basic |
Download JDBC driver
Required parameters and connection details |
| Treasure Data |
Driver |
Select the query engine you contracted for |
No |
Basic |
Configure the data integration
Required parameters and connection details |
| Trino |
Connector |
|
No |
Basic |
Required parameters and connection details |
* Only supported with JDBC, not with KDB native query language q
Self-Managed AI Platform
See Manage JDBC drivers 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
Older driver versions may still exist, but DataRobot recommends that you use the latest supported version of a connection.