Workday is a SaaS for financial management, human capital management, and a student information system.

This article provides an overview to get started with the Workday connector in Peliqan. Please contact support if you have any additional questions or remarks.

Connect Workday

Create an app (API client) in Workday first.

Settings:

• Client Grant Type: select “Authorization Code Grant”
• Access Token Type: select “Bearer”
• Redirection URI: enter https://oauth.peliqan.io/
• Check: “Non-Expiring Refresh Tokens”
• Add all scopes
• Check “Include Workday Owned Scope”
• Copy the Client ID and Client Secret (only shown once) and enter them in the connection in Peliqan

Example:

Sync data from Workday reports to the data warehouse

Getting data from Workday reports can be done using a custom pipeline script in Peliqan. The report must be converted to WQL in Workday first.

In Workday, go to “Convert Report to WQL” and select the report to convert.

Workday will display the WQL query to use, to fetch the data from the report.

Next, use a custom pipeline script in Peliqan to fetch the data.