This page outlines the steps to use the JDBC Driver for CData Connect.

Prerequisites

Before you can configure and use JDBC with CData Connect, you must first connect a data source to your CData Connect account. See Data Model for more information.

Install the Driver

Follow these steps to download and install the Driver:

1. Open the Clients page of CData Connect.

2. In the Dev Tools section, locate JDBC and click Download.

3. Download and run the setup file.

Creating a JDBC Data Source

Follow these steps to create a JDBC data source to connect to CData Connect from your Java application:

1. Add the driver JAR file to the classpath. The JAR file is located in the lib subfolder of the JDBC Driver for CData Connect installation directory.
   Note: The .lic file must be located in the same folder as the JAR file.

2. Some applications automatically populate the driver class. For applications that do not automatically populate it, you must enter it manually. For example:

   cdata.jdbc.connect.ConnectDriver
   

3. Provide the JDBC URL in the form URL=http://hostname:port/rest.rsc;User=my_user;AuthToken=my_token;. For example:

   jdbc:connect:AuthScheme=AuthToken;URL=http://localhost:8080/rest.rsc;User=user1;AuthToken=abcd1234;
   

   or

   jdbc:cdata:connect:AuthScheme=AuthToken;URL=http://localhost:8080/rest.rsc;User=user1;AuthToken=abcd1234;
   

   The second format above can be used to ensure you are using the CData driver whenever there is a conflict in your application between drivers using the same URL format. The URL must start with either jdbc:connect: or jdbc:cdata:connect:, and it must include the AuthScheme setting as AuthToken.

Connect to CData Connect

To connect to CData Connect, set the following connection settings:

• AuthScheme—select Basic.

• URL—enter [baseurl]/rest.rsc/, substituting the base URL of your CData Connect server for [baseurl]. For example, localhost:8080 or myConnectInstance.cdata.com.

• User—enter your CData Connect username as defined on the Users page.

• Password—enter the Authtoken for the user.

Learn More

To learn more information about using the JDBC Driver for CData Connect, click here.