DBeaver
This section describes how to connect to 1010Data following the standard JDBC connection process in DBeaver: Add the driver JAR, provide the driver class name, and provide any 1010Data-specific parameters in the JDBC URL.
Add the JDBC Driver for 1010Data
Complete the following steps to add the driver .jar file:
- Open the DBeaver application and, in the Database menu, select the Driver Manager option. Click New to open the Create New Driver form.
- In the Driver Name box, enter a user-friendly name for the driver.
-
To add the .jar file, click Add File on the Libraries tab. Select the cdata.jdbc.c1010.jar file, located in the lib subfolder of the installation directory.
- Click Find Class, and in the list select, "cdata.jdbc.c1010.C1010Driver".
- In the URL Template field, enter jdbc:c1010:.
Create the JDBC Data Source
Complete the following steps to select the 1010Data driver and build the JDBC URL to create the JDBC data source:
- In the main DBeaver window, click Database > New Connection.
- Select the driver definition you created in the dialog that is displayed.
- On the next page of the wizard, click the Driver Properties tab.
-
Enter any connection properties required to connect to 1010Data.
Here is a typical connection string:
jdbc:c1010:[email protected];Password=password;LoginURL=https://my.domain.1010data.com/prime-latest
See Establishing a Connection for a connection and authentication guide. - Finish creating the connection with the default settings or configure advanced network settings -- proxy, firewall, and SSH.
Discover Schemas and Query 1010Data Data
Complete the following steps to query information from the tables exposed by the connection:
- Expand the node for the connection to access the database metadata.
- Browse the table metadata and edit the table data by right-clicking a Table and then clicking Edit Table.
To execute an SQL query, select SQL Editor > New SQL Editor and select the 1010Data connection you created. You can then enter queries using code completion.