https://community.sap.com/t5/technology-q-a/optimizing-data-processing-for-ui-migration-from-sap-netweaver-to-btp-cloud/qaa-p/13875812#M4885272 <P>May using SAP HANA Smart Data Access (SDA) or Smart Data Integration (SDI) to create virtual tables in your HANA Cloud DB linked to your On-Premise DB. If this works fine, that could allow data processing directly on your On-Premise DB without replication, but may have its own challenges.</P> Tue, 24 Sep 2024 11:03:04 GMT HakanHaslaman 2024-09-24T11:03:04Z https://community.sap.com/t5/technology-q-a/optimizing-data-processing-for-ui-migration-from-sap-netweaver-to-btp-cloud/qaq-p/13871058 <P>There is UI Migration going exchange the current UI from SAP Netweaver to BTP Cloud Foundry without switching databases.</P><P>Presently, data is replicated from CRM to our On-Premise DB via SLT and from On-Premise DB it is getting replicated to HANA Cloud DB. We have also created Virtual tables in HANA Cloud DB.</P><P>The users are using SAP Netweaver to download the data and processing (SELECT, JOINS, etc) takes place when users initiate a download from On-Prem DB.</P><P>Users are now working on an Application and HDI which is querying the replicated&nbsp;Virtual tables in HANA Cloud DB. This is consuming all memory from HANA Cloud DB.</P><P>Hence, we have a requirement from DB side where the ask is to exclude the use HANA Cloud DB from processing any queries (as we get memory issues due to big tables) and ensuring all data processing happens directly within On-Premise DB instead of&nbsp;HANA Cloud DB.</P><P>Since the data is Day Based, we are thinking for creating views using filters like&nbsp;country or region in On-Premise Database and replicating these views on HANA Cloud such that&nbsp;data will be pre-processed and ready for download for users, removing the need for any processing at the time the user clicks download.</P><P>Could anyone kindly let us know if this is approach is good and can be done. If not, we are open to suggestion if it can be done in any other better way. Please help!..</P> Thu, 19 Sep 2024 12:46:58 GMT https://community.sap.com/t5/technology-q-a/optimizing-data-processing-for-ui-migration-from-sap-netweaver-to-btp-cloud/qaq-p/13871058 KarthikKumar31 2024-09-19T12:46:58Z https://community.sap.com/t5/technology-q-a/optimizing-data-processing-for-ui-migration-from-sap-netweaver-to-btp-cloud/qaa-p/13875812#M4885272 <P>May using SAP HANA Smart Data Access (SDA) or Smart Data Integration (SDI) to create virtual tables in your HANA Cloud DB linked to your On-Premise DB. If this works fine, that could allow data processing directly on your On-Premise DB without replication, but may have its own challenges.</P> Tue, 24 Sep 2024 11:03:04 GMT https://community.sap.com/t5/technology-q-a/optimizing-data-processing-for-ui-migration-from-sap-netweaver-to-btp-cloud/qaa-p/13875812#M4885272 HakanHaslaman 2024-09-24T11:03:04Z