Ceridian Dayforce Setup Guide Lite Private Preview

Follow our setup guide to connect Ceridian Dayforce to Fivetran.

Prerequisites

To connect Ceridian Dayforce to Fivetran, you need

a Ceridian Dayforce account with API access.
a user role with access to the Read Data subfeature.

If you don't have API access, contact Ceridian Dayforce's support team.
To receive data for each field, you must enable every field in your Cerdian Dayforce dashboard.

If you do not receive data in a field, ensure that the field is enabled in your dashboard.

Setup instructions

Find credentials

Log in to your Ceridian Dayforce account.
Make a note of your client namespace and client host (e.g., test123.dayforcehcm.com). You will need them to configure Fivetran.

Enable employee XRefCode

On the navigation menu, select System Admin > Roles.
Select the Web Services Field-Level Access tab.
Expand RESTful Services > Human Resources > Employee.
Enable XRefCode and other relevant child nodes that you require.

You must follow the same approach for all the endpoints in the Fivetran schema. NOTE: Ensure your XRedCode does not include any special characters ot spaces, as these will result in a 5xx error when calling the API. If your XRefCode currently contains any special characters or spaces, please update it accordingly. For further assistance, contact Ceridian Dayforce support.

Finish Fivetran configuration

In the connection setup form, enter the Destination schema name of your choice.
Enter the Username and Password of the Ceridian Dayforce user account that you want Fivetran to use to access your data.
Enter your Client Namespace and Client Host you found in Step 1.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
Click Save & Test. Fivetran will take it from here and sync your Ceridian Dayforce data.

Connector Overview

Schema Information

API Connection Configuration