Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 225 |
Technical Name |
mssql_query |
License | LGPL-3 |
Versions | 14.0 |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 225 |
Technical Name |
mssql_query |
License | LGPL-3 |
Versions | 14.0 |
The app for making easy queries in MS SQL
Explore your MS SQL database with query into an Odoo interface
You can use SELECT, UPDATE, DELETE, CREATE, INSERT, ALTER and DROP statements.
Pre-Requirement
Refer the link
pip install pyodbc
Give User Access
Go to Settings --> Users

SQL Database Connection
Go to SQL Query --> Settings --> SQL Connection
Create New Connection

Execute SQL Query
Go to SQL Query
Create New Query

Please log in to comment on this module