The CData Power BI Connector for ADP is built on top of an ODBC driver. This section discusses how to install the connector, create a DSN, and connect from Power BI.

Installing the Connector

Installing the Connector is a step-by-step guide for how to manage the installation process.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to ADP.

ADP Version Support

The connector leverages the following ADP APIs to enable access to ADP Workforce Now data:

• Applicant Onboard V2 API
• Payroll Data Input API
• Payroll Output API
• Team Time Cards API
• Time Cards API
• Time Off Balances API
• Time Off Request API
• Validation Table Code List API
• Work Assignment API
• Work Assignment API
• Work Schedules API
• Worker Management API
• Workers API

For an introduction to Visualizing Data using the CData Power BI Connector for ADP.