Bring your data together in UBC Analytics
Connect UBC Analytics forms, reference data and reports to your other systems. Data Bridge processes user entries and external data, checks them and passes the result to the next step.
Data preparation
Shared logic for forms, reference data and cubes
Process the record that launched a flow
Bring external data into business workflows
Populate forms with consistent data
Map source columns to form fields, enrich them with reference values and define a unique record key. Existing records can be updated and new ones added. A daily flow might retrieve exchange rates, find currencies in a reference form and update records by date and currency code.
- Map fields, constants and run parameters
- Look up records in reference forms
- Update by key and generate codes for new records
Make processing part of a user action
A flow can start from a particular form record and use its data together with role and user context. Add conditions, calculations and relevant messages. Integration becomes an understandable operation: validate a request, enrich its data or pass it to the next system.
- Use the form record that launched the flow
- Show parameters and dialogs suited to the scenario
- Update statuses and fields after validation
Select the objects
Choose the forms, reference data and cubes in the required environment.
Build the rules
Configure keys, mappings, validation and launch context.
Enable the working scenario
Check the flow and choose a form action, schedule or API as its starting point.
Connect operational data to analytics
Use forms, dimensions and cubes alongside external files, databases and APIs. Prepare actuals, align reference data and deliver measures to the model. Other applications can also consume results through Data Bridge APIs with configured access controls.
- Read cubes, dimensions and forms
- Map and write measures into cubes
- Exchange data between UBC Analytics and external systems
Your questions, answered.
How to connect your data, manage access and get started.
Where is this integration available?
It operates in the Data Bridge deployment within UBC Analytics, with access to objects in the corresponding environment.
How can I avoid adding the same records repeatedly?
Define a unique key using input columns and the correct mappings. The flow checks keys and updates matching records according to configuration.
Can a form be connected to an external API?
Yes. Form data can be transformed, enriched from external sources and delivered through configured connections.
Let’s start with your task.
Tell us which data you need to connect. We will explain how it works and show you an example.
Bring your challenge. See a way forward.
Sources, rules and outcomes — let’s build the conversation around your workflow.