I just connected with the CData Workday JDBC driver and I am only able to see the Stored Procedures but no views. My connection string looks like this:
jdbc:cdata:workday:User=myuser;Password=mypassword;Tenant=mycompany;Host=https://wd3-impl-services1.workday.com;
What am I missing?
In order to connect to workday with a JDBC connection, you will need to use OAuth for the most stable connection and best data access. WorkDay uses a REST API which has the limitation of not allowing basic authentication, thus blocking the driver from getting schema data when using user and password.
For the best connection, you will want to create a custom OAuth app for your WorkDay environment. There is documentation on how to do this which can be found here:
CData JDBC Driver for Workday - Using OAuth Authentication
Follow along with our “Creating a custom OAuth App” page then you can edit your connection.
After this, your connection string will resemble something more like the following:
jdbc:cdata:workday:Tenant=mycompany;Host=https://wd3-impl-services1.workday.com;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;OAuthClientID=myclientid;OAuthClientSecret=myclientsecret;
I hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.