on
RE:
Click
RE:
">
RE:
">
RE:
>
RE:
>
RE:
'/*\'/*"/*\"/*
RE:
">
RE:
RE:
RE:
Let’s clarify it further building a Data Warehouse based on an Azure SQL DB with shortcut the enhanced approach using Microsoft Fabric:Assume Scenario: We have an application that stores data in an Azure SQL DB. Unfortunately, creating additional DB objects (such as views or stored procedures) within this database is restricted.To build a Data Warehouse based on the Application DB we have below options Traditional approach Option 1: it need to transform the data into dimensional model and load it into independent Data Warehouse which in-turn additional efforts and resources needed.Traditional Approach Option 2 (Linked Server):Create a linked server to the Application DB from a new database server. Use views or stored procedures to transform the data into a dimensional model.However, this approach has limitations, including potential performance bottlenecks and security concerns.To enhanced approach using Microsoft Fabric: Replace the linked server with Microsoft Fabric (a modern alternative).Create a shortcut of application database into the new Data Warehouse or Data Lake. This shortcut provides read-only access to existing objects in the Application DB.Leverage Fabric features to efficiently transform application data into a dimensional model with additional security layer.Enjoy the benefits mentioned in the original idea.