← Back to Hari’s portfolio
HARI KRISHNAN N.S.ON LEARNING & WORK

Workday / Integration design

Choose the Pattern Before the Tool

The questions I want answered before choosing an API, connector, EIB or custom workflow.

In an integration design session, the conversation can reach the tool before it has reached the requirement. Someone mentions an API. Someone else suggests an EIB. Studio enters the discussion because it can handle the complexity.

I want to understand how the data needs to travel first. Who needs it? Who initiates the exchange? What should arrive, when should it arrive, and what happens if it does not?

Those answers give the technology choice a purpose. My aim is to find the simplest design that meets the requirement and leaves the support team with something they can operate.

Write the behaviour before naming the tool

“Send worker data to a vendor” is a starting point. It leaves the difficult questions open.

Does the vendor want a complete population each night, a view of today's eligible workers, or a feed of changes? If a correction is entered today but takes effect last month, what should the recipient receive? If an employee leaves the eligible population, how will the receiving system find out?

I would settle those questions before estimating the build. Eligibility describes who belongs in the feed. Change detection describes what happened. Effective timing describes when a fact applies. Treating them as the same requirement can produce a technically successful integration with the wrong business result.

Branching outbound integration decision flow: manual exchange, packaged solution, connector, delivered API, RaaS, EIB, then custom Orchestrate or Studio. Every choice needs security, recovery and reconciliation checks.
How I work through an outbound design. A “yes” means the option meets the requirement; a gap means I continue assessing. Some solutions combine patterns.

Check what is already available

I check for a suitable packaged integration before committing to a custom build. I want to know what it covers, what needs configuring and who owns updates. A generic connector gives me a foundation to adapt; it is not automatically a complete vendor integration.

I also ask whether automation is justified at all. For an infrequent, controlled exchange, a manual report may be enough. The ongoing cost of an integration belongs in that decision.

My practical test is this: what are we proposing to build that somebody already maintains? Reuse still needs validation. It can save work, but only when the delivered behaviour fits.

An API can simplify the Workday side

I ask early whether the receiving platform can consume a suitable Workday API. If SOAP or REST exposes the data and behaviour we need, that may be the cleanest route. If the requirement is a specific outbound view of the data, I also consider a web-service-enabled custom report through Report as a Service, or RaaS.

If the recipient already handles extraction, my Workday-side work may be largely access configuration and validation. But the exchange still needs an owner for the request, parameters, pagination where applicable, schedule, retries and reconciliation.

That work has an owner even when it is outside Workday. A useful design conversation makes that ownership explicit rather than assuming the endpoint takes care of it.

Choose a connector for its behaviour

When a feed needs change detection, I look for a suitable connector and check exactly what its template supports. Where its output needs reshaping, I assess whether Document Transformation can handle the required format and delivery pattern.

But “we have eligibility criteria” alone does not settle the choice. A report can select a population too. The question is whether we need a selected snapshot or a change-aware feed, and whether the chosen template supports the required behaviour.

Consider a fictional vendor receiving active employees. A filtered snapshot stops showing someone after they leave that population. That does not, by itself, tell the vendor to remove their previous record. We need an agreed removal or reconciliation mechanism. I would test that scenario alongside new entrants, corrections and a rerun after failure.

I test security alongside the output. The integration identity needs the right access to the data, including fields used in eligibility criteria and field overrides. A successful run does not convince me that the output is complete; I want to reconcile what actually arrived.

Keep straightforward file delivery straightforward

For a straightforward outbound file, I consider EIB. I start with the built-in transformation options and then assess whether a small custom XSLT can handle the remaining format requirements. The aim is a delivery flow that remains easy to understand and maintain.

I would review the design again if “a small transformation” starts accumulating lookups, branching, sequencing and complicated recovery. The concern is the support burden we are creating, not the number of lines of XSLT.

This article focuses on outbound choices. An inbound load needs a separate assessment of the supported operation, validation and business-process behaviour.

Evaluate custom workflows deliberately

I include Orchestrate when the requirement calls for an event-driven workflow, API coordination or batch processing. I assess its fit against the trigger, transformations and recovery requirements, and confirm what is available in the tenant.

Studio remains an option when I need more control over processing, multiple calls or complex error handling. I compare the actual flow and the team’s support capability. I would not automatically choose Studio for every complex requirement or Orchestrate simply because the build is new.

The same applies to existing middleware. If another platform owns the cross-system process, that is part of the architecture decision. APIs, connectors and custom workflows are not mutually exclusive boxes.

Choose what you can explain and support

Before concluding the session, I want a clear account of the source, selection logic, timing, delivery and recovery. I want to know who investigates a missing record, how we prove the recipient processed it, and how we rerun safely.

The right pattern should make those answers easier to explain. Building the integration is one part of the work. Giving it a clear operational life is another.

Before asking which Workday tool to use, ask: what exactly must this exchange do, and who will own it when it does something unexpected?