Writeback Transformed Data from Infobridge

Infobridge not only transforms and integrates data from multiple sources but also enables direct writeback to a Microsoft Fabric SQL database. This allows the transformed dataset produced in a bridge to become a governed dataset stored in the enterprise data platform.

This section explains how to writeback the output of a bridge to a Fabric SQL database destination.

In the example below, a sample bridge is created using Infobridge that merges two data sources:

Query 1 – A Planning Sheet containing 2026 Actuals
Query 2 – An external Excel file containing forecast and projected revenue

Using 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 allows the combined data to be used by downstream applications such as analytics, planning models, and operational reporting systems.

Transformed Data

Add new destination

Click 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.