Integrating with ADP Workforce Now (SFTP)

Prerequisites

ADP Workforce Now (SFTP) Setup Create your employee report Add fields to your custom report Recurring report transfers using Automatic Export Service Scheduling the report

Troubleshooting

Prerequisites

• An active ADP Workforce Now (SFTP) admin account

• Admin privileges in Drivetrain

ADP Workforce Now (SFTP) Setup

Drivetrain uses SFTP to integrate ADP Workforce Now to do data ingestion of files. SFTP is a secure and private method to send files over the internet.

In this guide, you will be given detailed instructions on how to create a custom report in ADP with fields that you want to include for your use case.

Step 1: Create your employee report

1. Log into ADP and click the Reports & Analytics tab

2. Then click Set Up New under the Custom Reports

1. In Set Up New Report page, set the Report Title to employee-census

2. Then click Select Fields to continue

Step 2: Add fields to your custom report

1. Add fields to your custom report

2. Search for the field name under ADD FIELDS, then ****click the + button to add it to the report on the right

3. Below are fields most commonly used in a custom employee report

*And other employee fields.

1. Once you are done with selection, click Save + Run, this will take you to View Report screen

2. Click run to finalise this report

Step 3: Recurring report transfers using Automatic Export Service

1. To automatically send your report on a recurring basis you will need to contact your ADP representative. They will charge a recurring fee to set up report automation that can be used across one or multiple reports. For more information on pricing, please refer to your ADP representative. Charges may vary but anecdotally we have heard prices range from $500-$750 for one-time setup and $30-$50/month recurring fee.

2. To set up the automation, you'll need to complete a Statement of Work with ADP to initiate the recurring file transfers (see the example below). Once finalised, ADP will apply the automation to the custom report you previously created. The process typically takes 3-4 weeks to complete.

1. See details below for filling the Client Supplied Information:

   1. WFN Client ID: Characters to the right of the @ symbol in your ADP login name

   2. WFN Security Master: Person you chose as the Security Master in your ADP instance, this is likely your ADP Admin

   3. Authentication Level: Select SSH Key (ADP Provided)

   4. Date Stamp Required: Select No

   5. Required PGP Encryption: Both are acceptable depending on your preferences, you can read more about PGP Encryption here.

      1. If PGP encryption is required, you have to create key-pair, after which you can then share the key with ADP.

2. Please find details for remaining fields:

   1. FTP Username: Reach out to Drivetrain team for Username.

   2. Directory: Reach out to Drivetrain team for Username.

   3. Host Name / IP Address: sftp1.drivetrain.ai

   4. Port: 22

3. Once the SOW is completed, ADP will typically respond in 3-4 weeks with confirmation on when the report is to be scheduled and the required SSH Key to authenticate the connection

Step 4: Scheduling the report

ADP may schedule the reports themselves based on your preferences, but if you would prefer to schedule the report:

1. Go to Reports & Analytics, and click on All Custom Reports

1. Find the custom report and click on the three dots on right, then select Schedule to Run

1. Fill in the details of the schedule when you want to push data from ADP to drivetrain, after filling all details click on Apply

Troubleshooting

If you are having difficulties sending or receiving the data please first check the following common requirements.

1. Your report must be in .csv format