Efficient Data Transfer from Azure SQL Database to SAP Datasphere to SAP Analytics Cloud

[rijin_baby61]

Hello,

I'm currently working on integrating Azure SQL Database (Azure DB) with SAP Analytics Cloud (SAC) to streamline data integration and analysis. I've been using SAP Data Warehouse Cloud (DWC) as the intermediary platform for replicating data from Azure DB and then transferring it to SAC. However, I'm curious if there are alternative and more efficient methods to achieve this data transfer without the need for data replication in DWC.

Here's the current process I've been following:

• Replication: Data from Azure SQL Database is replicated into SAP Data Warehouse Cloud (DWC) for centralized storage and management.
• Extraction and Transformation: Once in DWC, the data is extracted and transformed to prepare it for analysis.
• Transfer to SAP Analytics Cloud: Finally, the data is passed on from DWC to SAP Analytics Cloud (SAC) for advanced analytics and visualization.

While this approach works, I'm wondering if there are alternative methods that can offer improved efficiency. Specifically, I'm interested in exploring options that minimize or eliminate the need for data replication in DWC.

Thank you in advance for your contributions and expertise. I'm looking forward to hearing your thoughts and recommendations!

Best regards,

[rijin_baby61]

nikhil_1486

[Sven_Knpfler]

You could import the data directly into SAC from Azure: https://blogs.sap.com/2021/08/22/how-to-load-data-from-azure-synapse-sql-dw-to-sap-analytics-cloud-p...