topic Re: Accessing Workday Data with SAS in SAS Programming

Accessing Workday Data with SAS

jkotek — Wed, 21 Sep 2022 13:51:13 GMT

Good morning, I'm looking for a way to access Workday data directly from SAS. Any help would be appreciated.

Thanks,

Jeff

Re: Accessing Workday Data with SAS

ballardw — Wed, 21 Sep 2022 14:38:03 GMT

Since there really isn't any truly standard "workday" definition you will need to provide what your definition of "workday" is for your project.

Pieces likely to be involved: day of week can be retrieved from a SAS date value, specific holidays can also be determined from SAS date values though non-US holidays require additional work to set up.

Re: Accessing Workday Data with SAS

ChrisHemedinger — Wed, 21 Sep 2022 14:39:16 GMT

I believe that Workday has APIs you can use. Using PROC HTTP you can call those APIs, similar to the way you might use cURL.

It looks like the Workday API documentation is restricted to verified customers/developers, so you may need to create a community account at
https://community.workday.com and be approved for access. Since I cannot see the doc, I can't provide better guidance/examples.

I suspect one of the biggest initial challenges will be authentication. Most enterprise-style APIs will use OAuth2 or similar mechanism to get an access token and refresh that token for new access every time you use it. We have several examples of that type of interaction (ex: ).

Re: Accessing Workday Data with SAS

Reeza — Wed, 21 Sep 2022 15:03:17 GMT

Workday data lives in the cloud and is relational IIRC. We're having our IT team build some data layers for us from the data to then surface on Azure.