How do you do complex integrations with Workday?

What is the Workday integration platform ?

Workday est un logiciel SaaS* de gestion des ressources humaines et financières. La gestion des données s’effectue essentiellement à travers des rapports et des intégrations de données.

Workday Studio, qui sera présenté ici, est un outil permettant de créer des intégrations complexes de données pour Workday. Il s’agit d’un environnement unifié, basé sur Eclipse**, pour développer, déployer et mettre à jour des intégrations complexes, s’exécutant dans le cloud de Workday.

Workday Studio est un parfait exemple d’outil Low code***, dans lequel on crée des assemblages de blocs réutilisables.

Le code source des intégrations est basé sur le protocole XML, mais tel un module d’Eclipse, Studio supporte aussi la customisation Java.

Three Workday tools to build integrations

In Workday, there are three types of integrations – Cloud Connect, Enterprise Interface Builder and Workday Studio. Each has its own benefits and limitations.

Workday’s first tool: Cloud Connect

The first type are Cloud Connect integrations.

These are standardized predefined integrations, called connectors, supported and maintained by Workday. There are a number of useful connectors for many use cases. They significantly reduce the development time needed to build a complete integration. Each connector is configurable to suit different needs.

The benefits of this approach are:

• Access to a set of predefined integrations;
• Low cost, low risk, and quick to deploy with no need to code;
• Integrations fully supported by Workday, certified and tested through regular updates and fixes.

These integration models should be the first choice when building new integrations, if the desired model exists. These integrations can then be enriched by data transformations or Studio integrations.

Workday’s second tool: Enterprise Interface Builder

The second type of integration is the Enterprise Interface Builder (EIB).

TheEIB tool provides an easy-to-use, guided graphical interface that allows integrations to be set up with little or no programming. This tool is used to create simple data input or output integrations. They constitute between 40 and 50% of all integrations used. Of these, up to 90% are outbound integrations and use Workday reports as data sources. However, ISBs are limited. Each integration supports only one data source and one transformation. ISBs are to be used to create low data volume and low complexity integrations.

Workday’s third tool: Workday Studio

Workday Studio, the third type, is used for other, often more complex integrations. It allows a great flexibility of creation. Generally, the following cases of using Studio can be cited:

• several data sources;
• efficient and scalable process;
• source control, unit tests, debugging… ;
• handling of complex errors, different reaction depending on conditions ;
• complex, logical loops, depending on external variables or dynamic data;
• large data sets to transfer.

Workday Studio: the most complete integration tool

• Workday Studio integrations are developed in distinct phases:
  Design: building assemblies in Studio
• Deployment: connect to the Cloud directory and deploy theintegration in Studio
• Configuration: configuration of services required by theStudio integration system, such as integration maps, transports, permissions or notifications, to be performed in theWorkday application
• Launch: launch the integration either from Studio or from theWorkday application
• Monitoring: track the progress of theintegration from within Workday Studio or the Workday application. It is also possible to access a consolidated report of the integration process once it is complete.

The design phase is the most time consuming, as it involves the entire construction of the integration. The following phases follow each other quite quickly.

Here are the different assembly tools presented below.

Workday Studio: API connection

One of the main resources of Workday Studio is the connection to Workday’s API****.

The first method of using Workday APIs is through web services and the SOAP protocol. Workday web services are used to collect and update data in Workday. Example: the Change Job web service allows you to change the assignment of a person. Studio provides the tools to configure, test and trigger web service requests. SOAP requests provide access to Workday data and are secured by Workday’s security protocol.

The second method ofusing Workday APIs is through Workday reports as data sources. This allows, thanks to the principle of RaaS (Report as a Service), to use Workday reports as web services. They can be called directly in the Studio integrations through REST requests.

The third method ofusing Workday APIs is a synchronous request/response transport that sends requests from Workday to a URL through an HTTP protocol. This can be done via SOAP or REST requests.

Workday Studio: using blocks

In Workday Studio, an integration is developed through an assembly using the Workday Studio visual assembly editor.

An assembly is a graphical representation of an integration system. It is composed of different configurable components (or blocks) each having a functionality: creation and manipulation of variables, format transformation, error handling, etc.

Individual components are linked together to form processing chains, and define integration. The outgoing message of each component becomes the input of the component to which it is connected. The assembly editor offers complete freedom on how to connect components together.

Elementary components provide a way to connect processing steps together in processing chains. Advanced components provide a way to dynamically control how assembly execution moves through the processing chain.

The assembly editor provides a wide range of components to manipulate messages and communicate with other systems through various protocols such as FTP, SFTP, SMTP (email), HTTP and HTTPS. The assembly editor also supports message transformations using XSLT (Extensible Stylesheet Language Transformations). XSLT is a form of XML-to-Text mapping called Text Schema.

There are two representations of the assembly. The first is a graphical representation, displayed in the default Design tab. A Source tab also exists, and represents the XML source code of the integration. It is best to add and configure the assembly components using the editor, not directly by editing the XML components in the Source tab.

