Creating reports

  • Variety of report parameters (filters) such as free-text, number, date-picker, datetime-picker, dropdown, checkbox, radio buttons.
  • Multi-selection parameters (checkbox list, multiple lookup, text list of IDs).
  • Optional and mandatory parameters supported.
  • Filters by relative dates, such as yesterday, beginning of the week, beginning of the calendar year etc.
  • Dynamic query parameters that may depend on each other.
  • System parameters such as $USER, that allow to narrow the data according to the current user's permissions.
  • Static and dynamic (SQL based) lists of available options in dropdowns and checkbox lists.
  • Multiple result tabs / widgets with a separate query and output in each. User can rearrange the layout as they wish.
  • SQL syntax highlighting.
  • Ability to use SQL variables, T-SQL and multiple statements.
  • Allow HTML mark-up in report results to add links and custom formatting into your reports.
  • Custom output column formatting.
  • Deep linking - every report has it's own URL.
  • Export and import of report definitions.
  • Auto-refresh of the report results - great for on-wall dashboards and monitors.

Running reports

  • Full UI customization to fit your company's brand. 
  • Export into Excel, CSV, or PDF.
  • Custom PDF templates.
  • Users can save and share filters.
  • Users can switch between flat table and chart/pivot view.
  • Various types of charts: bar and stacked bar charts, area charts, line charts, heatmaps and other.
  • Full table and chart customization.

Alerts and schedulers

  • Send reports on schedule as inline HTML, or PDF / Excel / CSV attachment.
  • Run set of scheduled custom commands and scripts, passing path to the generated report file as an argument.
  • Execute only if the report produces any data, perfect for alerts and notifications.
  • Flexible multiple schedules.

Creating APIs

  • Create full REST API from any SQL query in one click.
  • GET, POST, PUT, and DELETE are supported for data retrieval and modifications.
  • Auto-generated documentation pages
  • OAUTH2 token-based authentication
  • Seamless role-based authorization.

Creating business apps

  • Full CRUD access to data
  • Granular editing permissions
  • Inline cell editing or classic record form editing
  • Edit data in joins and complex queries.
  • Full audit trail of data modifications.
  • Bulk data import from Excel and CSV.

Integration with other applications

  • OAuth token identification for embedded reports. 
  • A report URL can be called from another application to run within iFrame or popup window, with all navigation hidden, with or without report parameters. 
  • Report parameters can be passed in query string, POST or via secure token.
  • You can use scheduled custom commands, such as FTP upload, so you can easily feed data to third-party APIs or run custom scripts.
  • You can link "external" reports to run any other webpage, effectively using SQLwallet as a portal for third-party or legacy web apps. SQLwallet can send parameters to an external app via POST or GET.

Security

  • Assign granular permissions on reports to users or teams.
  • Delegate permissions management to the users of specific reports.
  • Keep full audit trail on report usage, report editing and report permission assignment.
  • LDAP or built-in authentication. 
  • Full synchronization of users and groups from LDAP server. 
  • HTTPS supported.