Connect Apache OpenOffice to Dynamics 365

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 Dynamics 365.
  • Create a DSN for Windows/macOS/Linux.

Import Dynamics 365 data in Apache OpenOffice

1. Click Database to open the Database Wizard.

Select the Database option

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

Connect to an existing database

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

Type the database name

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

Login credentials

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

Verify the connection

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

Save the database

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

When the database opens, a list of available Dynamics 365 tables is displayed.

Database tables

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

Table data

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

Create an SQL query

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

Fetched data