Manage Workday Data in DBArtisan as a JDBC Source

The CData JDBC Driver for Workday seamlessly integrates Workday data into database management tools like DBArtisan by enabling you to access Workday data as a database. This article shows how to create a JDBC source for Workday in DBArtisan. You can then edit data visually and execute standard SQL.

Integrate Workday Data into DBArtisan Projects

Follow the steps below to register Workday data as a database instance in your project:

1. In DBArtisan, click Data Source -> Register Datasource.
2. Select Generic JDBC.
3. Click Manage.
4. In the resulting dialog, click New. Enter a name for the driver and click Add. In the resulting dialog, navigate to the driver JAR. The driver JAR is located in the lib subfolder of the installation directory.
5. In the Connection URL box, enter credentials and other required connection properties in the JDBC URL.

   To connect, there are three pieces of information required: Authentication, API URL, and WSDL URL.

   Authentication

   To authenticate, specify your User and Password. Note that you must append your Tenant to your User separated by an '@' character. For instance, if you normally log in with 'geraldg' and your Tenant is 'mycompany_mc1', then your User should be specified as 'geraldg@mycompany_mc1'.

   API URL

   The API URL may be specified either directly via APIURL, or it may be constructed from the Tenant, Service, and Host. The APIURL is constructed in the following format: <Host>/ccx/service/<Tenant>/<Service>.

   WSDL URL

   The WSDLURL may be specified in its entirety, or may be constructed from the Service and WSDLVersion connection properties. The WSDLURL is constructed in the following format: https://community.workday.com/sites/default/files/file-hosting/productionapi/<Service>/<WSDLVersion>/<Service>.wsdl

   Built-in Connection String Designer

   For assistance in constructing the JDBC URL, use the connection string designer built into the Workday JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

   java -jar cdata.jdbc.workday.jar

   Fill in the connection properties and copy the connection string to the clipboard.

   Below is a typical connection string:

   jdbc:workday:User=myuser;Password=mypassword;Tenant=mycompany_gm1;Host=https://wd3-impl-services1.workday.com
6. Finish the wizard to connect to Workday data. Workday entities are displayed in the Datasource Explorer.

You can now work with Workday data as you work with any other database. See the driver help documentation for more information on the queries supported by the Workday API.