Connect to Workday Data from a Connection Pool in Jetty

The CData JDBC driver for Workday is easy to integrate with Java Web applications. This article shows how to efficiently connect to Workday data in Jetty by configuring the driver for connection pooling. You will configure a JNDI resource for Workday in Jetty.

Configure the JDBC Driver for Salesforce as a JNDI Data Source

Follow the steps below to connect to Salesforce from Jetty.

1. Enable the JNDI module for your Jetty base. The following command enables JNDI from the command-line:

   java -jar ../start.jar --add-to-startd=jndi
2. Add the CData and license file, located in the lib subfolder of the installation directory, into the lib subfolder of the context path.

3. Declare the resource and its scope. Enter the required connection properties in the resource declaration. This example declares the Workday data source at the level of the Web app, in WEB-INF\jetty-env.xml.

   <Configure id='workdaydemo' class="org.eclipse.jetty.webapp.WebAppContext"> <New id="workdaydemo" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg><Ref refid="workdaydemo"/></Arg> <Arg>jdbc/workdaydb</Arg> <Arg> <New class="cdata.jdbc.workday.WorkdayDriver"> <Set name="url">jdbc:workday:</Set> <Set name="User">myuser</Set> <Set name="Password">mypassword</Set> <Set name="Tenant">mycompany_gm1</Set> <Set name="Host">https://wd3-impl-services1.workday.com</Set> </New> </Arg> </New> </Configure>

   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

4. Configure the resource in the Web.xml:

   jdbc/workdaydb javax.sql.DataSource Container

5. You can then access Workday with a lookup to java:comp/env/jdbc/workdaydb: InitialContext ctx = new InitialContext(); DataSource myworkday = (DataSource)ctx.lookup("java:comp/env/jdbc/workdaydb");

More Jetty Integration

The steps above show how to configure the driver in a simple connection pooling scenario. For more use cases and information, see the Working with Jetty JNDI chapter in the Jetty documentation.