Analytics that never slow your day
Heavy reporting and day-to-day work compete for the same system when they share a database. Reports run slowly, forms save slowly, and nobody can see how the data looked last quarter.
OmniStar keeps a reporting data warehouse separate from the database your staff and applicants work in. It is refreshed on a schedule set for your site, keeps history as data changes, and feeds OmniStar's dashboards and reports, the Reporting API and, if you choose, your own BI tools.
You report on today's data and yesterday's, without slowing anyone down.
It works with our Power BI integration.
Applications by month
Applications by program
Approval rate by program
Applications – drill down
What the warehouse holds
Kept apart from daily work
Reporting queries run against the warehouse, not the live system, so analysis never slows applicants or staff.
History as data changes
The warehouse is temporal: it keeps earlier values as data changes, so you can report on how things stood at any point.
Ready-made views
Denormalised views by area, across applications, contacts, finance, forms, meetings, projects, reviews and the system, with a published data dictionary.
Views for your site
Custom views specific to your organisation, alongside the standard ones.
Security that follows the data
Record-level access rules apply to the warehouse, and row-level security can be switched on for individual customers on request.
Know how fresh it is
The Analytics home page shows when the reporting database was last updated.
Four ways to the data
The same warehouse serves everyone who needs the data, each with the right level of access.
- OmniStar dashboards and reports, built in the browser
- The Reporting API, with record-level security applied
- The Enterprise Reporting Connector, for your BI tools
- Spreadsheet extracts in CSV or Excel
The Enterprise Reporting Connector
For organisations that report across systems.
Direct, read-only SQL
Connect straight to the reporting database with standard SQL, across the standard and custom data sets and the history behind them.
Power BI and more
Use Power BI, Excel, SQL Server Management Studio, Azure Data Studio and other tools that connect over ODBC.
Feed your own warehouse
Take full or incremental copies into your own data warehouse or data lake.
Point in time
Query the data as it stood on an earlier date, for historical and as-at reporting.
A key for each user
Each user has their own access key, which can expire, with lockout after failed attempts.
Encrypted and logged
TLS 1.2 or higher in transit, AES-256 encryption at rest, and every connection and sign-in attempt written to the event log.
Data you can trust
Answers from SmartForms are mapped into the warehouse, so reviews, applications and milestone reports are all reportable. Each refresh either rebuilds the warehouse or updates it in place, and long text fields can be shortened to keep it fast.
- Form answers mapped for reporting
- Refresh settings chosen for your site
- Sign-in and security events available for reporting
Frequently asked questions
It gives your BI tools direct, read-only SQL access to OmniStar's reporting database, including the history of how data has changed. It is set up for the environments you choose and included in your quote, alongside the built-in dashboards and reports in every subscription. See pricing.
Yes. Power BI connects to the Enterprise Reporting Connector over ODBC, for visualisation or to feed a data lake. See OmniStar and Power BI.
Yes. The reporting database is temporal, keeping earlier values as data changes, and the Enterprise Reporting Connector can query it as at an earlier date.
Regularly, on a schedule set for your site, so dashboards and reports are near real time. The Analytics home page shows when it was last updated.
Yes. Each user has their own access key, connections use TLS 1.2 or higher, data is encrypted at rest with AES-256, and every connection is logged. Record-level access rules apply to the reporting data too.
Related features and use cases
Dashboards and reporting
Build interactive dashboards and formal reports in the browser, share them safely with staff and external users, and export them for committee papers and briefs.
Audit log, timeline and traceability
An audit log, event log, status history and timeline that show who did what, when and what changed, for every application, project and decision in OmniStar.
Sign-in, MFA and security
Let staff sign in with your identity provider and everyone else the way that suits them, protect every account with MFA and breached-password checks, and control what each person can see down to the record.
Research funding from pre-award to post-award
Manage externally funded research from opportunity and proposal costing through submission, award, contracts, milestones and acquittal, in one research management system.
Commonwealth grants and CGRP compliance
Administer Commonwealth grants in line with the Commonwealth Grants Rules and Principles 2024, from merit-based assessment and ministerial briefing to GrantConnect reporting and variations.
Trusted by industry leading organisations

Ready to book a demo?
Book with us today and unlock the power of OmniStar.
