| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 372 |
| Technical Name |
odoo_mysql_connector |
| License | AGPL-3 |
| Website | https://www.cybrosys.com |
| Versions | 17.0 18.0 19.0 |
This Application Enables You to Import the Database Tables from Mysql to Odoo.
Odoo Mysql Connector
Key Highlights
Effortlessly import data from Mysql to Odoo
Intuitive and Easy-to-use interface
Are you ready to make your business more
organized?
Improve now!
odoo@cybrosys.com
+91 9074270811
Start a New Test Database
For testing, create credentials through Free SQL Database. Select the server location and click Start New Database to generate a test MySQL database.
Review Generated Database Details
After creating the database, note the generated host, database name, username, password status, and live status. These values are used to configure the MySQL connection in Odoo.
Log in to phpMyAdmin
Open the phpMyAdmin link from the database account and log in with the server, username, and password provided for the test database.
Create a MySQL Table
In phpMyAdmin, create the required table, such as product, enter the number of columns, and click Go to define the table structure.
Configure MySQL Credentials
Navigate to the Credentials menu under Configuration in MySQL Connector to create a new database connection.
Connect Odoo with MySQL
Enter the MySQL database name, host, username, and password in Odoo, then click Connect to validate the credentials and activate the database connection.
Select the MySQL Table
Choose the required MySQL table, such as the product table, that needs to be imported into an Odoo model.
Open the Connector Menu
Use the Connector menu under MySQL Connector configuration to define the import mapping between MySQL tables and Odoo records.
Fetch Table Data
Add the connector details and click Fetch Data to load the MySQL table columns before mapping them with Odoo fields.
Map MySQL Columns with Odoo Fields
Select the Odoo fields that match each MySQL column. If a MySQL field has a foreign key, choose the related column from the foreign table before clicking Sync Table.
Review Foreign Key Validation
The connector displays a validation error when a selected MySQL table depends on a foreign key table that has not been synchronized yet.
Sync Foreign Tables First
Synchronize the foreign table first so the related records are available in Odoo before importing the main table.
View Imported Records
After synchronization, the imported MySQL product records are available in Odoo with the mapped field values.
Effortlessly import data from MySQL to Odoo by mapping the MySQL columns to the corresponding fields in the Odoo table, ensuring a seamless and efficient transfer of information between the two systems.
Experience a user-friendly interface that is both intuitive and easy to use, designed to enhance productivity and streamline workflows.
Yes. The connector lets you choose a MySQL table and map its columns to the matching fields in an Odoo model before synchronization.
Yes. After entering the MySQL credentials, use the Connect button to verify that Odoo can access the selected database.
If a MySQL column depends on a foreign key table, synchronize the related table first and then map the foreign key value while importing the main table.
Yes. Field mapping is required so the connector knows which MySQL column should update each corresponding Odoo field.
Latest Release 18.0.1.0.0
30th May, 2026- Initial Commit for Odoo Mysql Connector
Please log in to comment on this module