12. Data writeback

Inforiver writeback allows a user to export and save a report table to destinations of different types including file destinations, data warehouses, and data lake storage.

Inforiver, unlike other BI tools, does not require IT overhead in terms of database setup and defining the structure of writeback tables in advance. Inforiver instead supports dynamic database configuration and table creation at run time and performs semi-structured, on-the-fly writeback to more than one destination at a time.

Data writeback is a Writeback Matrix feature; you need to have a valid Inforiver Writeback Matrix subscription.

1. Overview

The Writeback screen is accessed by going to the Export tab in the toolbar. Three buttons give you access to writeback and related settings.

Writeback - Export report data to a destination.

Settings - Configure writeback-related settings. Navigate to the writeback settings chapter to learn more.

Logs - Every writeback event is logged with detailed information relevant to each writeback. Navigate to the writeback logs chapter to learn more.

Writeback will be disabled unless a row or column dimension is added to the visual.

2. Writeback Modes

You can choose whether to writeback the report alone or to writeback the report along with any associated scenarios.

Clicking on the icon below the Writeback button will show options for writeback.

Writeback options

Selecting 'Writeback All' will open a dialogue box, which lets you choose which scenarios to writeback. If you do not want a particular scenario to be exported - uncheck the box adjacent to the name of that particular scenario.

Writeback all

3. Configure Destination

Inforiver supports fast writeback setup and execution for several types of data destinations. Configuring writeback destination(s) is straightforward and involves the same procedure (picture below) for any destination.

On-premise database servers need to be directly reachable from the internet for writeback. For this, on-premise servers must have a public IP address with port forwarding.

Navigating to Inforiver writeback destination setup

A list of destinations will be displayed for the users to select from.

To learn how to configure each destination in the above list, navigate to this page.

The number of rows that can be written back is 200k rows for Excel and CSV and 250 rows for OneDrive and SharePoint

4. Overview of writeback steps

STEP 1: Navigate to the Export ribbon and click the Settings button to open the writeback settings side pane.

Writeback settings

STEP 2: In the general tab, set the writeback type, and optionally add filters and permissions. Learn more about General writeback options.

General settings for writeback

STEP 3: In the data tab, determine the scenarios and series to be written back and enable automatic writeback if applicable. Learn more about Data settings for writeback.

Data settings tab for writeback

STEP 4: Configure writeback destinations from the Destinations tab. Learn more about configuring destinations.

Destinations tab in writeback settings

STEP 5: In the advanced tab, you can prevent writing back if a specific column that should not be empty contains null values. You can also rename native fields and specify a different column name to be written back. Learn more about advanced writeback settings.

Advanced writeback settings

STEP 6: After configuring writeback settings, close the side panel and click the Writeback button. A notification window will display the progress and status of the writeback.

Writeback initiated

After performing an initial writeback, you may need to add or remove visual parameters as you build your report. Any table structure changes required in the destination due to adding or removing visual parameters will be displayed in a notification window. You can choose whether to drop the existing table and re-create it with the new structure before writing back.

Table mismatch notification

STEP 7: Click the logs button to navigate to the writeback log console and view details like the milestones, payload size, duration of the writeback, etc. Learn more about writeback logs.

Writeback logs

Resources

Writeback data and comments using Inforiver

Power BI Writeback is as easy as 1-2-3: A Step-By-Step Tutorial

Write back data & comments to a database or file

5 Reasons why Writeback is required in a Modern BI Stack

Why Writeback using Power BI + Power Apps is Not for Everyone

10 Key Considerations for Choosing a Writeback Solution in Power BI

Last updated