This is the multi-page printable view of this section. Click here to print.
Data Connectors
- 1: Cloud Service Connections
- 1.1: Quandl Connector
- 2: Database and Data Lake Connections
- 2.1: Amazon Athena
- 2.2: Amazon Redshift
- 2.3: Apache Doris
- 2.4: Apache Hive
- 2.5: Apache Spark
- 2.6: Azure Databricks
- 2.7: Databend
- 2.8: Exasol
- 2.9: Greenplum
- 2.10: IBM DB2
- 2.11: IBM Informix
- 2.12: Microsoft Fabric
- 2.13: Microsoft SQL Server
- 2.14: MySQL
- 2.15: ODBC
- 2.16: Oracle
- 2.17: PlaidCloud Lakehouse
- 2.18: PostgreSQL
- 2.19: Presto
- 2.20: SAP HANA
- 2.21: Snowflake
- 2.22: StarRocks
- 2.23: Trino
- 3: ERP System Connections
- 3.1: Infor Connector
- 3.2: JD Edwards (Legacy) Connector
- 3.3: Oracle EBS Connector
- 3.4: Oracle Fusion Connector
- 3.5: SAP Analytics Cloud Connector
- 3.6: SAP ECC Connector
- 3.7: SAP Profitability and Cost Management (PCM) Connector
- 3.8: SAP Profitability and Performance Management (PaPM) Connector
- 3.9: SAP S/4HANA Connector
- 4: Git Repository Connections
- 4.1: AWS CodeCommit Repository Connector
- 4.2: Azure Repos Repository Connector
- 4.3: BitBucket Repository Connector
- 4.4: GitHub Repository Connector
- 4.5: GitLab Repository Connector
- 5: Google Service Connections
- 5.1: Google BigQuery Connector
- 5.2: Google Sheets
- 6: Open Table Format Connections
- 6.1: Apache Hive Open Table Format
- 6.2: Apache Hudi Open Table Format
- 6.3: Apache Iceberg Open Table Format
- 6.4: Delta Lake Open Table Format (Databricks Catalog)
- 7: REST Connections
- 7.1: Gusto REST Connector
- 7.2: Microsoft Dynamics 365 REST Connector
- 7.3: Mulesoft REST Connector
- 7.4: Netsuite REST Connector
- 7.5: Paycor REST Connector
- 7.6: Quickbooks REST Connector
- 7.7: Ramp REST Connector
- 7.8: Sage Intacct REST Connector
- 7.9: Salesforce REST Connector
- 7.10: Stripe REST Connector
- 7.11: Workday REST Connector
- 8: Team Collaboration Connections
- 8.1: Microsoft Teams Connector
- 8.2: Slack Connector
1 - Cloud Service Connections
PlaidCloud provides a direct service connections for services that don't use REST or JSON-RPC requests.
The individual service guides will help provide the specific setup necessary to connect.
1.1 - Quandl Connector
Connection Documentation
Quandl is now Nasdaq Data Link. The documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Service Connection
Documentation under development
2 - Database and Data Lake Connections
PlaidCloud enables connection directly to databases, data lakes, query engines, and lakehouses. Connections can also utilize a PlaidLink agent if services are behind a firewall.
Since the terms of database, lakehouse, query engine, and potentially others are used to refer to data that can be queried using a connection, we generally treat all of these as "Databases" despite a wide variety of underlying technology that performs the underlying query.
2.1 - Amazon Athena
Upstream Documentation
Amazon Athena documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.2 - Amazon Redshift
Upstream Documentation
Amazon Redshift has several guides related to use located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.3 - Apache Doris
Upstream Documentation
Apache Doris documentation is here.
The Apache project homepage for Apache Doris is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.4 - Apache Hive
Upstream Documentation
Apache Hive documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Data Lake Connector
Documentation under development
2.5 - Apache Spark
Upstream Documentation
The Apache Spark documentation is here.
The Apache project is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.6 - Azure Databricks
Upstream Documentation
Azure Databricks documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
In order to obtain the connection credentials necessary for PlaidCloud to communicate with a Databricks warehouse, follow the steps below:
- Open the Databricks console
- Under the User Settings in the upper right, select "Settings"
- Navigate to the "Developers" section
- Generate an Access Token with a sufficient lifespan specified
- Navigate to the "SQL Warehouses" area
- Select the warehouse required for connecting
- Capture the connection details including host, and http path
- Navigate to the warehouse data area
- Capture the initial catalog and initial schema information
With the information above, the connection form can be completed and tested with the Databricks warehouse
Create Database Connector
Documentation under development
2.7 - Databend
Upstream Documentation
Databend documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.8 - Exasol
Upstream Documentation
Exasol documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.9 - Greenplum
Upstream Documentation
The Greenplum documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.10 - IBM DB2
Upstream Documentation
The IBM DB2 documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.11 - IBM Informix
Upstream Documentation
IBM Informix documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.12 - Microsoft Fabric
Upstream Documentation
The Microsoft Fabric documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.13 - Microsoft SQL Server
Upstream Documentation
Microsoft SQL Server documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.14 - MySQL
Upstream Documentation
MySQL documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.15 - ODBC
Upstream Documentation
Using the ODBC connector will require configuration specific to the database. While ODBC is a generic connection type, each database may implement some specific configurations. Please refer to the ODBC documentation for the target database.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.16 - Oracle
Upstream Documentation
The Oracle database documentation is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.17 - PlaidCloud Lakehouse
Upstream Documentation
There is very little configuration necessary for using the built-in PlaidCloud Lakehouse. The documentation for the service is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Lakehouse Connector
Documentation under development
2.18 - PostgreSQL
Upstream Documentation
PostreSQL documentation is located here
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.19 - Presto
Upstream Documentation
The Presto documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.20 - SAP HANA
Upstream Documentation
The SAP HANA documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.21 - Snowflake
Upstream Documentation
The Snowflake documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.22 - StarRocks
Upstream Documentation
StarRocks documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
2.23 - Trino
Upstream Documentation
The Trino documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Database Connector
Documentation under development
3 - ERP System Connections
PlaidCloud provides a direct connections for ERP systems.
The individual service guides will help provide the specific setup necessary to connect.
3.1 - Infor Connector
Upstream Documentation
The Infor documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create ERP Connection
Documentation under development
3.2 - JD Edwards (Legacy) Connector
Upstream Documentation
The JDE documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create ERP Connection
Documentation under development
3.3 - Oracle EBS Connector
Upstream Documentation
The Oracle EBS documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Oracle EBS utilizes the standard Oracle database connection. This connection provides the connectivity to query, load, and execute PL/SQL programs in Oracle.
If the EBS instance has the REST API interface available, this can be accessed using the same approach as Oracle Cloud REST connection too.
Create ERP Connection
Documentation under development
3.4 - Oracle Fusion Connector
Upstream Documentation
The Oracle Fusion applications documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create ERP Connection
Documentation under development
3.5 - SAP Analytics Cloud Connector
Upstream Documentation
The SAP Analytics Cloud documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create SAC Connection
Documentation under development
3.6 - SAP ECC Connector
Upstream Documentation
SAP has removed all ECC documentation and currently only provides documentation for S/4HANA.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create ERP Connection
Documentation under development
3.7 - SAP Profitability and Cost Management (PCM) Connector
Upstream Documentation
The SAP PCM legacy documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create PCM Connection
Documentation under development
3.8 - SAP Profitability and Performance Management (PaPM) Connector
Upstream Documentation
The SAP PaPM documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create PaPM Connection
Documentation under development
3.9 - SAP S/4HANA Connector
Upstream Documentation
The documentation for SAP S/4HANA is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create ERP Connection
Documentation under development
4 - Git Repository Connections
PlaidCloud provides a direct connections for Git repositories.
The individual service guides will help provide the specific setup necessary to connect.
4.1 - AWS CodeCommit Repository Connector
Service Documentation
The AWS CodeCommit service documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Git Connection
Documentation under development
4.2 - Azure Repos Repository Connector
Service Documentation
The Azure Repos service documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Git Connection
Documentation under development
4.3 - BitBucket Repository Connector
Service Documentation
The BitBucket service documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Git Connection
Documentation under development
4.4 - GitHub Repository Connector
Service Documentation
The GitHub service documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Git Connection
Documentation under development
4.5 - GitLab Repository Connector
Service Documentation
The GitLab service documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Git Connection
Documentation under development
5 - Google Service Connections
PlaidCloud provides a direct connections for Google services.
The individual service guides will help provide the specific setup necessary to connect.
5.1 - Google BigQuery Connector
Connection Documentation
The Google BigQuery documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Query Connection
Documentation under development
5.2 - Google Sheets
Connection Documentation
Google Sheets is oriented more towards consumers. For technical documentation, refer to the developer documentation here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Spreadsheet Connection
Documentation under development
6 - Open Table Format Connections
PlaidCloud provides a direct connections for Open Table Formats for use with the PlaidCloud Lakehouse service. This allows for hybrid query execution without moving data.
The individual service guides will help provide the specific setup necessary to connect.
6.1 - Apache Hive Open Table Format
Catalog Documentation
Apache Hive documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Catalog Connection
Documentation under development
6.2 - Apache Hudi Open Table Format
Catalog Documentation
Apache Hudi documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Catalog Connection
Documentation under development
6.3 - Apache Iceberg Open Table Format
Catalog Documentation
Apache Iceberg documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Catalog Connection
Documentation under development
6.4 - Delta Lake Open Table Format (Databricks Catalog)
Catalog Documentation
The Delta Lake documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Catalog Connection
Documentation under development
7 - REST Connections
PlaidCloud provides a comprehensive way to connect to any REST service using standard authentication processes. However, it is quite common that REST based services have nuanced differences in how authentication takes place and the parameters needed for a successful handshake.
The individual service guides will help provide the specific setup necessary to connect.
In addition to the specific REST connectors, PlaidCloud also provides a generic REST connector that can be configured to connect and process responses from other REST services.
7.1 - Gusto REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.2 - Microsoft Dynamics 365 REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.3 - Mulesoft REST Connector
API Documentation
The API documentation is for this connector is determined by the service endpoints for which Mulesoft is handling.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.4 - Netsuite REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.5 - Paycor REST Connector
API Documentation
The API documentation is for this connector is located here.
Paycor Setup
The Paycor API Application and Initiation process is a little more involved than other REST providers. Please be sure to go through the steps outlined on their Quick Start Page
Key values you must capture are:
- Application OAuth Client ID
- Application OAuth Client Secret
- APIm Subscription Key
- Scope Key of
currentapplication version
Activate it here, choosing Production or Sandbox depending on your need:
| Environment | Activation Form URL |
|---|---|
| Sandbox | https://hcm-demo.paycor.com/AppActivation/ClientActivation |
| Production | https://hcm.paycor.com/AppActivation/ClientActivation |
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.6 - Quickbooks REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.7 - Ramp REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.8 - Sage Intacct REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.9 - Salesforce REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.10 - Stripe REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
7.11 - Workday REST Connector
API Documentation
The API documentation is for this connector is located here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create REST Connector
Documentation under development
8 - Team Collaboration Connections
PlaidCloud provides a direct connections for team collaboration services.
The individual service guides will help provide the specific setup necessary to connect.
8.1 - Microsoft Teams Connector
Connection Documentation
Microsoft Teams Admin documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Teams Connection
Documentation under development
8.2 - Slack Connector
Connection Documentation
Slack Admin documentation is here.
Security Requirements
Documentation under development
Obtain Credentials
Documentation under development
Create Slack Connection
Documentation under development