Connect Apache LibreOffice to Salesforce

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

Create a DSN for Salesforce

Before you start, you need to configure a DSN for Salesforce in the ODBC Data Source Administrator. It’s required to establish a connection to an ODBC database in LibreOffice. You can find the instructions for your OS in the following topics:

  • Configure a Windows DSN for Salesforce.
  • Create a DSN on macOS.
  • Create a DSN on Linux.

Import Salesforce data in 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.

Browse the database

4. Click Next.

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

6. To verify the connection, click Test Connection, enter your password, and click OK.

Test the connection

7. To proceed to the final step, click Next. Leave the set options as default. To complete the process, 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 Salesforce tables is displayed.

The list of tables

9. To view data from a table, double-click the required one.

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