Integrate Odoo with JetBrains RubyMine using CData JDBC Drivers

Anusha M B
Technical Marketing Engineer

Learn how to integrate Odoo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Odoo data.

CData JDBC Driver for Odoo offer standardized JDBC connectivity to 200+ data sources, allowing developers to treat SaaS and cloud APIs as relational databases. By integrating these drivers into JetBrains RubyMine, user can connect IDE directly to external systems like CRM or ERP platforms, enabling SQL based data access and real-time querying.

RubyMine is a advanced IDE for Ruby and Rails development that offers advanced coding assistance, debugging, and database tools. Through CData JDBC integration, developers can link RubyMine with Odoo for easy access to live Odoo data.

Overview

Here is a quick overview of the integration process:

Set Up Environment: Configure the Ruby interpreter in RubyMine
Install JDBC Driver: Add the CData JDBC Driver for Odoo to RubyMine's database configuration
Connect: Establish a live connection to Odoo and begin querying Odoo data

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

Configure the Ruby Interpreter in RubyMine

After installing the Ruby interpreter, open RubyMine and configure the environment.

Create a New Empty Project
Select the interpreter for example, C:\Ruby34-x64\bin uby.exe
Click Create to initialize the project

Add the CData JDBC Driver for Odoo

Next, configure the CData JDBC Driver for Odoo within RubyMine.

Go to View, select Tool Windows and click Database to open the database panel

Click the "+" icon and choose Driver from the dropdown

In the Data Sources and Drivers window:
- Provide a Name for the driver (e.g., CData Odoo JDBC)
- Click "+" in the Driver Files section and select Custom JARs
- Locate and open the cdata.jdbc.odoo.jar file
- Set the Class to cdata.jdbc.odoo.OdooDriver

Create the Odoo data source

Click Create Data Source and choose the newly created driver
In the connection window, confirm that the selected driver is correct
Enter your connection details:

Name: Odoo Connection
URL: jdbc:odoo:User=username;Password=password;
Username and Password: User Odoo credentials

Click Test Connection. If successful, click OK to save

Query live Odoo data

Once the connection is established, you can query live Odoo data directly within RubyMine.

Open the Database Console
Run SQL queries, for example:
```
SELECT * FROM Odoo data_Table LIMIT 10;
```

Developers can now easily access and manipulate Odoo data using SQL inside RubyMine bridging code development and live data access in one unified environment.

Connect RubyMine to 300+ Data Sources with CData

CData JDBC Drivers bring real time data connectivity to your development environment. With support for over 300+ sources, including CRM, ERP, analytics, and cloud APIs, developers can query, visualize, and build data driven applications without leaving their IDE.

Start your 30-day free trial to experience the full potential of live data connectivity.

Ready to get started?

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

Download Now

Learn more:

Odoo JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with Odoo ERP data, including Sales Orders, Purchase Orders, Accounts, and more!