Documentation

UBC Data Bridge 2.1.1: data exchange, APIs, private-network resources and controlled workflows.

From a data source to a validated result in one visual flow.

Step by step: upload a table, select rows and produce a file.

Source, connection, block, flow, draft and run are distinct system objects.

System components and responsibilities, independent of implementation languages.

How the system executes a graph, controls resources and prepares writes.

A standalone product or integration with UBC Analytics; online and offline distributions.

What is stored in the database, what is stored as files and how isolation works.

Find flows, connections and sources, and work with folders and editing locks.

Canvas, blocks, ports, properties and intermediate-result analysis.

Editing, autosave, simulation and publication of a working version.

How to read statuses and avoid duplicates after a failure.

Run a flow from a corporate portal: purpose, URL-based embedding, statuses and the interactive wizard.

Start by time, interval or a source change.

How to turn a file into a stable table for a flow.

Managed files, versions, folders and retention settings.

Configure Google Drive, OneDrive, S3, FTP/FTPS and a network drive.

A shared procedure for creating, testing and using service access.

Tables, queries, keys and insert/update modes.

Resources, formats, response pages and row delivery.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Connection settings, required fields and usage rules.

Choose an API direction, prepare access, publish a flow and verify the complete exchange cycle.

Configure an inbound endpoint, field validation, a Production flow, idempotency and delivery tracking.

Configure a REST connection: authentication, response parsing, pagination, batch writes and retry controls.

Publish a dataset with filters, pagination, freshness checks or execution on demand.

Give an external system controlled flow access and verify its key, HMAC signature and permissions.

Generate the current endpoint reference from its settings, give integrators access and verify the contract.

Connect UBC Data Bridge to private network resources, register an Agent and manage its access throughout its lifecycle.

Install the Windows service, register it securely, grant folder access, verify connectivity and maintain the Agent.

Install the Agent on a Mac, register it, configure service permissions and network volumes, and manage updates.

Prepare Linux, connect Agent to Data Bridge, grant folder access and check that the service works.

Configure allowed folders, databases and APIs, proxy authentication, trusted certificates and the route to Data Bridge.

Find the cause of Agent failures, check networking and permissions, retry file operations safely and prepare a useful support report.

Blocks for processing, interaction, flow calls, APIs and result delivery.

Reads a registered file source or writes to its range.

A single block for business systems, databases, file storage and external APIs.

Keeps the required fields and changes their order and names.

Converts a wide table of periods into “period — value” rows.

Builds a new table from selected columns and constant values.

Keeps rows that meet the specified conditions.

Groups rows by keys and calculates aggregates.

A user form and constant values that control execution.

Combines the rows of several tables into one dataset.

Adds fields from other tables using shared keys.

Keeps the required occurrence of each key, or only keys that occur once.

Distributes rows between conditional branches, including by reference data.

Passes the entire table to several branches at the same time.

Adds calculations for numbers, text, dates and conditions.

Compatibility with saved flows that upload a file at this step.

A review table during execution and a way to end a branch without writing.

Creates an Excel, CSV, TXT, JSON, XML or SQLite file.

Sequential cleansing and standardisation of text fields.

Adds a GUID, Snowflake ID or sequential number.

Recognition, normalisation and formatting of numbers and calendar values.

Rules for replacement, row rejection and stopping on quality errors.

Adds the measures from a single auxiliary row to every row of the main table.

Swaps the rows and columns of a table.

Displays a notification or dialog during user-driven execution.

A manual user decision that activates one branch.

Continues one of the alternative branches that executed.

Conditionally changes existing fields and adds new ones.

Sends emails through a configured email connection.

Sends messages and attachments through a bot.

Adds current UBC Analytics role and user values.

All functions in the documented version: signatures, purpose and examples.

Copy and move files and folders between File Manager and connected storage.

Separate branches for a manual start, inbound API and Workspace button.

Start the Production versions of one or more other flows with parameters and data.

An input for a subflow or process receiving a table from another flow.

Reuse a flow as a function: an input table and a transformed output table.

A declared output returned to the calling subflow block.

A source block for external request data and files: formats, fields, keys, validation and simulation.

A branch-ending block that publishes a flow result with parameters, filters and an execution mode.

How UBC Data Bridge works with TM1, which objects are available and how to choose an integration scenario.

REST address, network access, certificates and five authentication methods.

How UBC Data Bridge login, Cognos and TM1 access with personal permissions work together.

A saved account for automated flows, the Cognos gateway and login constraints.

IBM source settings, output columns, consolidations and volume limits.

How to export IBM reference data with structure, weights and repeated element occurrences.

Selecting a dimension element in the run form and using its value in destinations.

Dimensions, constants, mapping tables, aliases and duplicate-coordinate handling.

What is checked before writing and how to handle confirmed or uncertain results.

Addition, replacement, controlled clearing and cube updates driven by form-save events.

Selecting a TI process, parameters, simulation, IBM status and the distinction from Chores.

Connect a book through a URL: Data Bridge and PAW setup, styling examples, statuses and the report-update wizard.

A unified access model for local login, OIDC, IBM CAM and UBC Analytics.

Environments, workspaces, forms, cubes and launch buttons.

How to move flows, sources and connections between environments.

From an error message to checking a specific block.

Activation, validity period and checking system operation.

Using UBC Data Bridge 2.1.1 documentation, examples and illustrations.

A practical progression from a simple CSV import to writing into IBM Planning Analytics.

Read a semicolon-delimited sales file, preserve column names and produce JSON for the next integration.

Prepare a wide Excel budget template for loading into a model with a period dimension.

Take the data.items array from JSON and create a flat CSV with a consistent column order.

Select repeating XML elements, use the id attribute as the code and write the catalog to Excel.

Normalize product codes to one spelling and retain the last record for each code.

Correct missing values and negative quantities, replace Excel errors and reject rows containing unacceptable text.

Calculate revenue for each sale and prepare a summary table by region.

Join prices to sales by a numeric key while retaining rows with no price.

Combine two sales datasets into one table by column names, even when their order differs.

Split orders into priority and regular orders by amount, with a separate file for each branch.

Compare a request amount with its department's individual limit rather than a single constant for everyone.

Let the user choose a region and minimum amount without editing the flow itself.

Read a limited set of SQL records with one SELECT query and create a verification CSV.

Update an existing product by its sku key and add a missing product to a training SQL table.

Read an API resource, extract the data.items array, retain open orders and produce Excel.

Read a public IBM Planning Analytics cube view and pass it to a tabular report.

Unpivot months in a budget workbook and write four values to a training cube with explicit mapping of every dimension.

Start one training TI process with a fixed year and a scenario chosen in the execution wizard.

Let the operator approve or reject a set of requests and return to a shared export after the selected action.

Find orders with a negative amount and send a concise report to a control group through two channels.