OdooWiki OCA HUB

External Database Source - SQLite

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

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

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Adds SQLite as a connector option on external database sources, so Odoo can connect to SQLite files and run SQL queries against them.

This module extends the External Database Source feature so that a SQLite database can be used as a data source, alongside the other connector types already available.

  • On the external database source form, the Connector field now offers a SQLite choice. Selecting it lets you store a SQLite connection string and use that source like any other external database.
  • Connections are opened through SQLAlchemy, and queries are executed against the SQLite database. When a query returns rows, the results are returned to the caller; when it does not, an empty result is returned.
  • Closing a source simply closes the underlying connection.
  • A demo record named "SQLite Demo" is provided with the SQLite connector pre-selected, useful for testing.

The module touches the base.external.dbsource model only, adding the SQLite selection value and the connection and execution logic behind it. It requires the Python SQLAlchemy library to be installed. No new menus, buttons, reports, scheduled jobs or business rules are added by this module; it is a technical connector that makes SQLite usable wherever external database sources are used in Odoo.

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: 6 confirmed, 3 with no information of 9 versions.

Sources · Odoo 12.0

Confirmed on 2026-11-03 in branch 12.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 sqlalchemy python library

Configuration

Source · Odoo 18.0

To configure this module, you need to:

  • Database sources can be configured in Settings \> Configuration -\> Data sources.

Usage

Source · Odoo 18.0

To use this module:

  • Go to Settings \> 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.