Smile Guide: Realtime Export (RTE)
I. What to Expect
🕘 Reading time = 1 hour
By the end of this guide, you’ll be able to understand what real time export is, how to set up a real time export module on Smile CDR and how to use it to export data to a remote RDBMS database.
The purpose of the Realtime Export (RTE) module is to permit real-time extraction of FHIR data from Smile CDR into a remote database. RTE is used to hydrate an external SQL schema of your choice or a shadow SQL database. RTE updates the SQL DB in real-time to reflect any changes within the FHIR repository (any FHIR creates, updates, deletes). This is most often used by customers who have reporting, BI, research or similar tools (e.g. Tableau, PowerBI, SPSS, etc...) that work with SQL tables but don’t (yet) work with FHIR data.
The intention of this document is to provide a step-by-step procedure of how to set up and use Smile CDR’s Realtime Export module. You should be able to successfully complete the setup with little to no technical background on Realtime Export (RTE).
The following items/knowledge are required:
Having Smile CDR installed. If not, see the following document on installing and configuring Smile CDR. You’ll need to have done so prior to beginning this tutorial.
Homebrew for MacOS
Postgres Database setup