Question
4
Replies
790
Views
Posted: February 21, 2017
Last activity: October 13, 2017
Closed
SAP Hana integration supported?
Hi,
I am wondering if Pega supports integration with SAP Hana? is it possible to update and query SAP Hana like you would with a relational database? If so, what is the process?
Thank you.
Hi Siddharth,
SAP HANA can act as a RDB as well as an OLAP database and it was designed as a replacement to Oracle or IBM databases. SAP do provide a driver to allow applications to connect to SAP HANA via JDBC so I think we can connect to it through pega. If you are aware how to connect from PEGA to a database via JDBC, following link can help:
http://help-legacy.sap.com/saphelp_hanaplatform/helpdata/en/ff/15928cf5594d78b841fbbe649f04b4/content.htm
When we use BW(Business warehouse) on HANA, then it acts as a relational database and always produces a SQL statement so we might be able to query the same. I have never tried it though.