Workday Workday-Pro-Integrations - Workday Pro Integrations Certification Exam

When setting up security for a Core Connector integration system in Workday, you need to know which web service operation the connector template uses. The best way is to run the "Integration Template Catalog report" within your Workday tenant. This report lists all integration templates and should include details about the web service operations they use, making it easy to configure security.

Why This Matters

This method is efficient because it lets you find the information before running the system, which is crucial for setting up permissions correctly. It's surprising that such a specific report exists, as it simplifies a task that could otherwise involve running the system or guessing from API references.

How It Works

Select the report in your Workday tenant to see a list of all Core Connector templates.

Look for the template you're using and find the associated web service operation listed in the report.

Use this information to set up the right security permissions for your integration.

For more details, check out resources likeWorkday Core ConnectorsorWorkday Integrations.

For an XSLT (Extensible Stylesheet Language Transformations) file to be considered valid in the context of Workday integrations (and per general XSLT standards), it must adhere to specific structural and functional requirements. The correct answer is that an XSLT file must containa root element,a namespace, andat least one template. Below is a detailed explanation of why this is the case, grounded in Workday’s integration practices and XSLT specifications:

Root Element:

Every valid XSLT file must have a single root element, which serves as the top-level container for the stylesheet. In XSLT, this is typically the or element (both are interchangeable, though is more common).

The root element defines the structure of the XSLT document and encapsulates all other elements, such as templates and namespaces. Without a root element, the file would not conform to XML well-formedness rules, which are a prerequisite for XSLT validity.

Example:

Namespace:

An XSLT file must declare the XSLT namespace, typically http://www.w3.org/1999/XSL/Transform, to identify it as an XSLT stylesheet and enable the processor to recognize XSLT-specific elements (e.g., , ). This is declared within the root element using the xmlns:xsl attribute.

The namespace ensures that the elements used in the stylesheet are interpreted as XSLT instructions rather than arbitrary XML. Without this namespace, the file would not function as an XSLT stylesheet, as the processor would not know how to process its contents.

In Workday’s Document Transformation integrations, additional namespaces (e.g., for Workday-specific schemas) may also be included, but the XSLT namespace is mandatory for validity.

At Least One Template:

An XSLT file must contain at least one element to define the transformation logic. Templates are the core mechanism by which XSLT processes input XML and produces output. They specify rules for matching nodes in the source XML (via the match attribute) and generating the transformed result.

Without at least one template, the stylesheet would lack any transformation capability, rendering it functionally invalid for its intended purpose. Even a minimal XSLT file requires a template to produce meaningful output, though built-in default templates exist, they are insufficient for custom transformations like those used in Workday.

Example:

Hello, Workday!

Complete Minimal Valid XSLT Example:

Transformed Data

Why Other Options Are Incorrect:

A. A root element, namespace, and at least one transformation: While this is close, "transformation" is not a precise term in XSLT. The correct requirement is a "template," which defines the transformation logic. "Transformation" might imply the overall process, but the specific feature required in the file is a template.

C. A header, a footer, and a namespace: XSLT files do not require a "header" or "footer." These terms are not part of XSLT or XML standards. The structure is defined by the root element and templates, not headers or footers, making this option invalid.

D. A template, a prefix, and a header: While a template is required, "prefix" (likely referring to the namespace prefix like xsl:) is not a standalone feature—it’s part of the namespace declaration within the root element. "Header" is not a required component, making this option incorrect.

Workday Context:

In Workday’s Document Transformation systems (e.g., Core Connectors or custom integrations), XSLT files are uploaded as attachment transformations. Workday enforces these requirements to ensure the stylesheets can process XML data (e.g., from Workday reports or connectors) into formats suitable for external systems. The Workday platform validates these components whenan XSLT file is uploaded, rejecting files that lack a root element, namespace, or functional templates.

Workday Pro Integrations Study Guide References:

Workday Integration System Fundamentals: Describes the structure of XSLT files, emphasizing the need for a root element (), the XSLT namespace, and templates as the building blocks of transformation logic.

Document Transformation Module: Details the requirements for uploading valid XSLT files in Workday, including examples that consistently feature a root element, namespace declaration, and at least one template (e.g., "XSLT Basics for Document Transformation").

