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