OneADETransform UniData and UniVerse data into structured SQL datasets.
Available / supportedOneADE, short for Advanced Data Extraction, helps you transform UniData and UniVerse ERP data into Microsoft SQL Server datasets. Your users select files, fields and relationships, and OneADE handles the MultiValue transformation for reporting and analytics.
Reporting tools speak SQL. Your ERP speaks MultiValue.
Reporting and analytics tools work naturally with relational SQL data, while MultiValue ERP data can contain attributes and relationships that are difficult to flatten cleanly.
Bespoke exports also create an ongoing dependency on IT for every new report. OneADE puts selection in the hands of trained users and produces SQL datasets that tools like Power BI can use directly.
What OneADE does.
Key capabilities
- Self-service file and field selection
- MultiValue flattening or linked sub-tables
- Relationship mapping between source files
- Adaptive SQL schema generation based on actual data values
- Windows import application for controlled one-off imports
- Automated batch processing service
Common uses
- SQL reporting databases for Avante and InfoFlo
- Power BI and analytics feeds
- Azure SQL reporting targets
- Reducing reporting load on the ERP system
- Reusable datasets for management reports
- Structured data for downstream systems
Can be adapted: Other UniData/UniVerse systems are suitable with configuration. Microsoft SQL Server and Azure SQL are the standard targets; other SQL databases can be considered on request with development and testing.
From MultiValue files to relational SQL.
Select
Trained users choose source files, fields and relationships on UniData/UniVerse configuration screens.
Transform
MultiValue attributes are flattened or represented as related SQL sub-tables.
Size
Schema sizing analyses actual data values each run, because dictionary lengths may not reflect real content.
Load
A Windows import application handles controlled one-off imports; a Windows Service processes complete batches automatically.
Report
Data lands in Microsoft SQL Server or Azure SQL, ready for Power BI, SSRS or other analytics.
Where it runs and what it connects to.
We install, configure and support OneADE as part of your wider system landscape, and shape each deployment around the systems you already use.
| Area | Detail |
|---|---|
| Deployment | UniData/UniVerse configuration screens, a Windows import application and an optional Windows Service. |
| Source | Mainly UniData Avante and InfoFlo today. |
| Target | Microsoft SQL Server, including Azure SQL. |
| Automation | Batch processing starts automatically when a complete export is ready. |
The heart of our reporting modernisation story.
UniData or UniVerse, through OneADE, into SQL Server or Azure SQL, then on to Power BI, SSRS or other analytics. Reporting moves off the production ERP and onto a dataset designed for it.
Where exported data needs to reach Azure Blob Storage instead of, or as well as, SQL, OneUpload can provide that hand-off.
OneUpload
Azure data delivery component
Find out more Available / supportedOneRep
Report export & distribution
Find out more Modernisation & IntegrationERP Data Extraction, SQL & BI
Turn ERP data into reporting-ready SQL datasets.
Find out more Modernisation & IntegrationModernise Without Replacing Your ERP
Extend, connect and automate around the system you already trust.
Find out moreMake your ERP data reporting-ready.
Tell us what you want to report on and where your data lives. We'll show you how OneADE could help.