Does anyone have a Data Model (Star Schema ideally) visual they can share for new users to WorkDay intending to use PowerBI with the adapter?
Best answer by Ethem Q
View original
Userlevel 3
Hi,
If with "Star Schema" you are referring to some sort of a diagram that showcases how all of the different tables relate to each other then unfortunately we do not have any support for something like that as our Workday connector is simply pulling the data as is via the Workday API. This is the Data Model that we expose for Workday:
https://cdn.cdata.com/help/JWJ/powerbi/pg_datamodel.htm
You can have a look at the WQL Schema as well as the REST Schema if you are looking for particular tables. Also, if you would be looking to understand how the tables relate to each other you can do that by making use of the system table "sys_foreignkeys" :
https://cdn.cdata.com/help/JWJ/powerbi/pg_table-foreignkeys.htm
In case you have any questions or issues feel free to send those over at support@cdata.com or you can always submit a support case here.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers