There has never been a higher need for smooth and secure data-sharing solutions than today in the field of data management and communication. Traditional methods of sharing data include file shares, FTP, email, and APIs. However, to transfer data between teams and organizations, most of these techniques require creating and maintaining data pipelines at both ends. Microsoft Fabric, a unified platform designed to meet your organization’s data and analytics needs, can help you solve this problem!
Database shortcuts in Real-Time Analytics for smooth data sharing
The database shortcut in Real-Time Analytics is an embedded reference within the KQL database. It lets you source databases in Azure Data Explorer (ADX) for smooth in-place data sharing. The database shortcut behaves in a manner to follower the database.
When to use database shortcut?
You can construct a database shortcut if you are a data provider hosting data in Azure Data Explorer and you would like to share this data with customers in Microsoft Fabric. Real-time data sharing is possible by using database shortcuts, which eliminate the need to create and manage data pipelines. Every database modification made by the supplier, including schema and data, is immediately available to the consumer.
With just a few clicks, your current ADX clients may also test Microsoft Fabric without having to re-ingest the data.
Scenario
Imagine a scenario where:
- Data provider shares data with business partners
- Data consumers combine their own data with data they have collected from various business partners in order to gain insights.
How does a database shortcut work?
Within Azure Data Explorer, the owner of the source of the database, and data provider share the database with the user who created a shortcut in Real-Time Analytics, who is referred to as the data consumer.
The database shortcut is attached in read-only mode, which lets you view and run queries on data ingested into the source Azure Data Explorer database. Changes made in the source database are synchronized using the database shortcut.
In order for ISVs to easily exchange data with their clients, the source ADX database and the database shortcut in Real-Time Analytics must be located in the same region, however they may be in separate tenants.
