Connect to Anaplan Data from a Connection Pool in Jetty

The CData JDBC driver for Anaplan is easy to integrate with Java Web applications. This article shows how to efficiently connect to Anaplan data in Jetty by configuring the driver for connection pooling. You will configure a JNDI resource for Anaplan 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 Anaplan data source at the level of the Web app, in WEB-INF\jetty-env.xml.

   
   <Configure id='anaplandemo' class="org.eclipse.jetty.webapp.WebAppContext">
       <New id="anaplandemo" class="org.eclipse.jetty.plus.jndi.Resource">
       <Arg><Ref refid="anaplandemo"/></Arg>
       <Arg>jdbc/anaplandb</Arg>
       <Arg>
         <New class="cdata.jdbc.anaplan.AnaplanDriver">
           <Set name="url">jdbc:anaplan:</Set>
           <Set name="OAuthClientId">your_client_id</Set>
           <Set name="OAuthClientSecret">your_client_secret</Set>
           <Set name="CallbackURL">your_callback_url</Set>
           <Set name="Region">US1</Set>
           <Set name="InitiateOAuth">GETANDREFRESH</Set>
         </New>
       </Arg>
     </New>
   </Configure>
   

   Authenticating to Anaplan

   The driver supports authenticating with Basic, Certificate, or OAuth. In every case, set Region to the region where your Anaplan account data is hosted (e.g., US1, which is the default).

   Using Basic Authentication

   Set AuthScheme to Basic, then supply your Anaplan User and Password. If your workspace uses single sign-on (SSO), you must be assigned as an Exception User to use Basic authentication.

   Using Certificate Authentication

   Set AuthScheme to Certificate, then supply the Certificate, CertificateType, and PrivateKey properties (and the matching CertificatePassword / PrivateKeyPassword if either is encrypted). The certificate must be a CA-issued X.509 certificate registered with your Anaplan tenant administrator.

   Using OAuth Authentication

   Register a custom OAuth application in Anaplan, then set the following properties:

   • OAuthClientId: The client Id assigned when you registered your custom OAuth application.
   • OAuthClientSecret: The client secret assigned when you registered your custom OAuth application.
   • CallbackURL: The redirect URI defined when you registered your application.
   • InitiateOAuth: Set to GETANDREFRESH to have the driver manage the OAuth token exchange and refresh automatically.

   See the Getting Started chapter of the help documentation for a guide to creating a custom OAuth app and using OAuth.

4. Configure the resource in the Web.xml:

   
     jdbc/anaplandb
     javax.sql.DataSource
     Container
   
   

5. You can then access Anaplan with a lookup to java:comp/env/jdbc/anaplandb:

   InitialContext ctx = new InitialContext();
   DataSource myanaplan = (DataSource)ctx.lookup("java:comp/env/jdbc/anaplandb");
   

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.