Notifications
Clear all
Topic starter
Does anyone have any experience or contacts for extracting data from the EMR to a data warehouse for reporting purposes?
Specifically we would like to know if someone could refer a contractor experienced with creating an ETL extract from the Centricity EMR Oracle Database to a Microsoft SQL based data warehouse.
Thank you in advance!
Kimberly L. Waddell, M.Ed
Centricity Build/Support Lead
Posted : June 7, 2013 3:51 am
We do that same extract on a nightly basis for selected tables. I installed the Oracle OLE drivers from Oracle's website which run much, much, much quicker than the standard ODBC.
I didn't personally create the Microsoft piece (I've only seen the clicks by one of our MS developers) but you can certainly do it by creating a project through Visual Studio.
Jim Eppright
Posted : July 10, 2013 1:36 am
