A Workday How-To: Effective Integration Using the Bristlecone Pagination Adapter

Workday is a rich source of data, giving users access to Workday HCM Business Services information and valuable employee records. Given its integration capabilities, that employee data has the ability to become a critical asset for other enterprise systems. However, Workday is a multi-tenant platform, so it must control integrations to ensure that they don’t affect performance. Due to the massive nature of employee data files, bottlenecks often occur, resulting in the system terminating the run.

To effectively manage the integration of employee data files into other enterprise systems, it’s imperative to leverage the combination of the Workday Scheduler and pagination. Pagination helps prevent system overload, enabling an export of total Workday users and their related information on each page and in a batch format. When coupled with the Scheduler, it’s easy to define the start time and end time, according to the integration requirement.

At Bristlecone, we’ve made that process easy. Using our Pagination adapter, users can build integration for the Workday adapter on the Integration Cloud. Leveraging the Pagination concept and the SchedulerWorkday, it’s easy to extract bulk user data in an organized manner from Workday in one single run. Here’s how to create the flow between the HCM Business Services data and other enterprise systems:

  1. Create a new integration with Scheduled Orchestration as an integration style.
  2. Drag and drop Assignactivity from the Actions. Provide a unique name to this action and click Create.
  3. Assign the below two variables to your integration. Specify the values to variables as below.

PageCount =1

TotalPages =1

Click Validate, and then click Close.

  1. Drag and drop Whileactivity from the Actions Provide a unique name for this action and click Create. Define the condition for variables created in the Assign asPageCount<=TotalPages.

Click Validate, and then click Close.

  1. Inside the Whileactivity, drag and drop Workday endpoint with Human Resourcesmodule and Get_WorkersFor each page, the callgoes to Workday Business Service.
  2. Drag and drop FTPadapter, configure FTP adapter with .csv data file. Do the required mapping.
  3. Drag and drop Assignactivity to update the declared variables as below:

TotalPages and PageCount->PageCount+1.

While loop runs up toPageCount in Workday, each page gets triggered and fetches the users data.

  1. Do the tracking with startTime. Save and activate the flow.

Now the final flow looks like as shown in the below figure:

Figure 01


  1. Once activated, submit the integration. Scheduler starts with the Submit Now action. It processes until it completes all the cycles of fetching Worker’s records respectively to each page.

At Bristlecone, we’re here to help our clients streamline processes so they can extract the most value out of their systems. If you have any questions about the above process or any other Workday-related questions, please send us an email here info@bcone.com!