How to read data from SAP HANA views using CPI-DS
Just a short blog to share the steps you need to perform in order to read data from SAP HANA views using CPI-DS. I recently required this for extracting data from SAP CAR (Customer Activity Repository).
- Configure a datastore to connect to a HANA db. As a prerequisite, you will need the installation of the Hana client which includes an Open Data Connectivity (ODBC) interface.
- Import the calculation view considering the following guideline:
- The name should contain “package/view” between double quotes
- The view name is case sensitive. In below example, I tried with POSsalesquery but import failed with the error that table does not exist.