Skip to content

Click in-app to access the full platform documentation for your version of DataRobot.

Connect to data sources

These pages contain the configuration instructions for each connector that Data Prep supports. Before diving in, you can read about setting up connectors in general.

Select a connector below to learn how to configure it:

Connector Description
Amazon Athena Connect to AWS Athena as an import source.
Amazon S3 Import and export data against Amazon S3 object storage.
Amazon Redshift Connect to Amazon Redshift as an import and export source.
Amazon DynamoDB Connect to an Amazon DynamoDB for Library imports.
Cloudera CDH5 HDFS Connect to Cloudera CDH 5.16 Hadoop File System (HDFS) for import and export.
Cloudera CDH6 HDFS Connect to an Hadoop File System (HDFS) cluster for imports and exports.
Cloudera CDH5 Hive Connect to Cloudera CDH 5.16 Hive for import and export.
Cloudera CDH6 Hive Connect to a Hive database for imports and exports.
Databricks Connect to Databricks for Library imports and exports.
DataRobot Connect to DataRobot for Library imports and exports.
Google Analytics Connect to Google Analytics for browsing and importing available data.
Google BigQuery Connect to BigQuery for importing and exporting available data.
Google Cloud Storage Connect to Google Cloud Storage (GCS) for browsing and importing objects.
Google Cloud SQL Connect to Cloud SQL using the Data Prep JDBC Connectors.
Google Drive Connect to Google Drive for browsing and importing available data.
Google Sheets The Google Sheets Connector has been deprecated. Use the Google Drive Connector, which has support for importing and exporting Google Sheets.
Hortonworks HDP2 HDFS Connect to a Hortonworks HDP 2.6.5 Hadoop File System (HDFS) for import and export.
Hortonworks HDP2 Hive Connect to a Hortonworks HDP 2.6.5 Hive for import and export.
Hubspot Connect to HubSpot for browsing and importing available data.
IBM DB2 Connect to IBM DB2 using the Data Prep JDBC Connector.
IBM Netezza Connect to IBM Netezza using the Data Prep JDBC Connector.
JDBC Import and export data leveraging Java Database Connectivity (JDBC) Drivers. Typically this connector is leveraged for import/export against relational databases, but many applications offer JDBC drivers.
Jira Connect to Jira for browsing and importing available data.
Marketo Connect to Marketo as an import source.
MicroStrategy Connect to a MicroStrategy server for Library imports and exports.
MongoDB Connect to MongoDB for browsing and importing available data.
MS Azure Data Lake Store (ADLS) Connect to Azure Data Lake Storage (ADLS) for Library imports and exports.
MS Azsure Data Lake Store Gen2 (ADLS Gen2) Connect to Azure Data Lake Storage Gen2 for import and export.
MS Azure SQL Connect to Azure SQL using the Data Prep JDBC Connector.
MS Azure Synapse Analytics Connect to an Azure Synapse Analytics for Library imports and exports.
MS Dynamics 365 Connect to a Microsoft Dynamics 365 resource for Entity Set imports.
MS Sharepoint Connect to a SharePoint site for Library imports and exports of files and SharePoint Lists.
MS SQL Server Connect to Microsoft SQL Server using the Data Prep JDBC Connector.
MS Windows Azure Blob Storage (WASB) Connect to Azure Blob Storage Account for Library imports and exports.
MySQL Connect to MySQL using the Data Prep JDBC Connector.
Netsuite Connect to NetSuite for browsing and importing available data.
Network Share (SMB / Samba) Connect to a network share using Server Message Block (SMB) protocol for imports and exports.
Oracle Connect to Oracle using the Data Prep JDBC Connector.
Oracle Marketing Cloud (Eloqua) Connect to Oracle Marketing Cloud for library imports.
PostgreSQL Connect to PostgreSQL using the Data Prep JDBC Connector.
PowerBI Connecting to PowerBI is configured in PowerBI Desktop. Learn more about how to connect.
REST API Connect to a REST API to import a REST Resource.
Salesforce Lightning Connect to a Salesforce org as an import source.
Salesforce Marketing Cloud Connect to Salesforce Marketing Cloud for browsing and importing available data.
SAP HANA Connect to SAP HANA using the Data Prep JDBC Connector.
Spark SQL Connect to Spark SQL for browsing, importing, and exporting available data.
SFTP Connect to an SSH File Transfer Protocol (SFTP) Server for Library imports and exports.
Snowflake Connect to Snowflake using the Data Prep JDBC Connector.
Tableau .Hyper Connect to Tableau as an export destination.
Tableau .tde (deprecated) Connect to a Tableau Server and Tableau Online as an export destination.
Teradata Connect to Teradata using the Data Prep JDBC Connector.
Thoughtspot Export your Data Prep AnswerSets to ThoughtSpot.
Vertica (HP) Connect to Vertica using the Data Prep JDBC Connector.
Zendesk Connect to Zendesk for browsing and importing available data.

Updated September 2, 2021