This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Data Connectors

Data Source Connectors are the means through which data connections are made to external systems to import or export data in or out of PlaidCloud.

1: Data Connections
2: REST Connections

2.1: Gusto REST Connector
2.2: Microsoft Dynamics 365 REST Connector
2.3: Mulesoft REST Connector
2.4: Netsuite REST Connector
2.5: Paycor REST Connector
2.6: Quickbooks REST Connector
2.7: Ramp REST Connector
2.8: Sage Intacct REST Connector
2.9: Salesforce REST Connector
2.10: Stripe REST Connector
2.11: Workday REST Connector

1 - Data Connections

Use this table reference for more information on external system connections and databases

Description

PlaidCloud connects to external systems by using various data connections directly or through PlaidLink agents.

For more details on each data connection type, please navigate to the specific data connection documentation.

Relational Databases

Greenplum

Parameter	Value
Connection Type	Database
Reference	greenplum

Microsoft SQL Server

Parameter	Value
Connection Type	Database
Reference	sqlserver

MySQL

Parameter	Value
Connection Type	Database
Reference	mysql

ODBC

Parameter	Value
Connection Type	Database
Reference	odbc

Oracle

Parameter	Value
Connection Type	Database
Reference	oracle

Postgres

Parameter	Value
Connection Type	Database
Reference	postgres

Amazon Redshift

Parameter	Value
Connection Type	Database
Reference	redshift

SAP HANA

Parameter	Value
Connection Type	Database
Reference	hana

Exasol

Parameter	Value
Connection Type	Database
Reference	exasol

IBM DB2

Parameter	Value
Connection Type	Database
Reference	db2

Informix

Parameter	Value
Connection Type	Database
Reference	informix

Hadoop Based Databases

Hive

Parameter	Value
Connection Type	Database
Reference	hive

Presto

Parameter	Value
Connection Type	Database
Reference	presto

Spark

Parameter	Value
Connection Type	Database
Reference	spark

Team Collaboration Tools

Microsoft Teams

Parameter	Value
Connection Type	Notification
Reference	teams

Slack

Parameter	Value
Connection Type	Notification
Reference	slack

Cloud Services

OAuth Connection

Parameter	Value
Connection Type	oAuth
Reference	oauth

Quandl

Parameter	Value
Connection Type	Quandl
Reference	quandl

Google Big Query

Parameter	Value
Connection Type	Google Big Query
Reference	gbq

Google Spreadsheet

Parameter	Value
Connection Type	Google Spreadsheet
Reference	gspread

Oracle EBS utilizes the standard Oracle database connection specified above. 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 described below.

Oracle Cloud utilizes standard RESTful requests to perform queries, data loading, and other operations. A REST connection using OAuth2 tokens is used for these interactions. This uses the standard oAuth connection specified above.

Salesforce utilizes standard RESTful requests to perform all operations. A REST connection using OAuth2 tokens is used for these interactions. This uses the Salesforce specific connection type.

Workday utilizes standard RESTful requests to perform all operations. A REST connection using OAuth2 tokens is used for these interactions. This uses the standard oAuth connection specified above.

Parameter	Value
Connection Type	JD Edwards Legacy
Reference	jde_legacy

JD Edwards utilizes the standard Oracle database connection specified above. This connection provides the connectivity to query, load, and execute PL/SQL programs in Oracle.

Parameter	Value
Connection Type	Infor
Reference	infor

SAP Analytics Cloud

Parameter	Value
Connection Type	SAP Analytics Cloud
Reference	sap_sac

SAP ECC

Parameter	Value
Connection Type	SAP ECC
Reference	sap_ecc

SAP Profitability and Cost Management (PCM)

Parameter	Value
Connection Type	SAP PCM
Reference	sap_pcm

SAP Profitability and Performance Management (PaPM)

Parameter	Value
Connection Type	SAP PaPM
Reference	sap_papm

2 - REST Connections

REST connection requirements vary depending on the service. See how to configure the individual 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.

2.1 - Gusto REST Connector

Connecting to Gusto from PlaidCloud using REST

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

2.2 - Microsoft Dynamics 365 REST Connector

Connecting to Microsoft Dynamics 365 from PlaidCloud using REST

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

2.3 - Mulesoft REST Connector

Connecting to Mulesoft from PlaidCloud using REST

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

2.4 - Netsuite REST Connector

Connecting to Netsuite from PlaidCloud using REST

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

2.5 - Paycor REST Connector

Connecting to Paycor from PlaidCloud using REST

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 current application version

Caution: Do not forget to "activate" the application to allow use

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

Warning: If you have multiple organizations in Paycor, you will need separate logins for each organization. DO NOT merge them. The Developer Portal needs a dedicated unique login for each organization in order to create an organization specific Application for REST access.

Security Requirements

Documentation under development

Obtain Credentials

Documentation under development

Create REST Connector

Documentation under development

2.6 - Quickbooks REST Connector

Connecting to Quickbooks from PlaidCloud using REST

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

2.7 - Ramp REST Connector

Connecting to Ramp from PlaidCloud using REST

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

2.8 - Sage Intacct REST Connector

Connecting to Sage Intacct from PlaidCloud using REST

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

2.9 - Salesforce REST Connector

Connecting to Salesforce from PlaidCloud using REST

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

2.10 - Stripe REST Connector

Connecting to Stripe from PlaidCloud using REST

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

2.11 - Workday REST Connector

Connecting to Workday from PlaidCloud using REST

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

Data Connectors

1 - Data Connections

Description

Relational Databases

Greenplum

Microsoft SQL Server

MySQL

ODBC

Oracle

Postgres

Amazon Redshift

SAP HANA

Exasol

IBM DB2

Informix

Hadoop Based Databases

Hive

Presto

Spark

Team Collaboration Tools

Microsoft Teams

Slack

Cloud Services

OAuth Connection

Quandl

Google Related

Google Big Query

Google Spreadsheet

Oracle EBS Related

Oracle Cloud Related

Salesforce Related

Workday Related

JD Edwards Legacy Version Related

JD Edwards Related

Infor Related

SAP Related

SAP Analytics Cloud

SAP ECC

SAP Profitability and Cost Management (PCM)

SAP Profitability and Performance Management (PaPM)

2 - REST Connections

2.1 - Gusto REST Connector

API Documentation

Security Requirements

Obtain Credentials

Create REST Connector

2.2 - Microsoft Dynamics 365 REST Connector

API Documentation

Security Requirements

Obtain Credentials

Create REST Connector

2.3 - Mulesoft REST Connector

API Documentation

Security Requirements

Obtain Credentials

Create REST Connector

2.4 - Netsuite REST Connector

API Documentation

Security Requirements

Obtain Credentials

Create REST Connector

2.5 - Paycor REST Connector

API Documentation

Paycor Setup

Security Requirements

Obtain Credentials

Create REST Connector

2.6 - Quickbooks REST Connector

API Documentation

Security Requirements

Obtain Credentials

Create REST Connector

2.7 - Ramp REST Connector

API Documentation

Security Requirements

Obtain Credentials

Create REST Connector

2.8 - Sage Intacct REST Connector

API Documentation

Security Requirements