Connect DBeaver Enterprise to Salesforce through ODBC

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

If you require a simplified connection setup with built-in ODBC support, enhanced security, and performance features, try DBeaver Enterprise.

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. For more information on connecting to Salesforce data from DBeaver Community, see Connect DBeaver Community to Salesforce through ODBC.

Connect to Salesforce

1. Open DBeaver Enterprise.

2. Select Database > New Database Connection.

3. Select ODBC, then click Next.

Select your database

4. In the Data Source field, enter the name of your DSN.

Enter the data source name in the ODBC Connection Settings

5. Optional: Click Test Connection to verify the connection settings.

Connection Test is successful

6. Click Finish.

The database appears on the left pane.

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

The table data is loaded in DBeaver Enterprise

Query Salesforce data

1. Select SQL Editor > New SQL script.

Select SQL Editor > New SQL script in DBeaver Enterprise

2. Enter your query.

Type SQL query in DBeaver Enterprise

3. Select SQL Editor > Execute SQL query.

The query results are displayed in the main pane.

SQL query is executed in DBeaver Enterprise

Note

In addition to the built-in ODBC driver, DBeaver Enterprise supports generic ODBC connections that require manual configuration. To configure such a connection:

  1. Complete the Initial configuration section and steps 1 to 6 in the Connect to Salesforce section of Connect DBeaver Community to Salesforce through ODBC.

  2. Then continue from step 2 in the Connect to Salesforce section of this article.