Skip to Content
Technical Articles

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

Be the first to leave a comment
You must be Logged on to comment or reply to a post.