ODBC Driver for Zoho Books

Connect DBeaver Enterprise to Zoho Books through ODBC

DBeaver Enterprise and DBeaver Community let users connect to Zoho Books 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, you may try DBeaver Enterprise.

If you need basic ODBC connectivity to Zoho Books 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 Zoho Books data from DBeaver Community, see Connect DBeaver Community to Zoho Books through ODBC.

Connect to Zoho Books

To connect to the Zoho Books database from DBeaver Enterprise:

1. Select Database > New Database Connection.

2. Select the ODBC driver and click Next.

Select your databaase page of the Connect to a database dialog

3. In the Database Source field, specify the name of your DSN.

ODBC connection settings page of the Connect to a database dialog

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

Connection test result

5. Click Finish.

The database appears on the left pane.

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

A table selected in Database Naviagtor and displayed on the Data tab

Query Zoho Books 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 window.

SQL query executed in DBeaver Enterprise

© 2015-2025 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback