extracting data from Epic EMR system
I'm looking to connect with a customer or gain some insight from any users that leverage Epic (Electronic Medical Record system) as a data source. I am trying to understand the best way to extract our data from Epic to SQL Server with an ETL process or push subsets of the data directly to Domo.
Any info will help - thank you!
Comments
-
I'm not very familiar with Epic to know if a simpler integration exists but it seems you could use Epic Clarity to get the data in a SQL Server database and then use Domo Workbench from there to get it to Domo. That way you don't have to try to develop some sort of Custom connector to Epic.
Epic Clarity
Because of the data return restriction put upon Epic Reporting Workbench and the need for longer reports, Epic uses a Clarity database. This database is a relational database and can either be an Oracle or Microsoft SQL database. It is housed on its own server and has no impact on day-to-day operations of the EPM.
It’s using Epic Clarity that you would run YTD or several years of data reports. Reports created using Clarity are referred to as “analytical reports,” and there is no restriction on the amount of data that can be returned. However, unlike Reporting Workbench, the data is all ways one day behind Chronicles.
This is due to a process called ETL — extract, transform, and load. This is a process that is run every night in which Chronicles data is extracted, transformed to fit the relational database, and then loaded into the database tables. Once the data is loaded, it can be used as the data source for a report. This is accomplished using a tool called SQL. SQL is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). These are your “select” and “from” statements and are called SQL script.
Once the SQL script has been created, it is used as the data source in a report-authoring tool such as Crystal Reports. Crystal gives the report its polished look.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive