Thursday, 3 April 2025

Workday CCW: The Complete Guide to Core Connector Worker Integrations

Workday CCW: The Complete Guide to Core Connector Worker Integrations

Workday's Core Connector Worker (CCW) is mainly used to sync delta changes (like new hires, job updates, or terminations) since the last integration run. It does this using date launch parameters—specifically, "A L A L" (As of Entry Date, Last Successful Entry Date, As of Effective Date, Last Successful Effective Date). These dates help CCW track only new or modified data, making daily syncs efficient.

While CCW is optimized for delta changes, it can also do full data loads by setting date parameters to the past or using a "Full File Extract" option. However, for large initial syncs, Report-as-a-Service (RaaS) is often better.

Key specs:

Supports up to 200 fields (but performance slows near the limit).
Uses the "Create Integration System" task code.
Template name: "Core Connector Worker".

How many mandatory integration services in CCW?

Workday's Core Connector Worker (CCW) requires four mandatory integration services to function properly.

1.ESB Service (Enterprise Service Bus)
2.Date Launch Parameters
3.Eligibility Criteria (Field Override)
4.Integration Maps

ESB Service
The integration engine that executes CCW, handling data routing and transformation.

Date Parameters
Time filters ("A L A L") that control which data changes get synced.

Eligibility Criteria
Rules filtering which workers/fields to include (e.g., active staff only).

Integration Maps
Field-to-field mappings between Workday and external systems.

All 4 are essential - ESB runs the process, dates select what to sync, eligibility refines the scope, and maps define how data translates.


What is the use of ESB service ?

-This service is used for executing ccw integration, without this service we cannot execute any integration service.
-The ESB (Enterprise Service Bus) service is the engine that powers CCW integrations.
-Without the ESB service, CCW integrations simply won't run. Its main jobs are:

Managing the entire integration process from start to finish
Transforming data between Workday and external system formats
Handling errors and retries if something goes wrong
Ensuring data gets delivered to the right destination

What is date launch parameters in CCW?

Workday CCW uses Date Launch Parameters to filter which worker data gets synced. These four parameters (remember "A L A L") track changes based on timestamps:

-As of Entry Date – Syncs changes added to Workday after this date (e.g., new hires entered in the system).
-Last Successful Entry Date – Automatically saves the last sync date for entry-based changes.
-As of Effective Date – Syncs changes taking effect after this date (e.g., future promotions).
-Last Successful Effective Date – Tracks the last sync for effective-dated changes.

Why it matters:

By default, CCW syncs only delta changes (new/modified data since the last run).
For a full data load, set all dates to the past (like 01/01/2000).
Never leave dates blank—it can cause incomplete syncs or errors.

Example: If your last sync ran on June 1, setting As of Entry Date = June 2 ensures only fresh changes are pulled. The ESB service then processes these filtered updates.

1. As of entry date
2. Last successful entry date
3. As of effective date
4. Last successful effective date.

<< A L A L >>

No comments:

Post a Comment

Workday Business Processes: Full Questions & Answers

Workday Business Processes: Full Questions & Answers 1. List out all the business processes you have configured. Answer: Commonly config...