Establishing a Connection

Creating a JDBC Data Source

You can create a JDBC data source to connect from your Java application, based on CData JDBC Driver for TigerGraph.

Follow these steps:

Add the driver JAR file to the classpath. The JAR file is located in the installation directory's lib subfolder.
Provide the driver class. For example:
```
cdata.jdbc.tigergraph.TigerGraphDriver
```
Provide the JDBC URL. For example:
```
jdbc:tigergraph:user=MyUserName;password=MyPassword;URL=MyURL;
```
Or, if there is a conflict in your application between drivers using the same URL format, use this form to ensure that you are using the CData driver:
```
jdbc:cdata:tigergraph:user=MyUserName;password=MyPassword;URL=MyURL;
```
Ensure that the URL starts with either jdbc:tigergraph: or jdbc:cdata:tigergraph:. The URL can include any of the connection properties in name-value pairs separated with semicolons.

This section documents how to authenticate and connect to your TigerGraph instance.

To authenticate requests to TigerGraph Server, set the following properties:

AuthScheme: Set this property to 'Basic'.
User: Set this property to your TigerGraph user name.
Password: Set this property to your TigerGraph user password.
URL: Set this property to the domain name or IP of your TigerGraph instance.
Port: Set this property to the port of your TigerGraph server instance (14240 by default).
TigerGraphEdition: Set this property to 'TigerGraph Server'.

See this page for notes on configuring a TigerGraph Server account: Managing Credentials

To authenticate requests to TigerGraph Cloud, set the following properties:

User: Set this property to your TigerGraph database user name.
Password: Set this property to your TigerGraph database user password.
URL: Set this property to the domain name or IP of your TigerGraph instance.

To configure a TigerGraph Cloud user:

From the Cloud portal, go to Clusters.
Find the cluster you want to create users for, and select Access Management
From the Cluster Access Management page, click Database Access.
Click Add new users and specify the username and password. Note: The password will not be visible again after leaving this page.
Click Role Management, select 'superuser' from the 'Select a role' list, then select the created user and click Save.

See this page for additional notes on configuring a TigerGraph Cloud database user: Managing Database Users

To authenticate using a Secret, set the following properties:

AuthScheme: Set this property to 'Secret'.
Secret: Set this property to your generated secret.
URL: Set this property to the domain name or IP of your TigerGraph instance.
Schema: Set this property to the graph name your secret has been generated for.

Secrets can be generated for a given graph in the TigerGraph Admin Portal.