BTP application writing to on-premise HANA database table / Datasphere HANA database table

[MelCalucin]

Hello,

We have some BTP developers creating an app that would write to an on-premise HANA database table (this database is used in for BW/4HANA).

We eventually want to migrate the BTP app to write to a Datasphere table. 

Is there a connection framework where we can easily switch the BTP app from writing to the on-premise HANA database table to writing to the Datasphere table?

Thanks.

Regards,

Mel Calucin

[romanbelosludts]

Hello Mel Calucin,

you could migrate SAP HANA on-premise database to SAP HANA Cloud and then augment with SAP Datasphere, this way you don't need to create a new application from scratch, you could reuse your SAP HANA on-premise scenario.

We offer multiple migration tools depending on a migration scenario.

1. The Self-Service migration tool for SAP HANA Cloud

The tool migrates SAP HANA database components (catalog and data inside SAP HANA database) to SAP HANA Cloud including XSA service instances (if applicable).

2. SAP HANA Application Migration Assistant

This tool mainly migrates Design-Time components from SAP HANA XS Classic and SAP HANA XS Advanced to SAP HANA Cloud CAP (Cloud Application Programming Model)

Kind regards,

Roman

[Sebastian_Gesiarz]

Hi, It should be easier as it's cloud to cloud so you don't need to care about the firewalls. In DSP, you whitelist the IP (unless it's same platform then most likely you don't need to) and provision a DB user and password of the space with CRUD authorizations (you create one in the space administration) in the njs code where you specify the host/port/uid/pwd. So in the end you just remove some code and change the parameters. Never done it but it's how I would imagine it to work:)