Database type on SCP

[AllanGarcia55]

Hey everyone,

I just want to confirm which databases type I can have in SCP.

Of course we have the SAP HANA and I could find something for MongoBD and Postgresql:

• https://discovery-center.cloud.sap/serviceCatalog/postgresql
• https://help.sap.com/viewer/product/MongoDB/Cloud/en-US?q=postsql%20 -> apparently retired on Jan/15/2020.

My main inquiry is about the Oracle. I'm understanding that I can not deploy the Oracle database in SCP, but I can use the Cloud Connector to deploy an application in SCP connected to an on-premisse Oracle database:

• https://blogs.sap.com/2019/10/31/connecting-sap-cloud-platform-with-an-on-prem-oracle-the-socks-way/
• https://help.openconnectors.ext.hana.ondemand.com/home/oracledb-docs

Is my understanding correct? Any another insight?

thanks in advance.

[manjunath_b]

Hi Allan,

From a pure relational database perspective, the only options supported on SAP Cloud Platform are

SAP HANA: https://discovery-center.cloud.sap/serviceCatalog/sap-hana-cloud

PostgreSQL, hyperscaler option: https://discovery-center.cloud.sap/serviceCatalog/postgresql-hyperscaler-option

MongoDB as you rightly noticed has been retired and is no longer available for new customers.

As for the Oracle part of the question, I would leave it to the Integration experts to answer this.

Best Regards,

Manju

[Ivan-Mirisola · Accepted solution]

Hi allan_garcia,

manjunath.baburao has already commented your question with the db options that are cloud native on SCP. These are services offered by SAP that are completely integrated into SCP's offering.

You can make use of the Hyperscaler's services on SCP. All you need to do is to create the required credentials environment variables for your application so it can access the corresponding database service.

Regarding Oracle on-premise, I wouldn't use it as a database for a productive use. IMHO Databases should be as close as possible to the application that consumes it. Thus, by consuming it via Cloud Connector isn't a best practice. My recommendation in regards to integrating Oracle's db would be to use HANA's SDI (Smart Data Integration) to have data uploaded to a cloud native database and consume data from there on SCP. SDI has an Oracle Adapter, so you can make such integration seamlessly. This scenario is more in terms of having the power of Hana with the data being maintained by an application connected to your Oracle DBMS. There are other integration scenarios that are possible - but I believe this would be the best approach in which you will be taking the advantage of HANA's services and could potentially leverage SAP Analytics Cloud for Dashboards and drill-drown information and data insights. Not to mention that you could start developing cloud native applications in any programming language you choose. And if you are starting from scratch, you could also start developing using CAP.

Open Connectors will be an option if you want to have a database integration via RESTful APIs. With that in mind, it would make more sense to use Open Connectors via SAP Cloud Integrations. If you think about it, Open Connectors is a way to harmonize an API access. So, you wouldn't get a full blown JDBC connection to your database. Plus, you would have to expose the database APIs to the public internet and restrict it via security features. With this approach I would recommend you to use an Oracle database hosted in the same Hyperscaler where your SCP account is.

There are many other options like Data Intelligence, BO Data Services, SAP Cloud Integration, etc. If you give more details of what you are trying to accomplish it would be better for us to recommend you something else.

Hope this information helps.

Best regards,
Ivan

[AllanGarcia55 · Accepted solution]

Hi Ivan,

Thanks for all these details. Very appreciated!

Actually I have an on-premisse application running in Java + Oracle and I'm evaluating the options to migrate it for cloud. At this moment, the scope of this change is only the migration without any re-code. I was wondering if I can just deploy the app + DB in SCP but looks like it will require few adjustments to work as you brilliant shared.

We also are wondering another cloud options like AWS or GCP that seems fit better for my scope!

Thank again for clarifitication!

[Ivan-Mirisola · Accepted solution]

Hi allan_garcia,

SAP has a huge commitment to customers that are willing to migrate to HANA. In that case, if you want to conduct some investigations on how to migrate your Oracle DB to HANNA you could count on SAP's help. We have an internal tool that can be used to perform the migration to HANNA from several different database systems. The tool is run by SAP personnel, but you will get an overview of which artifacts can be migrated by the tool and which will require manual intervention. The tool will give you an rough ideia on the effort to do such a migration. Let me know if you are interested on having a conversation about this. I can put you in contact with the right person.

Best regards,
Ivan

[Private_Member_467521]

Hi allan_garcia,

Beyond the ones already mentioned, you also have the following options:

Object store - https://discovery-center.cloud.sap/serviceCatalog/object-store-service

ASE service - https://discovery-center.cloud.sap/serviceCatalog/sap-ase-service

Redis - https://discovery-center.cloud.sap/serviceCatalog/redis-hyperscaler-option

Cheers,

Luis

[AllanGarcia55]

Thanks Luis!