Lance Austin on 05 Dec 2014 22:00:13
I would love to have the ability to do reporting against Workday. We leverage it as our global HR platform. It has some really good reporting but it would be nice to have the ability but it would be great to be able to share reporting with SharePoint and Power BI so that we can surface non sensitive data up in dashboards.
- Comments (70)
- Merged Idea (2)
RE: Workday HR
Definitely there is a need for this connector! Workday is currently being implemented and as we want to have one single source of reporting, we need to have a direct connection to our WD environments connected from PowerBI.
RE: Workday HR
I would love to have the ability to do reporting against Workday. We leverage it as our global HR platform. It has some really good reporting but it would be nice to have the ability but it would be great to be able to share reporting with Power BI so that we can surface non sensitive data up in dashboards.
RE: Workday HR
Hi!
With more companies going with Workday for their HCM and Financials, it will be a great value add to seamlessly connect to Workday datasource. This will be a value add for us!
Thanks
RE: Workday HR
Any update on this? We need Microsoft to listen to their customers and build a Workday HR connector!
RE: Workday HR
ZappySys has announced Generic SOAP / REST API connector which you can use to pull data from WorkDay SOAP Web Service in Power BI or other ODBC tools. Check below link https://zappysys.com/blog/connect-workday-power-bi-import-soap-data/
Here is sample SQL query
SELECT * FROM $
/*Below WITH clause is optional, uncomment parameter(s) values you like to set
which are different than DSN properties.
*/
WITH(
Src='https://xxxxxxxxxx.workday.com/ccx/service/yyyyyyyyy/Human_Resources'
--,ElementsToTreatAsArray='wd:Worker'
--,DataConnectionType='HTTP'
--,SoapWssPasswordType='PasswordDigest'
--,UserName='testuser001'
--,CredentialType='SoapWss'
--,Filter='$.env:Envelope.env:Body.wd:Get_Workers_Response.wd:Response_Data.wd:Worker[*]'
--,RequestContentTypeCode='TextXmlUtf8'
--,RequestMethod='POST'
--,Header='SOAPAction: ""'
,RequestData='
.......... .......... ..........
.......... FROM SOAPUI .........
.......... .......... ..........
'
)
RE: Workday HR
This would be invaluable to us as we implement Workday. Otherwise we'll need to use SOAP and call Workday's API, import to SQL then use SQL as the data source. This is not really the most efficient way of doing this - a connector would be far better!
RE: Workday HR
Would be awesome!
RE: Workday HR
Any update on this? Workday is a popular HR system and this would be a great feature to have.
We have created our HR packaged solution based on that but not using a direct connector.
See here a demo version of that: https://powerbi.microsoft.com/en-us/partner-showcase/agile-analytics-hr-analytics/
RE: Workday HR
Did this ever got completed. I am searching for PowerBI - Workday connector... Found this post on top but its from 2014
RE: Workday HR
Workday API is XML SOAP Service. ZappySys has created an easy to use ODBC drivers for REST / SOAP API access so you just write SQL queries to access data in any ODBC compliant apps (e.g. Power BI, Tableau, Qlik, SSRS).
Please refer this article to learn how to call SOAP API (e.g. Workday API) in Power BI
https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/
Hope this helps!