VOOZH about

URL: https://www.cdata.com/kb/tech/odoo-odbc-openoffice-base.rst

⇱ How to Easily Query Odoo Data in OpenOffice Base

How to Easily Query Odoo Data in OpenOffice Base

👁 Mohsin Turki
Mohsin Turki
Technical Marketing Engineer
Connect to Odoo data in OpenOffice Base using the CData ODBC Driver for Odoo and generate reports with live data insights.

Apache OpenOffice Base is a versatile, free database tool that makes connecting and managing data easy. With CData ODBC Driver for Odoo, you can seamlessly integrate and query live Odoo data, bringing real-time insights directly into OpenOffice.

This guide simplifies the setup, showing you how to connect Odoo to OpenOffice Base so you can easily generate reports, analyze trends, and make informed decisions right within your familiar workspace.

About Odoo Data Integration

Accessing and integrating live data from Odoo has never been easier with CData. Customers rely on CData connectivity to:

  • Access live data from both Odoo API 8.0+ and Odoo.sh Cloud ERP.
  • Extend the native Odoo features with intelligent handling of many-to-one, one-to-many, and many-to-many data properties. CData's connectivity solutions also intelligently handle complex data properties within Odoo. In addition to columns with simple values like text and dates, there are also columns that contain multiple values on each row. The driver decodes these kinds of values differently, depending upon the type of column the value comes from:
    • Many-to-one columns are references to a single row within another model. Within CData solutions, many-to-one columns are represented as integers, whose value is the ID to which they refer in the other model.
    • Many-to-many columns are references to many rows within another model. Within CData solutions, many-to-many columns are represented as text containing a comma-separated list of integers. Each value in that list is the ID of a row that is being referenced.
    • One-to-many columns are references to many rows within another model - they are similar to many-to-many columns (comma-separated lists of integers), except that each row in the referenced model must belong to only one in the main model.
  • Use SQL stored procedures to call server-side RFCs within Odoo.

Users frequently integrate Odoo with analytics tools such as Power BI and Qlik Sense, and leverage our tools to replicate Odoo data to databases or data warehouses.


Getting Started


Overview

Here is an overview of the steps:

  1. CONFIGURE: Configure the DSN for Odoo data in the CData ODBC Driver for Odoo, using the required connection properties.
  2. CONNECT: Set up the ODBC connection in OpenOffice Base using the configured DSN.
  3. IMPORT: Once connected, review the available metadata and tables.
  4. CREATE: Create a report based on the queried Odoo data data.

Configure the Odoo DSN Using the CData ODBC Driver for Odoo

To start, configure the DSN (Data Source Name) for Odoo data in your system using the CData ODBC Driver for Odoo. Download and install a 30-day free trial with all the features from here.

Once installed, launch the ODBC Data Source Administrator:

  • On Windows: Search for ODBC Data Source Administrator in the Start menu and open the application.
  • On Mac: Open Applications, go to Utilities, and select ODBC Manager.
  • On Linux: Use the command line to launch ODBC Data Source Administrator or use unixODBC if installed.
👁 ODBC Data Source Administrator

Once launched, double-click on the CData Odoo data Source and enter the required values to establish a connection:

To connect, set the Url to a valid Odoo site, User and Password to the connection details of the user you are connecting with, and Database to the Odoo database.

👁 Configuring a DSN (Salesforce is shown)

Setup an ODBC Connection in OpenOffice Base

Once you've set up the DSN, it's time to connect to it in OpenOffice Base and start querying data:

Your connection is now established — ready to query and analyze data seamlessly within OpenOffice Base.


Review the Metadata and Tables

After the database file is created and the connection is established, the table list will automatically display all available Odoo data objects.

  • Review the Odoo data Object List: In the left pane, click on Tables to view the Odoo data objects now available within OpenOffice Base.
  • View Object Data: Click on any object to view its contents. The Odoo data data will display directly within OpenOffice Base, allowing you to review records and fields with ease.
👁 Apache OpenOffice Base Metadata (Salesforce data is shown)

That's it! You have now successfully established a connection to Odoo data in OpenOffice Base, with data readily available for analysis and reporting.


Create a Report

Now, let's generate a report based on your Odoo data data.

Your report is now created, drawing live data directly from Odoo data, and ready for analysis.


Try CData Free for 30 Days

Experience the power of live Odoo data data at your fingertips and seamlessly integrate it into OpenOffice Base. Start your free trial today!

Ready to get started?

Download a free trial of the Odoo ODBC Driver to get started:

 Download Now

Learn more:

👁 Odoo Icon
Odoo ODBC Driver

The Odoo ERP ODBC Driver is a powerful tool that allows you to connect with live Odoo ERP data, directly from any applications that support ODBC connectivity.

Access Odoo ERP like you would a database - read, write, and update Sales Orders, Purchase Orders, Accounts, etc. through a standard ODBC Driver interface.