JDBC

This page outlines the steps to use the JDBC driver for Embedded Cloud.

Prerequisites

Before you can configure and use JDBC with Embedded Cloud, you must first connect a data source to your account. See Sources for more information.

Install the Driver

Download and run the JDBC setup file for your operating system.

• Mac Download
• Windows Download
• Linux Download

Create a JDBC Data Source

Follow these steps to create a JDBC data source to connect to Embedded Cloud 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 Connect AI 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. For example:

   jdbc:connect:AuthScheme=OAuth;
   

   or

   jdbc:cdata:connect:AuthScheme=OAuth;
   

   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 only include the AuthScheme setting as OAuth.

Designate a Log File

You can designate a log file for the JDBC driver in the Advanced tab of Connection Properties. You can also change the verbosity of the log file for greater detail.

Learn More

To learn more information about using the JDBC driver for Embedded Cloud, click here.