5/17/2023 0 Comments Sap sourcingIn this blog we will see how to create a Virtual Table KPI in HANA Database instance, this will access the data stored in KPI table in HANA IQ store by establishing connection through remote source PDPSOURCE1. Virtual tables use a remote source to create a local table that points to data stored in IQ Store. This makes it possible to access data in remote sources without having to replicate it to the SAP HANA database beforehand. Virtual tables represent tables in the remote data source. Remote sources are connections to other databases, here these connections are made to SAP IQ store. Hana Database instance should be created in BTP sub account and it should be up and running.If you have not gone through my previous blog Introduction to HANA IQ store and how to load data into table in HANA IQ store from files in Azure Blob store, request you to go through it first. In this blog I am taking an example of table called KPI under schema DEMANDPLANNER. A database table should be present HANA IQ store with data.Hana Data Lake (HDL) instance with relational engine should be created in BTP sub account and it should be up and running.Global Account and Sub account should have been created in SAP Business Technology Platform (BTP).Create a CAP application and read data from HANA IQ store using virtual tables.Creation of HANA Virtual Tables in HANA database Instance and connecting to IQ store using remote source.Introduction to HANA IQ store and how to load data into table in HANA IQ store from files in Azure Blob store.This will be series of blogs containing following topics: In this blog we will see how to read data from tables in HANA IQ store into a virtual table using a remote source in HANA database instance.
0 Comments
Leave a Reply. |