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!