Access data from HCP application

[former_member202548]

Can we access data from other databases such as SQLServer from HCP application? How ?

[Former Member]

Hi Megha,

I think it should be possible to connect to your on-premises databases via cloud connector.

Some information on configuring cloud connector.

https://hcp.sap.com/developers/TutorialCatalog/con100_1_setting_up_cloud_connector.html

On successful connection to on-premises database, you can use virtual tables on HANA via SDA to access this data in your application.

Gopal

[Vlado]

The supported databases on HCP are SAP HANA and SAP ASE. See SAP HANA Cloud Platform

[former_member202548]

Thanks for your reply, but what is customer has some other database and want to access HCP application, How will that be possible ? How can we access data from other DB and use in HCP application ?

[Vlado]

For outbound connectivity from HCP apps currently the supported protocols are HTTP, Mail and RFC. Therefore you would need to expose your data over HTTP and then use SAP HANA Cloud Connector to connect to your on-premises system. See SAP HANA Cloud Platform for more details.

Another option would be to use SDI (Smart Data Integration) - see - however that's not yet available on HCP.

HTH!

--Vlado