Core Connectors and Document Transformation Course Manual: Provides sample XSLT files used in labs, all of which include these three components to ensure functionality within Workday integrations.

Workday Community Documentation: Reinforces that XSLT files must be well-formed XML with an XSLT namespace and at least one template to be processed correctly by Workday’s integration engine.

The scenario involves a Core Connector: Worker integration using the Data Initialization Service (DIS) to export a full file of employee personal data. The vendor requires marital status values to be transformed from Workday’s internal text values (e.g., "Married," "Single") to a specific list of codes (e.g., "M," "S"), and any Workday value not matching the vendor’s list should output "OTHER." Let’s analyze the configuration:

Requirement:Transform the "Marital Status" field values into vendor-specific codes, with a fallback to "OTHER" for unmapped values. This is a field-level transformation, common in Core Connectors when aligning Workday data with external system requirements.

Integration Maps:In Core Connectors,Integration Mapsare the primary tool for transforming field values. You create a map that defines source values (Workday’s marital status text) and target values (vendor’s codes). The "Default" setting in an integration map specifies what value to output if a Workday value isn’t explicitly mapped. Here, setting the default to "OTHER" ensures that any marital status not in the vendor’s list (e.g., a new Workday value like "Civil Union" not recognized by the vendor) is output as "OTHER."

Option Analysis:

A. Configure Integration Maps with a blank Default: Incorrect. A blank default would leave the field empty or pass the original Workday value for unmapped cases, not "OTHER," failing the requirement.

B. Configure Integration Attributes with a blank Default: Incorrect. Integration Attributes define integration-level settings (e.g., file name, delivery method), not field value transformations. They don’t support mapping or defaults for specific fields like marital status.

C. Configure Integration Maps with "OTHER" as a Default: Correct. This uses Integration Maps to map Workday values to vendor codes and sets "OTHER" as the default for unmapped values, meeting the requirement fully.

D. Configure Integration Attributes with "OTHER" as a Default: Incorrect. Integration Attributes don’t handle field-level transformations or defaults for data values, making this option inapplicable.

Implementation:

Edit the Core Connector: Worker integration.

Use the related actionConfigure Integration Maps.

Create a map for the "Marital Status" field (e.g., "Married" → "M," "Single" → "S").

Set theDefault Valueto "OTHER" in the map configuration.

Test the output to ensure mapped values use vendor codes and unmapped values return "OTHER."

References from Workday Pro Integrations Study Guide:

Core Connectors & Document Transformation: Section on "Configuring Integration Maps" explains mapping field values and using defaults for unmapped cases.

Integration System Fundamentals: Highlights how Core Connectors transform data to meet vendor specifications.

The element is the root element in an XSLT document. Itmustinclude:

XSLT Version– This defines the XSLT specification version being used (e.g., version="1.0" or version="2.0").

Namespaces– XSLT operates within an XML namespace (xmlns:xsl="http://www.w3.org/1999/XSL/Transform"), which is required to define the transformation rules.

Breakdown of Answer Choices:

A. XSLT Version & Namespaces✅(Correct)

The element requires both theXSLT versionand thenamespace declarationfor proper execution.

Example:

xml

CopyEdit

B. XSLT Version & Encoding❌(Incorrect)

Encoding (encoding="UTF-8") is a property of the XML declaration (), not an attribute of .

C. XML Version & Namespaces❌(Incorrect)

XML version () is part of the XML prolog, not an attribute of .

D. Namespaces & Encoding❌(Incorrect)

Encoding is not an attribute of .

Final Correct Syntax:

This ensures that the XSLT file is processed correctly.

Workday Pro Integrations Study Guide References:

ReportWriterTraining.pdf – Chapter 9: Working With XML and XSLTcovers XSLT basics, including the required attributes for .

Workday_Advanced_Business_Process_part_2.pdf – Chapter 5: Web Services and Integrationsdetails how Workday uses XSLT for transformations .

The scenario describes a Core Connector: Worker integration configured to output specific fields (Position Title and Business Title) for workers who meet the Integration Population Eligibility criteria (Is Manager = true) and where the Transaction Log service is subscribed to the "Position Edit Event." The integration is launched with specific date parameters, and a test edit is made to Jared Ellis’ position, who is a manager. However, despite the edit being completed with an effective date of 05/24/2024 and an entry moment of 05/24/2024 07:58:53 AM, Jared does not appear in the output. Let’s analyze why and determine the correct configuration element to modify.

