Connect Apache OpenOffice to Salesforce

Last modified: July 25, 2025

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

Prerequisites

• Download and install Apache OpenOffice.
• 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 connect to an ODBC database in Apache OpenOffice. You can find the instructions for your OS in the following topics:

• Configure a Windows DSN for Salesforce.
• Create a DSN in the iODBC Administrator.
• Configure an ODBC Driver Manager on Linux.

Import Salesforce data in Apache OpenOffice

1. Сlick Database to open the Database Wizard.

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

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

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

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

6. To proceed to the final step, click Next. Leave the set options as default. To complete the process, click Finish.

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

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

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

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