Once the assembly is completed and saved, it is deployed to Workday. Then the integration is launched by choosing the launch settings, either in Studio or in theWorkday application.

Assemblies provide a number of features to enable the creation of scalable integrations. All integrations must be developed in a scalable and adaptable manner. It must be assumed that the data sources they process can be arbitrarily large. For example, with each processing of item information, it should be assumed that the number of items can increase to an arbitrary number. The fundamental approach to ensuring that integrations are scalable is to use components called splitters and aggregators. They allow you to split the data source into individual records (e.g. one item).

These components are necessary to use. Indeed, as a SaaS* software, there is no direct access to the Workday database. It is therefore necessary to compensate with as many good optimization practices as possible. In addition, an integration will be stopped after four hours of treatment. So you need to be able to run integrations in less than four hours, even with large volumes of data.

Workday Studio: Error Control and Management

Integration events include a set of logs used for diagnosing errors in integrations. This includes the launch request, the server console log, and the performance profile log in CSV format. The consolidated report summarizes all this in XML format. It is available for ISBs and some connectors but is more useful for errors in Studio integrations.

These control elements can be found in Workday Studio as well as in theWorkday application.

In addition, Workday Studio contains a debugger to detect and identify errors in a program. It allows you to visualize the execution of the program by placing breakpoints, which suspends the launched integration. By going step by step, it is possible to examine the content of the variables and thus find out where the errors come from.

Workday Studio : support

Workday Studio can be a difficult tool to grasp and use, especially without certification. There is not much content (on Stack Overflow for example) to help us. There are two main ways to find the answers to our questions, besides YouTube videos and trainings.

The first is Workday Community. It’s a collaborative space where you can :

• Post/read articles on best practices
• Find many solved problems, like Stack Overflow, on the forum
• Ask a question on the forum, if it does not already exist
• Ask a question directly to Workday support, who can provide answers individually, by answering the ticket, or by call
• Paying for Office Hours, which allows for an interview with Studio experts

The second is Help Contents. This is a section directly in Studio that gives some syntax and uses of functions.

Conclusion on data integration with Workday Studio

What I like most about Workday Studiois the diversity of the blocks, which bring together a wide range of functions. The freedom of use of these blocks allows you to create precise and complete integrations.

However, the handling of Studio is not completely intuitive, and the help is not complete enough on the internet, which requires many empirical tests. You also need to pay attention to the optimization of integrations, which requires the use of good practices and a good knowledge of Studio.

Don’t wait, contact us now to learn more about how we can help you get the most out of Workday Studio.

With SQORUS consultants, use Workday effectively and make informed decisions to achieve your goals.

* SaaS: Software as a Service = Application software solution hosted in the cloud

** Eclipse: IDE*** written in Java, now multi-language and multi-platform

*** Low code: Software development mode that hides all or part of the complexity of the application’s source code

**** API : Application Programming Interface = Software interface that allows to connect a software or a service to another software or service in order to exchange data and functionalities

***** IDE : Integrated Development Environment

À lire également dans notre dossier “gouvernance projet IT ” 

• Révolutionnez vos applications avec les nouvelles fonctionnalités APEX 23.2
• Simplifiez vos processus de validation avec APEX 23.1
• Le PMO, un rôle qui émerge avec la transformation des organisations
• Quelles sont les nouvelles fonctionnalités d’Oracle Integration Cloud Gen3 ?
• Comment faire des intégrations complexes avec Workday ?
• Plateforme Lowcode : le futur du développement d’applications ?
• L’utilisation de UIPATH comme solution RPA
• Comitologie projet : les instances de gouvernance d’un projet IT et leurs rôles
• Pilotage et gouvernance d’un projet SI Finance : quels profils impliquer ?
• Pilotage et gouvernance d’un projet IT : quels profils impliquer ?
• Gouvernance projet : quel rôle pour le comité de pilotage ?
• Les acteurs d’une équipe projet : organisation, rôle et compétences
• Le responsable SI au cœur du développement et de l’évolution des systèmes
• Responsable SIRH : quel rôle dans l’évolution des Systèmes d’Information RH ?
• Chef de projet SI : quel rôle et responsabilité dans un projet SI ?
• Consultant fonctionnel : un rôle proche des processus métier
• Consultant technique : un métier au cœur du développement technologique
• Architecte solution : un métier qui gère développement et déploiement
• Consultant DevOps : rôle, missions et compétences en développement
• Délégué à la protection des données (DPO) : quels rôles et missions ?
• RSSI : un travail clé au sein des métiers pour la sécurité des systèmes
• Le service delivery manager au cœur du pilotage des équipes
• Scrum master, un métier clé pour la gestion de projet Scrum
• Data scientist : un métier stratégique au service de la Direction
• MOA / MOE : comment les rôles se répartissent-ils sur un projet de mise en œuvre d’un système d’information ?