Solved

Unable to see Views in WorkDay JDBC connection.

  • 24 March 2023
  • 1 reply
  • 47 views

Userlevel 1
Badge

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?

icon

Best answer by prestona 24 March 2023, 22:07

View original

1 reply

Userlevel 1
Badge

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!

Reply