Learn more
 

ADP Integration Guides and Tutorials


A list of guides and tutorials for connecting to and working with live ADP data.

CData Software's connectivity tools enable users to connect directly to live ADP data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live ADP data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze ADP in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live ADP Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from ADP Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live ADP data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to ADP in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze ADP Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel ADP Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of ADP in Birst
BIRTJDBCDesign BIRT Reports on ADP
Clear AnalyticsODBCBuild Charts with ADP in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze ADP Data in Cognos Analytics
DBxtraODBCBuild Dashboards with ADP in DBxtra
DomoODBCCreate Datasets from ADP in Domo Workbench
Dundas BIODBCBuild Dashboards with ADP in Dundas BI
Excel (on Mac OS)ODBCWork with ADP Data in MS Excel on Mac OS X
FineReportJDBCFeed ADP into FineReport
Google SheetsConnect SpreadsheetsAccess Live ADP Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with ADP
Infragistics RevealConnect CloudAnalyze ADP Data in Infragistics Reval
JasperServerJDBCCreate ADP Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to ADP in Jaspersoft Studio
JReport DesignerJDBCIntegrate with ADP in JReport Designer
KlipfolioConnect CloudCreate ADP-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the ADP JDBC Driver in KNIME
LINQPadADO.NETWorking with ADP in LINQPad
LookerConnect CloudAnalyze ADP Data in Looker
Looker StudioConnect CloudCreate Reports from ADP Data in Looker Studio
MetabaseConnect CloudCreate Interactive ADP-Connected Metabase Dashboards
Microsoft ExcelConnect SpreadsheetsAccess Live ADP Data in Excel Desktop
Microsoft Excel for the WebConnect SpreadsheetsAccess Live ADP Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from ADP
MicroStrategyConnect CloudConnect to Live ADP Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for ADP in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for ADP in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for ADP in MicroStrategy Web
Mode AnalyticsConnect CloudCreate ADP-Connected Visualizations in Mode
OBIEEJDBCADP Reporting in OBIEE with the ADP JDBC Driver
pandasPythonUse pandas to Visualize ADP in Python
Pentaho Report DesignerJDBCIntegrate ADP in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time ADP
Power BI ServiceConnect CloudVisualize Live ADP Data in the Power BI Service
Power PivotConnect CloudAccess ADP Data in Microsoft Power Pivot
Power QueryConnect CloudAccess ADP Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from ADP Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query ADP in QlikView over ODBC
RJDBCAnalyze ADP in R (JDBC)
RODBCAnalyze ADP in R (ODBC)
RapidMinerJDBCConnect to ADP in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live ADP Data in Redash
SAP Analytics CloudConnect CloudAnalyze ADP Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for ADP
SAP Crystal ReportsJDBCPublish Reports with ADP in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with ADP in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for ADP in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for ADP in SAS JMP
SAS ViyaConnect CloudAnalyze Live ADP Data in SAS Viya
SisenseJDBCVisualize Live ADP in Sisense
Spago BIJDBCConnect to ADP in SpagoBI
TableauTableauVisualize ADP in Tableau Desktop
TableauConnect CloudVisualize ADP in Tableau Desktop (Connect Cloud)
Tableau CloudConnect CloudBuild ADP Visualizations in Tableau Cloud
Tableau ServerTableauPublish ADP-Connected Dashboards in Tableau Server
ThoughtSpotConnect CloudModel, Search, and Visualize Live ADP Data in ThoughtSpot
TIBCO SpotfireADO.NETVisualize ADP in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize ADP Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on ADP from Spotfire Server
VisioODBCLink Visio Shapes to ADP
Zoho AnalyticsConnect CloudCreate ADP-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to ADP Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous ADP Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous ADP Replication to Amazon S3
Apache AirflowJDBCBridge ADP Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with ADP using Apache Camel
Apache CassandraCData SyncAutomated Continuous ADP Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous ADP Replication to Apache Kafka
Apache NiFiJDBCBridge ADP Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with ADP Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with ADP Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport ADP Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous ADP Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous ADP Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate ADP to SQL Server
CloverDXJDBCConnect to ADP in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous ADP Replication to Couchbase
CSVCData SyncAutomated Continuous ADP Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous ADP Replication to Databricks
ETL ValidatorJDBCHow to Work with ADP in ETL Validator
FoxProODBCWork with ADP in FoxPro
Google AlloyDBCData SyncAutomated Continuous ADP Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous ADP Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous ADP Replication to Google Cloud SQL
Google Data FusionJDBCBuild ADP-Connected ETL Processes in Google Data Fusion
Google Data FusionJDBCBuild Pipelines with Live ADP Data in Google Cloud Data Fusion (CData Connect Cloud)
Heroku / Salesforce ConnectCData SyncReplicate ADP for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to ADP in HULFT Integrate
IBM DB2CData SyncAutomated Continuous ADP Replication to IBM DB2
Informatica CloudJDBCIntegrate ADP in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for ADP
Jaspersoft ETLJDBCConnect to ADP in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous ADP Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous ADP Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to ADP
Microsoft Power AutomateConnect CloudBuild ADP-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous ADP Replication to MongoDB
MySQLCData SyncAutomated Continuous ADP Replication to MySQL
Oracle Data IntegratorJDBCETL ADP in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous ADP Replication to Oracle
petlPythonExtract, Transform, and Load ADP in Python
PostgreSQLCData SyncAutomated Continuous ADP Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate ADP to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous ADP Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous ADP Replication to SingleStore
SnapLogicJDBCIntegrate ADP with External Services using SnapLogic (JDBC)
SnapLogicConnect CloudIntegration with ADP Data in SnapLogic (Connect Cloud)
SnowflakeCData SyncAutomated Continuous ADP Replication to Snowflake
SQL ServerCData SyncAutomated Continuous ADP Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to ADP Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous ADP Replication to SQLite
TalendJDBCConnect to ADP and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to ADP in UiPath Studio
VerticaCData SyncAutomated Continuous ADP Replication to a Vertica Database
WorkatoConnect CloudBuild Automated Workflows with Live ADP Data in Workato
ZapierConnect CloudBuild Automated ADP-Connected Workflows in Zapier

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate ADP with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for ADP (JDBC)
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for ADP Data (Connect Cloud)
DenodoJDBCCreate A Data Source for ADP in Denodo Platform
DremioJDBCConnect to ADP as an External Source in Dremio
MySQL Federated TablesODBCConnect to ADP as Federated Tables in MySQL
Oracle DatabaseODBCAccess ADP as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for ADP
Salesforce ConnectConnect CloudEdit and Search ADP External Objects in Salesforce Connect
Salesforce External ServicesConnect CloudConnect to ADP through External Services in Salesforce
SQL Server Linked ServersODBCConnect to ADP as a Linked Server
SQL Server PolyBaseConnect CloudConnect to ADP Data using PolyBase with Connect Cloud
SQL Server PolyBaseODBCConnect to ADP as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live ADP Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live ADP Data in AWS Lambda
AxiosConnect CloudBuild ADP-Connected Web Apps with Axios and CData Connect Cloud
.NET ChartsADO.NETDataBind Charts to ADP
.NET QueryBuilderODBCRapidly Develop ADP-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with ADP
Apache SparkJDBCWork with ADP in Apache Spark Using SQL
AppSheetConnect CloudCreate ADP-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild ADP-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to ADP Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on ADP Data in Choreo
ColdFusionJDBCQuery ADP in ColdFusion Using JDBC
ColdFusionODBCQuery ADP in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on ADP
DelphiODBCDataBind Controls to ADP Data in Delphi
DevExpressADO.NETDataBind ADP to the DevExpress Data Grid
EF - Code FirstADO.NETAccess ADP with Entity Framework 6
EF - LINQADO.NETLINQ to ADP
EF - MVCADO.NETBuild MVC Applications with Connectivity to ADP
Filemaker ProODBCBidirectional Access to ADP from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to ADP from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with ADP on Linux
Google Apps ScriptConnect CloudConnect to ADP Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with ADP Entities in Java
IntelliJJDBCConnect to ADP in IntelliJ
JBossJDBCConnect to ADP from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for ADP using JDBI
JitterbitConnect CloudIntegrate with Live ADP Data in Jitterbit
JRubyJDBCConnect to ADP in JRuby
MendixConnect CloudBuild ADP-Connected Apps in Mendix (Connect Cloud)
MendixJDBCBuild ADP-Connected Apps in Mendix (JDBC)
Microsoft Power AppsConnect CloudIntegrate Live ADP Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery ADP Data in Node.js (via Connect Cloud)
NodeJSODBCQuery ADP through ODBC in Node.js
OutSystemsConnect CloudCreate ADP-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess ADP in PHP through Connect Server
PHPODBCNatively Connect to ADP in PHP
PowerBuilderADO.NETConnect to ADP from PowerBuilder
PowerShellPowerShellPipe ADP to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for ADP in PyCharm
PythonODBCConnect to ADP in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with ADP Data
RubyODBCConnect to ADP in Ruby
RunMyProcessConnect CloudConnect to ADP Data in RunMyProcess
RunMyProcess DSECJDBCConnect to ADP in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to ADP in SAPUI5 MVC Apps
ServoyJDBCBuild ADP-Connected Apps in Servoy
Spring BootJDBCAccess Live ADP Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access ADP in Python
TomcatJDBCConfigure the CData JDBC Driver for ADP in a Connection Pool in Tomcat
UnqorkConnect CloudCreate ADP-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for ADP
WebLogicJDBCConnect to ADP from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport ADP Data into Apache Solr
Coginiti ProJDBCAccess Live ADP Data in Coginiti Pro
DataGripJDBCQeury ADP Data in DataGrip
DB ArtisanJDBCManage ADP in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to ADP in DBArtisan
DBeaverJDBCConnect to ADP in DBeaver
DbVisualizerJDBCConnect to ADP in DBVisualizer
HeidiSQLConnect CloudConnect to ADP Data in HeidiSQL
Informatica Enterprise Data CatalogJDBCAdd ADP to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery ADP Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery ADP in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate ADP Data with QuerySurge
RazorSQLJDBCConnect to ADP in RazorSQL
SQuirreLJDBCConnect to ADP in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess ADP in Anypoint Using SQL
Nintex Workflow CloudConnect CloudBuild ADP-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate ADP Data into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to ADP through SSIS
SSIS ImportSSISImport ADP Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing ADP Records from SQL Server

Back to top

Ready to get started?

Learn more:

ADP Connectivity Solutions

In this article

Related articles