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.
Best
Alecsandra
Hello Alecsandra, Thanks for the blog, Can we use the same approach to write data to HANA database as well?
Thanks
Nishant