Connect DBeaver Community to Salesforce through ODBC

Last modified: July 25, 2025

DBeaver Community and DBeaver Enterprise let you connect to Salesforce via ODBC, enabling SQL-based querying, reporting, and data management.

If you need basic ODBC connectivity to Salesforce and are comfortable with manual configuration using a generic ODBC Connection, choose DBeaver Community—a free, open-source database management tool.

If you require a simplified connection setup with built-in ODBC support, enhanced security, and performance features, you may try DBeaver Enterprise. For more information on connecting to Salesforce data from DBeaver Enterprise, see Connect DBeaver Enterprise to Salesforce through ODBC.

Initial configuration

1. Download the jdbc-odbc-bridge-jre7.jar and x64/JdbcOdbc.dll files from GitHub.

2. Download and install the Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package from the Microsoft website.

Note

The built-in legacy ODBC driver was removed in DBeaver Community Edition 23.1. If you’re using an earlier version of DBeaver Community, skip steps 1 and 2.

3. Configure an ODBC data source. For instructions, see Configure a Windows DSN for Salesforce.

4. On the Advanced Settings tab of the DSN configuration window, select Ansi from the String Types.

This option is required for the proper display of the SQL_WVARCHAR data type in DBeaver. It also ensures that all string types will be returned as SQL_CHAR, SQL_VARCHAR, and SQL_LONGVARCHAR.

Select Ansi in Advanced Settings of the driver configuration dialog

Connect to Salesforce

1. Select Database > Driver Manager, then click New.

Select New in the Driver Manager dialog

2. Configure the following properties for a new driver:

  • In the Driver Name field, enter ODBC.

  • In the Class Name field, enter sun.jdbc.odbc.JdbcOdbcDriver.

  • In the URL Template field, enter jdbc:odbc:{database}.

Make configuration settings for a new driver

3. On the Libraries tab, click Add File, select the JdbcOdbc.dll file, then click OK.

4. Click Add File, select the jdbc-odbc-bridge-jre7.jar file, then click OK.

Select Libraries and click Add File

The ODBC driver appears on the list.

Click Close in the Driver Manager dialog

5. Click Close.

6. Select Database > New Database Connection.

Select Database > New Database Connection

7. Select the ODBC driver, then click Next.

Select your database driver

8. In the Database/Schema field, enter your DSN.

Specify the name for your database

9. Optional: Select Test Connection to verify the connection settings.

Connection Test is successful

10. Click Finish.

The database appears on the left pane.

11. To view the data stored in a table, expand the database structure and double-click the needed table.

Account table data loaded in DBeaver Community

Query Salesforce data

1. Select SQL Editor > New SQL script.

Select SQL Editor > New SQL script in DBeaver Community

2. Enter your query.

Type SQL query in DBeaver Community

3. Select SQL Editor > Execute SQL query.

The query results are displayed in the main pane.

SQL query executed in DBeaver Community

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by ODBC Driver for Salesforce.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

Ready to start using  

ODBC Driver for Salesforce?

Download a FREE 30-day trial