Database Reporting and Data Extraction

Fivebase has a wealth of experience extracting, mining and sharing data from several systems using several tools and technologies.

At the core of many of the Fivebase projects usually lies a database. As a result, Fivebase has a wealth of experience extracting, mining and sharing data from several systems using several tools and technologies. Samples of services we can provide include:

  • Adhoc / Raw SQL query assistance
  • myAvatar widget and SQL view definitions
  • Data exports - flat file, webservices, xml, JSON odbc, proprietary formats, etc
  • End user report generation
  • Legacy EHR Archive viewers
  • Crystal Reports Training and Design
  • MS SQL Server warehousing including SSIS and SSRS solutions.

Samples of the databases we have worked with include:

  • MySQL, Postgre, Oracle, MS SQL Server and Intersystems Cache
  • Most ODBC / JDBC accessible data stores and files such as the Netsmart myAvatar product

A sample of the tools we have used and work with include:

  • SSRS / SSIS
  • Crystal Reports
  • SAP Crystal Server and Recrystallize Server
  • Power BI
  • Tableau
  • Custom coded reports (e.g., PHP, C SHARP, ASPX, VB)

Samples of the systems we design extracts and reports for include:

  • Cantata Health Arize EHR
  • Netsmart myAvatar, myEvolv EHR
  • Nextgen
  • Foothold Awards
  • Salesforce.com

Click here for additional EHR / EMR design and consulting services.