Firefly allows authorised users to create SQL queries and run those against a wide range of ODBC Databases.
Any source supporting the SQL standard. Integrate in the same portal and page data from different databases.
Share search criteria across different database servers for rapid and simple searching
Present data as grids, charts, gauges and maps quickly.
Include embedded variables in the SQL to allow dropdown, date pickers etc to be included in the SQL to allow all users without SQL experience or not use the queries.
The SQL can also be hidden the queries shared with only the variables visible.
Allow data exports if required, schedule email deliveries and control volumes exported to ensure large queries do not impact performance.
Use Firefly's role-based security options to ensure users only access the information they're authorised to see.
Provide audit and logs on searches run by users with Syslog or security monitoring as required.
Firefly protects against SQL injection and other threats as part of its security controls to prevent malicious queries from gaining access or control.
