Skip to main content
waffle.svg
Domo Knowledge Base

ADP Connector

Version 14

 

Intro

ADP Workforce Now is a web-based human resources (HR) application designed especially for midsize businesses.  Use Domo's ADP connector to import reports from ADP Workforce Now. To learn more about the ADP API, visit their page at https://developers.adp.com/.

You connect to your ADP account in the Data Center. This topic discusses the fields and menus that are specific to the ADP connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Important: Certain connectors require an API usage fee charged to you by the company, not Domo, depending on the customers' accounts with that company. Use of this connector may require an API usage fee.

Prerequisites

To connect to your ADP account and create a DataSet, you must have the following:

  • The network username and password for your ADP account

  • The PKCS12-formatted Mutual Authentication Certificate store generated for your ADP account (must be encoded in Base 64)

  • The password needed to open your Mutual Authentication Certificate

Connecting to Your ADP Account

This section enumerates the options in the Credentials and Details panes in the ADP Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your ADP account. The following table describes what is needed for each field:  

Field

Description

Network Username

Enter the network username for your ADP account.

Network Password

Enter the network password for your ADP account.

Mutual Authentication Certificate

Paste the Base 64-encoded PKCS12-formatted certificate store that was generated for your account. The certificate must be encoded in Base 64.

Certificate Password

Enter the password needed to open your Mutual Authentication Certificate.

Once you have entered valid ADP credentials, you can use the same account any time you go to create a new ADP DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary Reports menu from which you select an ADP Workforce Now report to import, along with several other configuration options.

Menu

Description

Report

Select the ADP Workforce Now report you want to import into Domo.

Filter Query (Optional)

Enter a $filter query to filter the fields in your report. Please include only the specific query, not the $filter= portion of the parameter string. For more information about building queries, see ADP's developer documentation at https://developers.adp.com/

Select Query (Optional)

Enter a $select query for your report. Please include only the specific query, not the $select= portion of the parameter string. For more information about building queries, see ADP's developer documentation at https://developers.adp.com/

Unmask Data (Optional)

When this box is checked, returned data will not be masked, so long as specified account has access to view all the data.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Using SFTP Export

One of the easiest ways to get your ADP data into Domo is by using ADP's SFTP export capability. To do this, you will first need to request SFTP Export from the ADP Reporting module, then set up an SFTP server for use in pulling reports. You will only need to go through this setup process once. There is a small one-time fee (around $200-$300). Once the server is set up, you can pull any number of reports with no additional fee.

To pull reports, you build them in ADP, specify that they be sent via SFTP, and finally pull them into Domo using the CSV Advanced or SFTP connectors.

Setting up SFTP

To set up an SFTP server for use in pulling ADP reports,

  1. Work with your ADP representative to request SFTP Export from the ADP Reporting module.

    Your ADP representative will send you a Statement of Work (SOW) to fill out. The following PDF shows an example of this:
     

    Requesting SFTP Account Page1.jpg
    Requesting an SFTP Account Page2.jpg

  2. Enter the details for your SFTP server. 
     
    Note: If you like, Domo can host your SFTP server. If you are interested, please reach out to your CSM for more information.  
  3. When requested, send ADP a report to use in testing the setup. (Any ADP report should work.)

    ADP will then send a test and ask you to confirm receipt.

  4. Confirm receipt of the test you have been sent.

Once you confirm receipt, the server is live and you can begin using it to pull reports into Domo.

Pulling Data into Domo Using SFTP

To pull a report into Domo using the SFTP server you have set up,

  1. Build a report in ADP's reporting tool.

  2. Schedule the report in step 7 in the ADP report builder.

  3. In the Distribution settings, specify that the report be sent via SFTP.

  4. Use Domo's CSV Advanced connector or any of our SFTP connectors (SFTP PullCSV SFTP PushMicrosoft Excel SFTP, or Microsoft Excel SFTP Push) to pull the report into Domo.