External Database Source - MSSQL

base_external_dbsource_mssql
REPOSITORY
REPOSITORYOCA/server-backend
GIT
GIThttps://github.com/OCA/server-backend.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-backend/tree/18.0/base_external_dbsource_mssql
VERSION
VERSION 1.0.4
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSJordiMForgeFlow, OCA-git-bot, sergiocorato, Florent THOMAS, oca-ci, christian-ramos-tecnativa
WEBSITE
WEBSITEhttps://github.com/OCA/server-backend
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:30:19
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-backend:
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES pymssql<=2.2.5 ; python_version <= '3.10'
pymssql<=2.2.8 ; python_version < '3.12'
pymssql<=2.3.7 ; python_version >= '3.12'
sqlalchemy
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
This module extends `base_external_dbsource`, allowing you to connect to
foreign MSSQL databases using SQLAlchemy.

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (1)
  • connector Selection
    ondelete={'mssql': 'cascade'} selection_add=[('mssql', 'Microsoft SQL Server')]
Public methods (3)
  • connection_close_mssql(self, connection)
  • connection_open_mssql(self)
  • execute_mssql(self, sqlquery, sqlparams, metadata)
REPOSITORY
REPOSITORYOCA/server-backend
GIT
GIThttps://github.com/OCA/server-backend.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-backend/tree/16.0/base_external_dbsource_mssql
VERSION
VERSION 1.1.0
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSWeblate, OCA-git-bot, Florent THOMAS, oca-ci, Andrea Cattalani
WEBSITE
WEBSITEhttps://github.com/OCA/server-backend
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:53:59
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-backend:
    - base_external_dbsource_sqlite
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES pymssql<=2.2.5 ; python_version <= '3.10'
pymssql<=2.2.8 ; python_version > '3.10'
sqlalchemy
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (1)
  • connector Selection
    ondelete={'mssql': 'cascade'} selection_add=[('mssql', 'Microsoft SQL Server')]
Public methods (3)
  • connection_close_mssql(self, connection)
  • connection_open_mssql(self)
  • execute_mssql(self, sqlquery, sqlparams, metadata)
REPOSITORY
REPOSITORYOCA/server-backend
GIT
GIThttps://github.com/OCA/server-backend.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-backend/tree/15.0/base_external_dbsource_mssql
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSVíctor Martínez, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITEhttps://github.com/OCA/server-backend
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:46:43
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-backend:
    - base_external_dbsource_sqlite
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES pymssql<=2.2.5
sqlalchemy
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (0)

No new fields.

Public methods (3)
  • connection_close_mssql(self, connection)
  • connection_open_mssql(self)
  • execute_mssql(self, sqlquery, sqlparams, metadata)
REPOSITORY
REPOSITORYOCA/server-backend
GIT
GIThttps://github.com/OCA/server-backend.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-backend/tree/13.0/base_external_dbsource_mssql
VERSION
VERSION 1.0.1
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSGitHub, sergio-teruel, JordiMForgeFlow, oca-travis, OCA-git-bot
WEBSITE
WEBSITEhttps://github.com/OCA/server-backend
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:34:20
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-backend:
    - base_external_dbsource_sqlite
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES pymssql<=2.2.5
sqlalchemy
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (0)

No new fields.

Public methods (3)
  • connection_close_mssql(self, connection)
  • connection_open_mssql(self)
  • execute_mssql(self, sqlquery, sqlparams, metadata)
REPOSITORY
REPOSITORYOCA/server-backend
GIT
GIThttps://github.com/OCA/server-backend.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-backend/tree/12.0/base_external_dbsource_mssql
VERSION
VERSION 1.0.1
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSOCA Transbot, Sergio Teruel, oca-travis, Weblate, OCA-git-bot, hugues de keyzer
WEBSITE
WEBSITEhttps://github.com/OCA/server-backend
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:29:25
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-backend:
    - base_external_dbsource_sqlite
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES pymssql
sqlalchemy
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (0)

No new fields.

Public methods (3)
  • connection_close_mssql(self, connection)
    @api.multi
  • connection_open_mssql(self)
    @api.multi
  • execute_mssql(self, sqlquery, sqlparams, metadata)
    @api.multi
REPOSITORY
REPOSITORYOCA/server-backend
GIT
GIThttps://github.com/OCA/server-backend.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-backend/tree/11.0/base_external_dbsource_mssql
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSSergio Teruel, oca-travis, OCA-git-bot
WEBSITE
WEBSITEhttps://github.com/OCA/server-backend
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:24:02
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-backend:
    - base_external_dbsource_sqlite
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES pymssql
sqlalchemy
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (0)

No new fields.

Public methods (3)
  • connection_close_mssql(self, connection)
    @api.multi
  • connection_open_mssql(self)
    @api.multi
  • execute_mssql(self, sqlquery, sqlparams, metadata)
    @api.multi
REPOSITORY
REPOSITORYOCA/server-tools
GIT
GIThttps://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-tools/tree/10.0/base_external_dbsource_mssql
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLEYes
AUTHORS
AUTHORSOdoo Community Association (OCA), LasLabs, Daniel Reis
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), LasLabs, Daniel Reis
COMMITTERS
COMMITTERSOCA Transbot, Dave Lasley, oca-travis, OCA-git-bot
WEBSITE
WEBSITEhttps://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:19:59
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-tools:
    - base_external_dbsource_sqlite
    - base_external_dbsource
odoo/odoo:
    - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (0)

No new fields.

Public methods (3)
  • connection_close_mssql(self, connection)
    @api.multi
  • connection_open_mssql(self)
    @api.multi
  • execute_mssql(self, sqlquery, sqlparams, metadata)
    @api.multi
STATUS
STATUSOpen migration PR - not merged yet for this version
REPOSITORY
REPOSITORYOCA/server-backend
PULL REQUEST
PULL REQUEST[19.0][MIG] Migration of module base_external_dbsource_mssql (#416)