When a source EHR utilizes both MySQL and ODBC to connect to its database, Datavant Site Connect can utilize the exiting ODBC connection to create an account for extracting data.
Note: Only Datavant Site Connect can perform the following installation. Please reach out to your CSM for details if you require this process to be performed.
Process
- Datavant Site Connect will install the Agent to establish a Heartbeat between HJ and the Server(s).
- Datavant Site Connect will point the Datavant Site Connect Agent to the EHR's existing ODBC Driver instead of the MySQL database. This process can be done post-installation as long as the ODBC driver name is communicated with Datavant Site Connect.
Example of an eCW ODBC Driver
- Once the agent is connected, Datavant Site Connect will run the following command to create credentials for the agent.
CREATE USER '<Healtjump Customer>'@'localhost'
IDENTIFIED BY 'replace with <lastpass generated password>'
- Once the credentials are created, Datavant Site Connect will point the agent to the EHRs database utilizing the new credentials.