Hello,
We have a scenario where we need to read data from HANA DB using JDBC connection via PI 7.31 SP12. Though we are able to read the data successfully from a table on HANA db the requirement is to read the data from a view on HANA DB. Is it feasible to read the data from the a view and if yes could you please share the schema for it as well or direct me to the required documentation.
The schema being used to read from the Table:
<?xml version="1.0" encoding="UTF-8" ?>
<ns0:MT_KNA1_HANA_Request xmlns:ns0="http://abc.com/hana">
- < Statement > - < dbTableName action =" SELECT " > < table > ECCDATA.KNA1 </ table > - < access > < MANDT /> < KUNNR /> < LAND1 /> < PSTLZ /></access>
- < key > < MANDT > 080 </ MANDT > < KUNNR > 0000000106 </ KUNNR ></key>
</dbTableName>
</Statement>
</ns0:MT_KNA1_HANA_Request>
Thanks,
Ashish