Bridge Interface

Every bridge includes a transformation editor that allows you to transform and prepare the data as required. As soon as you create a new bridge, you will be navigated to the bridge interface, as shown below.

It has five distinct sections:

  1. Toolbar: It contains menus and tabs for adding and managing sources, transforming data, viewing logs, exporting, and writing back data.

  2. Queries pane: This pane at the left provides a list of all your available queries for viewing, editing, transformation and integration. Select the desired query here to view and transform the data.

  3. Working view: This is your primary working view, where you can view your data and the results of the applied transformations. A small menu bar at the top allows you to change the viewing style, number scaling, total display and other settings.

  4. Query Settings & Writeback pane: This pane at the right displays the list of sources and their links for the current query, as well as the applied transformation steps and post-processing options such as writeback settings.

  5. Status bar: The status bar at the bottom shows the total number of pages and rows in the current query. It also has buttons for zooming in and out, as well as navigating to different pages.

Using the bridge editor interface

In this section, we begin transforming our data for real-time integration and collaboration. But before we start working on that, we will discuss the aforementioned UI panes in detail.

1. Tool Bar

The Toolbar contains most of the transformations and actions that we can do in the bridge editor interface. It has multiple tabs. Each tab provides specific buttons and options, while some common options are always made available. With a click of these buttons and options, you can easily transform your data.

  • The 'Home' tab contains all the query-related actions, data-related actions like pivoting, grouping, etc., and export options.

  • The 'Data' tab displays a subset of the 'Home' tab options, that primarily focus on data sourcing and querying.

  • The 'Transform' tab displays all the data-related transformation options, such as filter, sort, pivot, unpivot, grouping, extracting data, renaming and removing columns, etc.

  • The 'Writeback' tab displays three options: writeback, writeback settings and writeback logs. You can also access these options from the Query Settings and Writeback pane.

  • The 'Logs' tab displays all jobs associated with the bridge. It includes a search box and filters for extracting specific logs based on the query, source, who started the job, when the job started, job type, and status. This can help with troubleshooting the required jobs.

  • The 'Integration' tab displays the Inforiver and ValQ visuals linked to the selected query. Select a query from the queries pane to view its visual mappings. When looking for integrations, you can use the search box or filters to find a specific mapping.

The 'Earnings-source visual' query in the image below is linked to the Inforiver report 'Sum of Earnings by OrgName, Department'. This allows the visual to pull data from the query via the bridge.

2. Queries pane

This pane displays all your queries generated from various data sources for your review. Beside each query, you have options to rename, refresh, duplicate, and delete it. When you select the required query, the corresponding data is loaded into the workspace for viewing and transformation.

3. Working view

Here you can see your query data as well as the transformation results. It also has a menu at the top where you can change the layout style, scale, increase or decrease decimals, and show or hide totals.

4. Query Settings & Writeback pane

This section displays the list of connected sources, transformation steps completed, writeback settings, and the option to add new writeback destinations.

Source

Click the icon next to the source name to navigate to the desired source. You can also use the 'Refresh' option to refresh the source.

Performed Steps

The steps completed during the transformation are listed in this section. If required, you can modify and re-apply the steps, remove any of them, and add an explanatory note for each step.

Post Processing

It has writeback general and destination configuration settings and writeback logs.

5. Status bar

Navigate to the different pages in the query, and zoom in and out of the data using the options available here.

Last updated