Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply