A Query Proxy is a Secure API for querying

API access to database data in a secure and controlled manner.

Turn any database query into an API.

SSRS like report building.

Secure by design

Solves

  • Building API access
  • Provisioning users
  • Managing fine grain access
  • Scheduling Reports
  • Consolidating multiple servers
  • Providing drill downs
  • Auditing and tracking
  • Showing complex queries
Image of cordless screwdriver to illustrate fixing things. https://unsplash.com/@neonbrand

Solving the hard issues

Prophund fixes problems by removing the barriers and risks with providing data access.

Provisioning users

OATH or LDAP Adding users to the right databases and systems to allow access to data can be time consuming. Wasting assets and opportunities. Prophund Reporting uses your organisation's SSO to seamlessly allow access with no onboarding or passwords required.

SSO groups are used to provide fine grained access.

Passwords are not maintained by Prophund Reporting and can't be hacked.

More SSO details

filing cabinet to illustrate users. https://unsplash.com/@jankolar
Wheat field image to make lame joke about grains. https://unsplash.com/@polina_art

Managing fine grain access

Dynamic query preparation uses the user's access groups to control the data shown. Protect PII and other sensitive data.

Only show the data relevant to a user's group.

Reports can be restricted to SSO groups.

Fine grain details

Scheduled Reports

Scheduling reports can be a mammoth task for IT departments. Requiring complex devops setup, database views and monitoring. Prophund Reporting allows a simple click and the schedule is established.

Scheduling details

Consolidating multiple servers

Prophund reporting supports results built from multiple database servers. Bringing together separate database systems. Oracle, Postgres, MySQL and others will be unified.

What is consolidating?

Providing drill downs

Allowing deep dives into presented data in traditional data reports has required extensive and expensive IT department programming. Leading to long deployment times. Prophund Reporting supports unlimited depth of drill downs using a simple click and select. Drill down setup.

Some auditing. Photo by Kelly Sikkema on unsplash.com

Auditing and tracking

Full tracking of each report use. Parameters used. Person and time. Tracking and approval of report changes.

Built in load balancing

Load balance your queries to any number of databases. Load balance your API to any number of databases. No programming or configuration required. Just add connections to add balancing. Dyanmic password rotation refesh means no more config headaches.

Balancing rocks. Photo by https://unsplash.com/@jeppemp4

Our Philosophy

"Databases, reporting and user management should be easy. Access needs to be quick. Timely data can create opportunities for wealth building and innovation."