HOW TO CONNECT HCP TO A EXTERNAL DATABASE

[former_member331524]

Hi, Experts

We have been asked to develop html and java applications in HCP.

The requirement we must meet is that the applications must be connected to an external database, (ej. SQL Server).

Is this possible?

How can we do it?

Is there documentation or a blog describing this process?

If you can help us, I would appreciate it.

Regards.

[TuncayKaraca · Accepted solution]

Hi Juan,

I think it should be possible! It seems you can use SAP Cloud Platform - Connectivity service if your SQL Server supports HTTP connection. Check this: SAP Cloud Platform Connectivity

Also I think using SAPCP Cloud Connector has some advantages, check: SAP Cloud Platform Cloud Connector To use the connector you need to install into a server in your network, then create a destination in SAPCP.

Also if SQL Server supports OData, you can create destinations for OData and use.

Just some thoughts 🙂

[former_member331524 · Accepted solution]

Thank you Tuncay, Now I understand and I can think of several options to start. Regards.

[TuncayKaraca · Accepted solution]

Juan - Great, glad to hear!

[jamie_cawley]

You should be able to expose the db with some type of api and then use it to connect your apps to it.

Regards,

Jamie

SAP - Technology RIG

[former_member331524]

Thank you Jamie.