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.

Grants portfolio dashboard
Round: 2026 ▾Program: All ▾All programsCommunity GrantsResearch FellowshipsCapacity BuildingEquipment
Applications0▲ 0% vs 2025
Approved0▲ 0% vs 2025
Total awarded0▲ 0% vs 2025
Avg. days to decision0▲ 0% vs 2025
Applications by month
ApprovedIn reviewDeclined
JanFebMarAprMayJunJulAugSepOctNovDec
Applications by program
0applications
Community Grants0%Research Fellowships0%Capacity Building0%Equipment0%
Approval rate by program
Community Grants0%
Research Fellowships0%
Capacity Building0%
Equipment0%
Applications – drill down
All programs › Research Fellowships › Jun 2026
ReferenceOrganisationStatusScore
RF-26-0118Harbourview InstituteIn review82
RF-26-0121Northgate UniversityApproved91
RF-26-0127Lakeside Medical ResearchSubmitted–
✓See the big pictureLive KPIs and charts on one screen
✓Filter instantlyEvery chart updates in one click
✓Drill into the detailFrom a chart to the individual record

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

Case study

SA Health

Before OmniStar, managing ethics and governance applications across our Local Health Networks meant relying on disconnected systems and manual processes, with no single view of application statuses or ongoing study management activities. OmniStar brought it all together, giving our team the visibility and structure to manage research activity consistently across the entire SA Health research ecosystem.

Stephen Shillabeer Manager Research Systems, Office for Research, Department for Health and Wellbeing
SA Health Logo

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

NHMRC Logo UWA Logo The University of Queensland Logo Siemens Logo Sunway University Logo SVHM Logo Department Of Health Logo National Breast Cancer Foundation Logo SA Health Logo RHC Logo

Ready to book a demo?

Book with us today and unlock the power of OmniStar.

Floating Image