Epic is an Electronic Medical Record system used by more than 60% of Healthcare providers in the US. The main database for Epic is Intersystems Cachè. Cachè is a document-oriented database like NoSQL, Couch or Mongo. As part of the Epic install a SQL Server or Oracle database (based on the client’s choice known as Clarity database) is set up for reporting and querying. This Clarity database is housed on its own server and does not have any impact on day-to-day operations of the EMR. You can query Cachè, but it is very slow and can't handle reporting types of queries (many joins with filtering returning many rows of data). Epic has nightly backups (that the client sets up) that copy data out of Epic Cachè database into the Clarity database (either SQL Server or Oracle DB) where you can create views or run queries.
For Epic Clarity users running Oracle, Epic has a requirement that their clients have Oracle 12c certified support. Famsoft can provide that support at a fraction of the cost that it takes for Epic customers to hire and retain the 12c certified resources. Likewise, we provide SQL Server support to Epic customers at a cost lower than the cost to retain certified SQL Server resources.
As part of database support for Epic customers, Famsoft offers 24x7 managed database support, and upgrades, tuning and patching as needed.
Famsoft has many years of experience in providing our customers services and solutions specific to their business needs utilizing the following technologies:
"Throughout the course of the various engagements that ran in parallel, we found the Famsoft teams to be highly skilled, dependable, motivated and willing to assist with any task. I would highly recommend them for any database, applications and training development as well as delivery work."Manette Chadwick, Sr. Manager, Systems Instructional Design and Development, Sun Microsystems
"UNIX and Oracle support and administration no longer require the weekly meetings and constant reprioritization and negotiation of support associated with past providers. This has provided the gift of time, freeing up Marshfield DoorSystems resources to work on value added activities by spending less time coordinating utility services. I would highly recommend FamSoft services to anyone considering a movement into managed services."Dave Bredendick, IT Manager, Marshfield DoorSystems
"Famsoft has a team of resourceful, creative and solution-oriented team that worked diligently during the term of the engagement. The team’s working attitude and quick problem solving approach were worth applauding. I strongly recommend Famsoft for any Oracle database migration project."Mike Osier, VP, IT Operations, Netflix
Famsoft provides companies across all industries with complete "turn-key" services and solutions to meet their business requirements.