Let us take a closer look at how to set up the SQL server JDBC driver for DBeaver within a few simple steps.  With the support of our MSSQL support services at Bobcares, we can give you detailed step by guidance on the process.

DBeaver Overview

It is a multiplatform database administration tool and SQL client for developers and database administrators that is free and open source. DBeaver may connect to any ODBC or JDBC-enabled database or cloud application, such as Oracle, SQL Server, MySQL, Salesforce, or Mailchimp.

Connect to SQL Server Data in DBeaver

Manage SQL Server data with DBeaver’s visual features, such as the query browser.

The CData JDBC Driver for SQL Server implements JDBC standards, allowing third-party products such as wizards in IDEs and business intelligence applications to communicate with each other.

This article demonstrates how to use DBeaver wizards to connect to SQL Server data and browse data in the DBeaver GUI.  

Create a JDBC Data Source for SQL Server Data

To load the driver JAR in DBeaver, follow the instructions below:    

1. Open the DBeaver application and select the Driver Manager option from the Databases menu. To access the Create New Driver form, click New.      
    
2. Enter a user-friendly name for the driver in the Driver Name box.
    
3. Click Add File to add the.jar.
    
4. Select the cdata.jdbc.sql.jar file from the installation directory’s lib subfolder in the create new driver window that appears.
    
5. Select the SQLDriver class from the results by clicking the Find Class button. This will complete the Class Name field at the top of the form automatically. The driver’s class name is cdata.jdbc.sql.SQLDriver.
    
6. In the URL Template field, type jdbc:sql.

Create a Connection to SQL Server Data

To add credentials and other required connection properties for sql server jdbc driver for DBeaver, follow the steps below.

1. Click New Connection under the Databases menu.
    
2. Select the driver from the Create new connection wizard that appears.
    
3. Click the driver properties tab on the next page of the wizard.
    
4. Enter values for authentication credentials and other SQL Server-related settings.

Accessing Microsoft SQL Server Use the following properties to connect to Microsoft SQL Server:

• Server: The name of the SQL Server server.
   
• User: The username used for SQL Server authentication.
   
• Password: The password used to authenticate the user.
   
• Database: The SQL Server database’s name. Obtaining access to Azure SQL Server and Azure Data.
   
• Server: The server that runs Azure. Logging into the Azure site, we can access this by going to “SQL databases” (or “SQL data warehouses”) -> “Select your database” -> “Overview” -> “Server name.”
   
• The name of the user who is authenticating to Azure.
   
• Password: The password used to authenticate the user.
   
• Database: The SQL Server database’s name.

This concludes the first steps in configuring up the SQL server JDBC driver for DBeaver.

Connecting to Azure SQL Server and Azure Data Warehouse

By configuring the following connection properties, we can authenticate to Azure SQL Server or Azure Data Warehouse:

• Server: The server that runs Azure. Logging into the Azure site, we can access this by going to “SQL databases” (or “SQL data warehouses”) -> “Select your database” -> “Overview” -> “Server name.”
   
• The name of the user who is authenticating to Azure.
   
• Password: The password used to authenticate the user.
   
• Database: The database’s name, as shown in the Azure portal’s SQL databases (or SQL warehouses) page.

Built-in Connection String Designer

Use the connection string designer provided with the SQL Server JDBC Driver for assistance in creating the JDBC URL. Either double-click the JAR file or run it from the command line.

java -jar cdata.jdbc.sql.jar

Fill up the connection properties and copy the string to the clipboard. A typical connection string is as follows:

jdbc:sql:User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=1433

Query SQL Server Data

We may now query information from the connection’s exposed tables: Click Edit Table after right-clicking a Table. The data can be seen on the Data tab. 

[Need assistance with similar queries? We are here to help]

Conclusion

To conclude we have learned more about how to configure the SQL server JDBC driver for DBeaver and the configurations necessary with the support of our MSSQL support services.