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 a 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 the Assign activity 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, then click Close.

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

Click Validate, then click Close.

  1. Inside the While activity, drag and drop Workday endpoint with the Human Resources module and GetWorkers. For each page, the call goes to Workday Business Service.
  2. Drag and drop the FTP adapter, and configure the FTP adapter with .csv data file. Do the required mapping.
  3. Drag and drop the Assign activity to update the declared variables as below:

TotalPages and PageCount->PageCount+1.

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

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

The final flow should look like the illustration below.

Figure 01


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

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 email info@bcone.com.