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.

Best

Alecsandra