MYSQL Connector

You can easily connect the MySQL database to Odoo via the MYSQL Connector if you already have your own database in MySQL and you want to connect it to Odoo.

Now, to navigate this feature Go to MYSQL Connector > Configuration > SQL Connector >Fill in the details and Click on the Connection Button.

[Note: If your connection was set up correctly then it will show the Success message. But, if your connection was not set correctly then it will show the Connection Failed Message]

Additionally, In the SQL Connector, you have to fill the required details in the Server Settings.

Name: you have to create your own sql connector name

Host: you have to define your own server where your database is located

Port: you have to define the port number in SQL Connector from which you can access your database

Username: In this, you have to define your own username.

Password: here, you have to define your password

Database: You have to set your MYSQL Connector database name which you want to connect it to Odoo.

Furthermore, Go to the Mysql Connector > Mysql Table > Fill in the required details.

Here in the Server Settings, you have to add the required fields [EX; Name, Connector (which you have added in the SQL Connector's name which you want to connect it to SQL Connector)].

Now, here you have to add the SQL Table Name(which would be the name of the table on the SQL server) and Odoo Model Name (The Mapping Model on Odoo to which records have to be synced),

Once done, you need to configure the Batches in which you want to import data into Odoo, For this you can see the fields "Per Batch Count" and "Last Count",

"Per Batch Count" will be used to define the number of records to import in each batch.

"Last Count" will be having the count of the records already imported from SQL DB into Odoo.

You can define the last count if you want to skip a few records to import from the Remote SQL database.

Here we've set up three boolean fields: "Want to Sync the data", "Want to Update the data" and "is unique identifier". By checking "Want to Sync the Data" If field is selected, the system will automatically configure a scheduled action to run periodically. This scheduled action ensures that the synchronization process takes place automatically, eliminating the need for manual initiation. "want to Update the Data" This field should be selected, all records from the MySQL database will be updated in your Odoo table when you click on the "Sync Table" button. Lastly, in "is Unique Identifier" This field should be selected, and you need to add one unique field in your database. This unique field is crucial for identifying records uniquely in both your MySQL and Odoo tables.

Here, you have to manually add the Mysql Field and Odoo Field and then click on the "Sync Table".

You will see your data successfully imported into Odoo after clicking on the Sync Table button.