ADP Connector

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.

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:  

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.

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:
    

   
   

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 Pull, CSV SFTP Push, Microsoft Excel SFTP, or Microsoft Excel SFTP Push) to pull the report into Domo.