MS SQL Query

by
Odoo
v 14.0 Third Party 241
Download for v 14.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 225
Technical Name mssql_query
LicenseLGPL-3
Versions 14.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 225
Technical Name mssql_query
LicenseLGPL-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

  • Installing Microsoft ODBC Driver for SQL Server
  • Refer the link

  • Installing Python Library
  • 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

    Feedback

    Please log in to comment on this module

    • The author can leave a single reply to each comment.
    • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
    • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
    Please choose a rating from 1 to 5 for this module.