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 an enterprise feature; you need to have a valid Inforiver Enterprise 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.

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.

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.

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.

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