OdooWiki OCA HUB

External Database Source - SAP - Hana

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

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

auto_awesome What this module does

AI-generated from the code · Odoo 15.0

Adds SAP HANA as a connector option when creating external database sources in Odoo, so users can query SAP HANA databases directly from Odoo.

This module extends the External Database Source feature so that SAP HANA can be selected as a connection type. On the external database source form, a new connector choice labelled "SAP-Hana" becomes available alongside the other database types.

  • Users create or edit an external database source, choose the SAP-Hana connector, and enter the connection string (for example hana://username:password@example.de:30015) plus the password.
  • Once configured, SQL queries can be run against the SAP HANA database from Odoo, and the returned rows and column names are made available to the caller.
  • The module handles opening the connection, executing the query (with or without parameters), and closing the connection automatically.

It relies on the base.external.dbsource model and adds the SAP HANA specific connection, execution and closing logic to it. It requires the Python libraries sqlalchemy, sqlalchemy-hana and hdbcli to be installed on the server. A demo external database source named "SAP Hana Demo" is included for testing purposes. No new menus, reports, scheduled jobs or business rules are added; the change is limited to making SAP HANA a usable external data source type.

Depends on

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

Text generated by AI (DeepSeek) from reading the Odoo 15.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: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 15.0

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

terminal Installation and usage

OCA documentation · Odoo 15.0

Installation

Source · Odoo 15.0

To install this module, you need to:

  • Install sqlalchemy_hana and hdbcli python libraries

Configuration

Source · Odoo 15.0

To configure this module, you need to:

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

Usage

Source · Odoo 15.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.