Connect DBeaver Community to Zoho CRM through ODBC

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

If you need basic ODBC connectivity to Zoho CRM 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, try DBeaver Enterprise. For more information on connecting to Zoho CRM data from DBeaver Enterprise, see Connect DBeaver Enterprise to Zoho CRM through ODBC.

Initial configuration

Note

If you’re using Community Edition 23.1 or earlier, skip steps 1 and 2—these versions use a built‑in legacy ODBC driver, so those steps aren’t required.

To prepare for an ODBC connection:

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.

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

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

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 Zoho CRM

1. Open DBeaver Community.

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

Select New in the Driver Manager dialog

3. 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

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

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

Select Libraries and click Add File

The ODBC driver appears in the list.

Click Close in the Driver Manager dialog

6. Click Close.

7. Select Database > New Database Connection.

Select Database > New Database Connection

8. Select ODBC, then click Next.

Select your database driver

9. In Database/Schema, enter your DSN.

Specify the name for your database

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

Connection Test is successful

11. Click Finish.

The database appears in the left pane.

12. 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 Community

Query Zoho CRM 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 is executed in DBeaver Community