How can we help?

Search

Workday Integration

  • Updated

TIQ Software legacy customers using the Trajectory IQ platform can integrate with Workday to reflect course completion status.


Overview

TIQ Software uses the Workday Enterprise Interface Builder (EIB) tool to read a .CSV report generated by our Trajectory IQ API, to update the course completion status in Workday.

Workday integrations for course completion require Single Sign-On.


Summary

  • TIQ automatically generates a .CSV report on a schedule (e.g. every 2 hours).
    • This report includes all users who have started and/or completed a TIQ course in your system, along with their completion status for each course.
  • TIQ automatically uploads the .CSV report to a secure location (e.g. your corporate FTP server).
  • The partner creates a Workday Enterprise Interface Builder (EIB) that reads the .CSV report generated by TIQ.
  • The EIB automatically adjusts each employee’s course completion status in Workday, running on the same schedule as the TIQ report (with a 10 minute delay for example).

Using this method, completion status can be reflected retroactively for courses that were already completed, before the Workday integration implementation.


Partner steps

  1. Setup your courses
    • Confirm that each TIQ course has been added as an external course in Workday 
    • Provide TIQ with the Workday course name ID to be included in the .CSV - Workday will generate this name automatically but you can adjust it (e.g. Course_Name_1)
  2. Create your EIB
    • Create a recurring Enterprise Interface Builder (EIB) that reads the CSV report every 2 hours that will automatically:
      • Lookup the employee by employee ID
      • Lookup the course by course name
      • Set the completion status based on a column in the report that will contain the text “Complete” or “Incomplete”
  3.  FTP Access
    • Give TIQ access to a specific folder on your FTP server as the secure location for our system to upload the report on a schedule (e.g. every 2 hours)
  4.  SSO/SAML Adjustments
    • Add the Workday employee ID to the SSO SAML assertion set up for TIQ
      • TIQ will store this information in our identity provider (Okta) and use it to identify employees in the CSV report
  •  

TIQ steps

  1. Trajectory IQ API
    • TIQ will setup the .CSV report to be generated automatically on a schedule
    • Automatically upload the report to the partner's secure location (e.g. FTP server)
  2. SSO/SAML Adjustments
    • Add the Workday employee ID to the partner's user profile in our identity provider (Okta)

Frequently Asked Questions

Where can I find the Workday documentation on EIBs and on this integration?

  • You can find the EIB documentation here.
  • Reference Admin-Guide-Integrations.pdf and search the document for Inbound EIBs

Does course completion status get reflected in Workday instantly? 

No. Workday completion status only gets reflected after the Workday EIB has processed a new scheduled version of the .CSV report (e.g. every 2 hours).

Can I see a sample TIQ report that gets uploaded to our FTP server?

Our report only contains information already included in the SAML assertion, as well as the completionStatus, completedDate and courseID.

tiq-software-workday-sample-report.png

 

Was this article helpful?