Blog

Data Lake FAQ: Integration With SAP Business Warehouse

Written by Maciej Trembicki | Apr 26, 2021 1:05:21 PM

Data Lake Projects: An In-Depth Q&A Compilation by Lingaro

In theory, the advantages of a modern Data Lake over a legacy data warehouse are quite obvious. In practice, they are not. Many businesses’ data warehouses have been proven to work with their existing analytics workflows. The promise of improving these workflows with a new strategic approach is met with strong skepticism and detailed questions.

Fortunately, we have answers. We have years of cutting-edge Data Lake experience that includes global scale data solutions based on Microsoft’s Azure cloud platform.

In this blog series, we have compiled our answers to some of the most common questions we have encountered along the way. We hope you will find them useful, as you explore your own Data Lake Project opportunities.

 

Question

“Is it possible to have an integrated architecture where a Data Lake and SAP BW co-exist alongside each other?”

 

Answer

Yes. Here are a few example scenarios.

  1. Architecture for warm/hot data you keep only ‘hot’ data in SAP BW and ‘cold’ in Data Lake – it will cut the costs.

  2. Compute architecture move data from SAP BW to use cloud capabilities for scaling and calculation – it will cut costs and speed up the process.

  3. Decentralize the endpoint for retrieving data instead of steering all the reporting tools to