Use Smart Data Access to Virtualise Data from the Cloud to an On-Premise Database
- How to create a remote source to an SAP HANA Cloud, SAP HANA database instance in your SAP HANA on-premise system using Smart Data Access
- How to then virtualise data from SAP HANA Cloud to an SAP HANA on-premise database
Prerequisites
- A running SAP HANA Cloud, SAP HANA database instance with a table that contains data.
- An SAP HANA on-premise database running on SAP HANA platform edition SPS04 or higher. Alternatively, you can download and install the latest SAP HANA express edition either as binary in Linux or a Docker image.
- An instance of the SAP HANA Database Explorer or SAP HANA Studio connected to the SAP HANA on-premise database.
Smart Data Access (SDA) can be used to virtualise data from a source SAP HANA Cloud, SAP HANA database to an SAP HANA on-premise target database. Since this HANA-to-HANA federation does not require additional deployment of the Data Provisioning Agent, unlike SDI, SDA is the preferred and simplest way in this direction to virtualise data. SDI may also be used for this direction and offers more advanced replication capabilities. You will learn how to use SDI in the next tutorial of this group.

For simplicity, we will focus on the preferred and simpler option in this article, using SDA.
In this article, you will learn step by step how to create an SDA connection between SAP HANA Cloud, SAP HANA database and SAP HANA on-premise. This includes creating a remote source to an SAP HANA Cloud, SAP HANA database instance in your SAP HANA on-premise system to then virtualise data from SAP HANA Cloud in an SAP HANA on-premise database.