OdooWiki OCA HUB

External Database Source - MSSQL

base_external_dbsource_mssql folder_open OCA/server-backend open_in_new
Tools License: LGPL-3

This module extends base_external_dbsource, allowing you to connect to foreign MSSQL databases using SQLAlchemy.

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Adds Microsoft SQL Server as a connectable external database type in Odoo, so users can configure MSSQL connections and run SQL queries against them from the External Database Sources screen.

This module extends the External Database Sources feature so that Microsoft SQL Server (MSSQL) becomes one of the available database types.

  • On the external database source form, the Connector field now offers an extra choice, "Microsoft SQL Server", alongside the other connectors.
  • When that connector is selected, Odoo opens the connection using the connection string and password stored on the record, and can execute SQL queries against the MSSQL database.
  • Query results are returned as rows; when column information is requested, the column names are returned too. For statements that do not return rows (for example inserts or updates), the change is committed to the external database.
  • A demo record named "MSSQL Demo" is included to show a sample connection string and password setup.

The module works on the base.external.dbsource model and relies on the base external database source module. It does not add its own menus or screens; everything happens inside the existing external database source configuration and query execution flow.

Depends on

base_external_dbsource
Models and fields (1)
  • base.external.dbsource · extends an existing modelconnector

Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 5 confirmed, 4 with no information of 9 versions.

Sources · Odoo 13.0

Confirmed on 2026-11-03 in branch 13.0 of OCA/server-backend.

terminal Installation and usage

OCA documentation · Odoo 18.0

Installation

Source · Odoo 18.0

To install this module, you need to:

  • Install & configure FreeTDS driver (tdsodbc package)
  • Install sqlalchemy & pymssql python libraries
  • Install base_external_dbsource Odoo module

Configuration

Source · Odoo 18.0

To configure this module, you need to:

  • Database sources can be configured in Settings \> Technical \> Database Structure \> Database sources.

Usage

Source · Odoo 18.0

To use this module:

  • Go to Settings \> Technical \> Database Structure \> Database Sources
  • Click on Create to enter the following information:
  • Datasource name
  • Pasword
  • Connector: Choose the database to which you want to connect
  • Connection string: Specify how to connect to database
info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.