Workday Connector

Used for OneTrust Data Discovery, the Workday Connector helps scan and return data samples from cloud-based systems containing human resources and financial management services information.

Pod Residency

rdbms-scanner

Connection Method

JDBC URL

OneTrust recommends to adhere to your organization's security and infrastructure policy and include system engineer resources or other qualified subject matter experts to set up credentials on data sources. For specific instructions for how to enable these credentials, refer to your data source's implementation documentation, knowledge base and/or support resources.

1. Basic authentication for username and password is required at minimum. The connection parameters must be included in the credential JSON.

2. Configure the following connection parameters:

   • ConnectionType: SOAP

   • AuthSchem: Basic

   • User: Workday user account name

   • Password: password used to authenticate user

   • Tenant: tenant for the account

   • BaseURL: the base URL for the REST API endpoint in the View API Clients page

   JSONCopy

   { "connectionUrl": "jdbc:workday:User=<username>;Password=<password>;Host=<host>.workday.com;Tenant=<tenantname>" }

   { 
       "connectionUrl": "jdbc:workday:User=<username>;Password=<password>;Host=<host>.workday.com;Tenant=<tenantname>" 
   }

3. The JDBC URL should be formatted as follows:

   JSONCopy

   { "connectionUrl": "jdbc:workday:ConnectionType=SOAP;AuthScheme=Basic;Tenant=<Tenant>;RTK=<RTK>;BaseURL=<DOMAIN>.myworkday.com;User=<User@Tenant>;Password=<Password>;", "driver_class_name": "cdata.jdbc.workday.WorkdayDriver" }

   { 
       "connectionUrl": "jdbc:workday:ConnectionType=SOAP;AuthScheme=Basic;Tenant=<Tenant>;RTK=<RTK>;BaseURL=<DOMAIN>.myworkday.com;User=<User@Tenant>;Password=<Password>;", 
       "driver_class_name": "cdata.jdbc.workday.WorkdayDriver" 
   }

4. You can use either of the following formats for the JDBC URL:

   • jdbc:workday:ConnectionType=SOAP;User=myuser;Password=mypassword;Tenant=mycompany;BaseURL=https://wd3-impl-services1.workday.com

   • jdbc:cdata:workday:ConnectionType=SOAP;User=myuser;Password=mypassword;Tenant=mycompany;BaseURL=https://wd3-impl-services1.workday.com