Creating virtual tables from remote source in SAP HANA

When a remote source is added, you can see all the existing tables under that data source in HANA Studio. Next is to create virtual table mapping to data in the remote data sources in SAP HANA Studio. This can be done using GUI option.

To add a table as a virtual table, you need to navigate to remote data source → Schema name → Table name → Right-click and Add as Virtual Table

Below shows how you can add a table as a Virtual Table using HANA Studio.

Anil SAP Gupta

Published on 21-Feb-2018 18:10:31

• Related Questions & Answers
• Creating new Remote Source using SDA in SAP HANA
• Creating a new remote source in SAP HANA using SQL
• Updating configuration property file in SAP HANA Remote source
• Using DSN name while using a remote source in SAP HANA
• Creating Index in Column based tables in SAP HANA
• Information required adding a new remote data source in SAP HANA SDA
• Unloading tables in SAP HANA database
• How can I transfer data from SAP HANA to virtual table?
• Remote system allowed in SAP HANA Smart Data Access
• Creating a new table in SAP HANA
• Creating an Attribute view in SAP HANA
• Creating a Restricted user in SAP HANA
• Creating column table in SAP HANA database
• Creating a Delivery unit in SAP HANA using HANA Studio
• Remote data sources supported under SAP HANA SPS06 SDA