Description
Given the growing interest for translational research in the clinical community, it’s imperative to integrate disparate sources of patient data that are captured within the electronic health record system (EHR) and augmented by data captured during the research phase. In this system demonstration we provide an overview of a simple human friendly mechanism for integrating REDCap data with other data sources by developing a custom Tableau Data Web Connector(WDC). We go over the key technical system design ,data architecture and security features of this new system. We will demonstrate the multitude of use cases and the ease of use by combining with the new Tableau Ask Data feature available on version 2019.1.
Learning Objective: Appreciate the simplicity of single sign-on between REDCap APIs and Tableau Web Data Connectors
Ascertain the key design features needed for customizing your own in house REDCap - Tableau Web Data Connectors
Understand the critical security limitations of the existing REDCap API token based approach
Differentiate between the proposed approach and existing mechanisms for extracting data from REDCap project databases
Authors:
Alexander Tanchoco (Presenter)
Memorial Sloan Kettering Cancer Center
Olga Strachna (Presenter)
Memorial Sloan Kettering Cancer Center
Stuart Gardos, Memorial Sloan Kettering Cancer Center
Jonathan Wills, Memorial Sloan Kettering Cancer Center
Joseph Lengfellner, Memorial Sloan Kettering Cancer Center
Andrew Zarski, Memorial Sloan Kettering Cancer Center
Ilya Sher, Memorial Sloan Kettering Cancer Center
Mike Piscitelli, Memorial Sloan Kettering Cancer Center
Peter Stetson, Memorial Sloan Kettering Cancer Center
Cynthia Chu, Memorial Sloan Kettering Cancer Center
Presentation Materials: