Bobcares

SQL Server JDBC driver for DBeaver: Configuration

by | Sep 23, 2022

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

sql server jdbc driver for DBeaver

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

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

     

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

_reb2bgeo - The visitor's geographical location

_reb2bloaded - Whether or not the script loaded for the visitor

_reb2bref - The referring URL for the visit

_reb2bsessionID - The visitor's RB2B session ID

_reb2buid - The visitor's RB2B user ID

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid
_reb2bgeo, _reb2bloaded, _reb2bref, _reb2bsessionID, _reb2buid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF