Workday + CData: Creating Integration System Users

  • 6 November 2023
  • 1 reply
  • 64 views

Userlevel 4
Badge
  • Community Manager
  • 4 replies

 

Workday allows you to create Integration System Users (ISUs) that can own and run reports across your Workday ecosystem. This same user can be used as a sort of “superuser” in Connect Cloud to offer broader access to your Workday and Prism Reports.

This article is a guide on creating an ISU for use in Connect Cloud.

Create an Integration System User (ISU)

All authentication flows supported by Connect Cloud can be used with either a normal user or an ISU. If you do not already have an ISU, then you need to create it first:

  1. Open the Create Integration System User form.
  2. Enter a name for the user in User Name.
  3. Enter a password for the user and verify the password. You will need to save this password if you plan to use this ISU with Basic authentication in SOAP.
  4. Enable the Do Not Allow UI Sessions option. This helps secure the ISU from being used outside Connect Cloud.

ltcUr7-_KO2nb5UPkrWBsrvgwpxQ47qvRGhF-vGalEwRQDSTISJiCjkZaiuk3ouczxgTW2rczZj-EuRj9lbSRAiKQ9xRaaliaKXueTbx_L3WjRNVIsjh2_VHeIrDKsNyk9CQoon580LY6bAalZOIooA

The ISU must also be assigned to a security group:

  1. Open the Create Security Group form.
  2. Select Integration Security Group (Unconstrained) for the security group type.
  3. Enter the name of the security group to create and click OK.
    R1_OW61fbfd5JOLH7egPazCqLdTSnTJB6bGK86PGTmcipcpdq8jPFPFyXRnU4tGKlAEUjzOFxRqz2Kk_SHYCtofdhTfCqvVBKkGC1i1C5tCyKRYgatSl82bJWw2xfvQPH-6_KbbwehEluht2G2rpmJc
  4. Workday creates the group and displays the Edit Integration Security Group form.
  5. Open the Integration System Users list and add the ISU you created.
  6. Click OK.
    Zpq0B69DoHFDxyMo5XmA7Kc8EheyFexxIPVhEJPhxq_ddeP0dXYzdDPSPS7YHLlwb6ttrd_vnOpBxhQSTffvMUfIDZ2RKF9Tc4vwuPTz_FvAsAxYRdb-csFJbLwoHZvsvsiFQu4b3YTo1cJcgh4ImVs

Assign Security Domains to the ISU

Once you have an ISU, you need to grant it the necessary permissions for the Workday service you wish to use. This process must be done individually for each security domain you wish to assign.

  1. Open the View Domain report and enter the name of the security domain.
  2. Click on the magnifying glass (search) icon under Domain Security Policy.
  3. Click the ellipses (...) button and select Domain Security Policy > Edit Permissions.
  4. In the task permissions section, click the plus (+) button and enter the Integration Security Group.
  5. Enable the View permission, and the Modify permission if you want to allow the ISU to write data.
  6. Click OK.

XZ0fGxIzf861G6G6lEx1MNr20xM26n9iXtgurmWgUrajejRrDJI4g1bI-gpBQGO9tJGQ7JU25zAED3fZK0gMJVkc_fswvHPirEr1_p8WzLlTdYDmvQ98ELBPq-PcyHuxRzYYNl9SsxDDlBEuxFquJHM

Once you have made all the necessary changes, use the Activate Pending Security Policy Changes form to review and approve the domain assignments.

Connect Cloud requires ISUs that can access different domains depending on the services you want to use. Note that these domains are the minimum requirements to use Connect Cloud with the service at all. Most data sources (and reports using them) require additional permissions, which are found by searching for domains that grant access to the specific data source.

  • WQL requires these domains: Workday Query Language, Reporting Audits
  • Reports do not require any specific domains, but any report you want to access must be shared with the ISU using the Share tab in the report definition. You can either share the report with all authorized users or share the report with the ISU specifically.
  • SOAP does not require any specific domains.

More information & free trial 

The guide above helps you get the most of your CData connections to Workday. To get more information about working with your Workday data through CData's connectivity solutions, check out our Workday integration page. Sign up for a free trial of Connect Cloud or download a trial of any of our drivers or connectors to get started with easier access to your Workday data today! 


1 reply

Userlevel 1
Badge

Thanks. This gets me pointed in the right direction.

Any documentation for howto / best practices to export from Workday to S3 for Business Continuity and potential future migration of data to another HCM platform? Hoping there’s a way to do this that doesn’t involve generating and migrating a bunch of Workday reports.

Reply