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?
Best answer by prestona
View originalIn 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 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
