Connect to data sources for Data Prep¶
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. |
| Cloudera CDH6 Impala | Connect to an Impala 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 June 17, 2022
Was this page helpful?
Great! Let us know what you found helpful.
What can we do to improve the content?
Thanks for your feedback!