UBCDATA BRIDGE
HomeCapabilities
Capabilities

Everything your data needs. And the people who work with it.

Visual data preparation, system integration and governed business workflows in one platform. Choose a capability and explore how it works.

Collect and prepare data in one place

Collect data from Excel, databases and apps, remove what you do not need, match the required fields and send the result to a report or business system. See every step on one diagram. This process of preparing and moving data is called ETL.

Explore the details

Your files, connected to every workflow

Keep working files in the cloud or on your own server. Upload and preview them, connect them to workflows and collect the results in one place — with version history and a clear record of changes.

Explore the details

Put Excel and Google Sheets to work

Connect the sheets your team already uses. Read and write selected cells, combine ranges from different sheets and use Excel’s saved range names to follow changes in the workbook.

Explore the details

Automate everyday tasks

Connect manual tasks into one workflow: receive data, check it, ask for a person’s decision and update the required system. Help your team follow the same rules and see what happens at each step.

Explore the details

Use local data in cloud workflows

UBC Agent is a service for Windows, macOS and Linux that connects approved folders, databases and internal applications to Data Bridge. It runs inside your network and opens a secure connection. You decide which data it can access.

Explore the details

Set up data exchange between systems

An API lets applications exchange data automatically. Receive orders, check them against your rules and send the results to other systems. You choose the data, response format and access rules.

Explore the details

Connect your data to IBM Planning Analytics

Load data from files and business systems into IBM Planning Analytics. Data Bridge prepares it for analytics cubes, updates reference data and runs processes. Users can start from a button in IBM Planning Analytics Workspace, choose parameters and review the result.

Explore the details

Start a workflow with one button

Add a button to IBM Planning Analytics Workspace, UBC Analytics or a company webpage. Users choose parameters or a file, start the workflow and see its status in a familiar interface.

Explore the details

Let recurring tasks run automatically

Set data exchanges to run at a chosen time, at regular intervals or after a source changes. Data Bridge runs the prepared workflow and sends a notification so your team knows the result.

Explore the details

Control access and see the results

Choose who can view, change and run workflows. Check new settings before using them, then see what ran, which data was written and where an error occurred.

Explore the details
Data preparationETL
SOURCES
Excel · CSV
SQL
REST API
Transform

Map · join · apply rules

Rules configured
OUTPUT
Database
Analytics cube
1Extract
2Transform
3Validate
4Load
ONE CLEAR WORKFLOW

From the first connection to a repeatable result.

  • Connect sources and inspect their structure
  • Build transformations and business rules
  • Add parameters, user choices or an API
  • Simulate without business writes
  • Publish Production and configure execution
Step-by-step guide
FROM IDEA TO WORKING FLOW

Bring your challenge. See a way forward.

Sources, rules and outcomes — let’s build the conversation around your workflow.