Connect Apache LibreOffice to Zoho CRM

In this topic, you can find a step-by-step guide on how to connect to an ODBC database in LibreOffice. Additionally, you’ll learn how to efficiently retrieve and display data from tables in the system.

Prerequisites

  • Download and install LibreOffice.

  • Download and install Devart ODBC Driver for Zoho CRM.

  • Create a Windows DSN.

Import Zoho CRM data into LibreOffice

1. Click Base Database to open the Database Wizard.

Click the Base Database option

2. Under Connect to an existing database, select ODBC, then click Next.

Select the ODBC option

3. Click Browse, select your DSN, then click OK.

4. Click Next.

Browse the database

5. Optional: If you didn’t save your Zoho CRM credentials during the DSN setup, in User name, enter your username, then select Password required.

6. To verify the connection settings, click Test Connection, enter your password, then click OK. Click Next.

Test the connection

7. Leave the default settings unchanged, then click Finish.

Finish the process

8. Enter a name for the database and specify the save path on your computer.

When the database opens, a list of available Zoho CRM tables is displayed.

The list of tables

9. Optional: Double-click the table to view its contents.

View data

10. To create a SQL query, in the Database pane, navigate to Queries and click Create Query in SQL View.

Build an SQL query

11. Enter your SQL query and press F5 to fetch the data.

Check the data