HANA - Adapter (Virtual Table)

Sap Hana Architecture


Every Java developer can now extend Hana by writing new Adapters with a few lines of code. The foundation of this feature is Hana Smart Data Access.

Adapter create virtual tables, which are views on top of remote data.


For safety reasons these adapters do not run inside Hana but are hosted on one or many external computers running the Hana Data Provisioning Agent and the Adapters. This agent is a very small download from Service Market Place and can be located on any Windows/Linux computer. Since the agent talks to Hana via either TCP or https, the agent can even be installed inside the company network and loads into a Hana cloud instance!

Hana Adapters Architecture




Because the agent can be installed anywhere, it can be even installed on-premise and be connected to a Hana cloud. instance. Not even a VPN tunnel has to be used as the supported protocol includes https as well. In this case the agent does establish a https connection to the Cloud Hana instance just as any other web browser would do.


The Data Provisioning Agent Configuration tool manages Data Provisioning Agents and adapters, and connections to SAP HANA.


Developing an Adapter is much easier. Hana Studio has a plugin so it acts as an agent, so the developer can watch the internals easily.

Documentation / Reference

Discover More
Hdb Sda Premise
HANA - SDI - (Architecture|Components)

Data Provisioning Agent When SAP HANA is deployed: on premise, the Data Provisioning Server within SAP HANA connects to the agent using the TCP/IP protocol. (Port 5050) in the cloud or behind a firewall,...
Sap Hana Architecture
HANA - Smart Data Access (Adapter, Virtual Table)

SAP HANA smart data access enables remote data to be accessed as if they are local tables in HANA, without copying the data into SAP HANA (without having to replicate the data to SAP HANA) in SAP HANA,...
Sap Hana Architecture
SAP Hana - Virtual Table

Virtual Table Adapter create virtual table which are views on top of remote data.

Share this page:
Follow us:
Task Runner