This page outlines the steps to use the JDBC Driver for CData Connect Cloud.
Note: Before you can configure and use JDBC with CData Connect Cloud, you must first connect a data source to your CData Connect Cloud account. See Connections for more information.
Install the Driver
Follow these steps to download and install the Driver:
Open the Client Tools page of CData Connect Cloud.
In the Dev Tools section, click JDBC.
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 Cloud from your Java application:
Add the driver JAR file to the classpath. The JAR file is located in the
libsubfolder of the JDBC Driver for CData Connect Cloud installation directory.
Note: The .lic file must be located in the same folder as the JAR file.
Some applications automatically populate the driver class. For applications that do not automatically populate it, you must enter it manually. For example:
Provide the JDBC URL. For example:
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:cdata:connect:, and it must only include the AuthScheme setting as OAuth.
Connect to CData Connect Cloud
To connect to CData Connect Cloud, set the AuthScheme in your JDBC connection as OAuth. If the OAuth login page appears in your default web browser, log in to CData Connect Cloud to proceed.
To learn more information about using the JDBC Driver for CData Connect Cloud, click here.