In Workday integrations, the Core Connector: Worker uses change detection mechanisms to identify and process updates based on the Transaction Log and date launch parameters. The Transaction Log service captures events such as the "Position Edit Event" and records them with anEffective Date(when the change takes effect) and anEntry Moment(when the change was entered into the system). The integration’s date launch parameters define the time window for which changes are retrieved:

As of Entry Moment:05/25/2024 12:00:00 AM – This specifies the latest point in time for when changes were entered into Workday.

Effective Date:05/25/2024 – This defines the date for which the changes are effective.

Last Successful As of Entry Moment:05/23/2024 12:00:00 AM – This indicates the starting point for entry moments from the last successful run.

Last Successful Effective Date:05/23/2024 – This indicates the starting point for effective dates from the last successful run.

For an incremental run (like this one, since "Last Successful" parameters are provided), Workday processes changes where theEntry Momentfalls between theLast Successful As of Entry Moment(05/23/2024 12:00:00 AM) and theAs of Entry Moment(05/25/2024 12:00:00 AM), and where theEffective Datefalls between theLast Successful Effective Date(05/23/2024) and theEffective Date(05/25/2024).

Now, let’s evaluate Jared Ellis’ edit:

Entry Moment:05/24/2024 07:58:53 AM – This falls within the range of 05/23/2024 12:00:00 AM to 05/25/2024 12:00:00 AM.

Effective Date:05/24/2024 – This falls within the range of 05/23/2024 to 05/25/2024.

At first glance, Jared’s edit seems to fit the date parameter window. However, the issue lies in thetime componentof the date launch parameters. Workday interprets these parameters with precision down to the second. TheAs of Entry Momentis set to 05/25/2024 12:00:00 AM (midnight), which is the very start of May 25, 2024. Jared’sEntry Momentof 05/24/2024 07:58:53 AM is correctly within the range from 05/23/2024 12:00:00 AM to 05/25/2024 12:00:00 AM. However, the Transaction Log subscription to "Position Edit Event" relies on the change being fully processed and available in the log by the time the integration runs.

The integration might have run at a point where the effective date window or the subscription logic did not correctly capture the event due to a mismatch in how theEffective Dateis evaluated against theLast Successful Effective Date. Specifically, if the integration only processes changes with anEffective DatestrictlyaftertheLast Successful Effective Date(05/23/2024) up to theEffective Date(05/25/2024), and the logic excludes changes effective exactly on 05/24/2024 due to a boundary condition or a timing issue in the transaction log, Jared’s change might not be picked up.

To resolve this, modifying theDate launch parametersis necessary. Adjusting theAs of Entry Momentto a later time (e.g., 05/25/2024 11:59:59 PM) or ensuring theEffective Daterange explicitly includes all changes effective on or after 05/23/2024 through 05/25/2024 would ensure Jared’s edit is captured. This adjustment aligns the time window to include all relevant transactions logged before the integration run.

Let’s evaluate the other options:

A. Integration Population Eligibility:This is set to "Is Manager = true," and Jared is a manager. This filter is working correctly and does not need modification.

B. Integration Field Attributes:These are configured to output Position Title and Business Title, and the edit was to the Job Profile (part of Position Data). The fields are appropriately configured, so this is not the issue.

D. Transaction Log Subscription:The subscription is set to "Position Edit Event," which matches Jared’s edit. The subscription type is correct, so no change is needed here.

Thus, the issue stems from the date launch parameters not fully encompassing the timing of Jared’s edit in the Transaction Log, makingC. Date launch parametersthe correct answer.

Workday Pro Integrations Study Guide References

Workday Integrations Study Guide: Core Connector: Worker– Section on "Change Detection Using Transaction Log" explains how Transaction Log subscriptions filter events based on date parameters.

Workday Integrations Study Guide: Launch Parameters– Details the role of "As of Entry Moment" and "Effective Date" in defining the scope of incremental runs.

Workday Integrations Study Guide: Incremental Processing– Describes how "Last Successful" parameters establish the baseline for detecting changes in subsequent runs.