Skip to Content
Technical Articles
Author's profile photo Alecsandra Dimofte

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

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nishant Kathuria
      Nishant Kathuria

      Hello Alecsandra, Thanks for the blog, Can we use the same approach to write data to HANA database as well?

      Thanks

      Nishant