Creating a JDBC Data Source

You can create a JDBC data source to connect from your Java application. Creating a JDBC data source based on the JDBC Driver for CData Connect consists of three basic steps:

• Add the driver JAR file to the classpath. The JAR file is located in the lib subfolder of the installation directory.
• Provide the driver class. For example:
  

  cdata.jdbc.connect.ConnectDriver

• Provide the JDBC URL. For example:
  

  jdbc:connect:AuthScheme=basic;URL=http://hostname:port/rest.rsc;User=my_user;Password=my_password;
  
  or
  
  jdbc:cdata:connect:AuthScheme=basic;URL=http://hostname:port/rest.rsc;User=my_user;Password=my_password;

  The second format above can be used whenever there is a conflict in your application between drivers using the same URL format to ensure you are using the CData driver. The URL must start with either "jdbc:connect:" or "jdbc:cdata:connect:" and can include any of the connection properties in name-value pairs separated with semicolons.

Connecting to CData Connect Cloud

Follow these steps to connect to CData Connect Cloud:

1. AuthScheme: Select OAuth.
2. Click Test Connection or Sign In to open the OAuth sign in page.
3. Enter your CData Connect Cloud credentials and sign in.

Connecting to CData Connect Server

Enter following connection properties to connect to CData Connect Server:

• AuthScheme: Select Basic.
• URL: The REST URL found on the Endpoints page of the Admin Console.
• User: A user that you configured in the Connect Server dashboard.
• Password: The AuthToken for the chosen user.