Secure

Access to data in a secure and controlled manner

Control Access to data using SSO groups

SSO Groups

  • Reports can use SSO groups to alter or refine results
  • Restrict PII to certain groups
  • Use OATH2 to login and establish groups

Auditing

All reporting actions recorded

  • Report name
  • Date and time of report
  • Parameters used

Schedule

Easy to setup scheduled reports

  • Hour
  • Day
  • Month
  • Encrypted
  • Custom addresses

Scheduled API updates

Easy to setup scheduled API updates from existing reports

  • JSON format
  • Custom headers
  • To any web site
  • Flexible schedules

SQL

All reports are based upon SQL

  • Industry standard
  • Reuse existing code
  • SQL to all supported databases
  • JINJ2 macro support
  • SQL Reference

AWS Keystore

Credentials can be read from AWS key stores

  • No need to share passwords
  • Developers never see passwords
  • Allows password rotation
  • Supports plug in to other key stores

Charts

Reports can be charts

  • Line
  • Bar
  • Pie
  • Simple setup and use

Dashboards

Join queries together to create easy dashboards. Flexible rich data display allows rapid development

  • Display images
  • Formatted JSON
  • Web links
  • HTML
  • Embedded iframes
  • Multiple column drill downs
  • Pie charts
  • Line charts
  • Bar charts
  • Unlimited dashboard panels

Custom Groups

Define your own groups outside of SSO

  • Attach emails to groups
  • Use groups to control report access
  • Groups are used to dynamically rewrite queries

Report Options

Define many parameters to control report queries. Customize colors and icons

  • Date
  • Text
  • Numbers
  • Choices from databases
  • Checkbox
  • Email
  • User defined choices
  • Data dependent row styles

Auto Refresh

Refresh online reports on a timer

  • use as an auto refreshing dashboard

Trigger Reports

Reports can be generated only when data exists

  • Alert on excess transactions
  • Alert on PII breaches
  • Customize alerting and only get results when needed

Report design workflow

Use built in facilities to create, review and approve new and updated reports

  • Review
  • Comment
  • Approve or Reject
  • Promote reports from test to prod