Infobridge in plan not only transforms and integrates data from multiple sources but also enables direct writeback to a Microsoft Fabric SQL database. This process allows the transformed dataset produced in a bridge to become a governed dataset stored in the enterprise data platform.
This section explains how to write back the output of a bridge to a Fabric SQL database destination.
In the following example, a sample bridge is created using Infobridge that merges two data sources:
Through the Merge Query operation, measures from both queries are combined to produce a unified dataset that integrates actual and forecasted values.
Once the transformation is complete, the merged dataset can be written back to a Fabric SQL database. This writeback allows the combined data to be used by downstream applications such as analytics, planning models, and operational reporting systems.
Here's an example of transformed data:
Select Add new destination to add a writeback destination.
Enter the Fabric SQL connection information, including the connection name, database name for writeback, schema, writeback table name, decimal precision, and text length.
The writeback destination is configured.
Select Writeback from the Writeback tab. This instruction writes back the merged query to the chosen destination.
The data that is written back to the Fabric SQL database is shown in the following image.
