Access and Query a Data Product in SAP HANA Cloud

A formation is a logical grouping of SAP systems that simplify the connectivity setup and to provide a unified view of the systems. For further details see How Data Products Become Available in SAP HANA Cloud, Automating Integrations Using Formations, Creating SAP Business Data Cloud Formations, and Introductory Guide to Provisioning of SAP Business Data Cloud.

1. Navigate to formations in the SAP Business Technology (SAP BTP) Cockpit and select Create Formation.

   

2. Create a new formation of type Integrations with SAP Business Data Cloud.

   

3. Select the products to be part of the formation.

   

4. Complete the formation.

Now that trust has been established between SAP BDC and SAP HANA Cloud, a data product can be located in SAP BDC and shared to SAP HANA Cloud.

1. In the SAP BDC cockpit, select Catalog & Marketplace and search for a data product.

   

2. The details of the data product including the description and its properties can be examined.

   

3. Details of the objects included can be displayed by examining the API.

   

   It is also possible to examine the columns of each object by clicking View Columns.

   

   

1. Once a data product has been identified that you wish to be able to access from SAP HANA Cloud, select the Share button in the top right of its details page.

   

   Specify the system to share the data product with by pressing Add a Target.

   

   Specify an SAP HANA Cloud system as a target.

   

   Finally complete the process by pressing Share.

   

The data product that was previously shared can now be installed into SAP HANA Cloud which will create a remote source to the data product and create virtual tables for each object in the data product.

1. Open SAP HANA Cloud Central and select the SAP HANA Cloud instance in which you wish to install the data product.

   

2. Select the previously shared data product and choose install.

   

3. The database user that is currently connected will be granted read access to the virtual tables. The below SQL is an example of granting an additional user access to the schema that contains the virtual tables.

   SQL Copy

   GRANT SELECT ON SCHEMA "_SAP_DATAPRODUCT_sap_s4com_dataProduct_SalesOrder_v1_4a6dc5d7-7af5-4b74-8ac7-b9ed0d1e6e95" TO USER1;

1. Start by selecting the schema of the data product.

   

2. The database objects app will now open with a schema filter applied.

   

   As shown above a virtual table was created for each object in the data product.

3. A remote source was created that provides the connection to the data product.

   

   Further details on remote sources can be found at CREATE REMOTE SOURCE.

The data in the data product can now be queried using the virtual tables. An example is shown below.

SET SCHEMA "_SAP_DATAPRODUCT_sap_s4com_dataProduct_SalesOrder_v1_5aad3293-2564-4873-8c15-188e653f781b";
SELECT COUNT(*) FROM "_SAP_DATAPRODUCT_c9429f3e-0d0b-4d0b-9364-cec9e77daebe_salesorder.SalesOrder" AS SALES_ORDER;
SELECT COUNT(*) FROM "_SAP_DATAPRODUCT_c9429f3e-0d0b-4d0b-9364-cec9e77daebe_salesorder.SalesOrderItem" AS SALES_ORDER_ITEM;
SELECT * FROM "_SAP_DATAPRODUCT_c9429f3e-0d0b-4d0b-9364-cec9e77daebe_salesorder.SalesOrder" AS SALES_ORDER;
SELECT * FROM "_SAP_DATAPRODUCT_c9429f3e-0d0b-4d0b-9364-cec9e77daebe_salesorder.SalesOrderItem" AS SALES_ORDER_ITEM;
SELECT "SalesOrderItemText", COUNT("SalesOrderItemText") FROM "_SAP_DATAPRODUCT_c9429f3e-0d0b-4d0b-9364-cec9e77daebe_salesorder.SalesOrderItem" 
        AS SALES_ORDER_ITEM GROUP BY "SalesOrderItemText" ORDER BY COUNT("SalesOrderItemText") DESC;

Congratulations! You have now learned how to install and query a data product using SAP HANA Cloud. See the blog post Consuming Data Products in SAP HANA Cloud via SAP Business Application Studio/SAP Build Code to learn how to use a data product from within a calculation view.