Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to read data from SAP HANA views using CPI-DS

Alecsandra
Product and Topic Expert
Product and Topic Expert
‎2018 Sep 28 11:52 AM
2,502
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
1 Comment
Labels in this area
Popular Blog Posts