When a source EHR utilizes both MySQL and ODBC to connect to its database, Healthjump can utilize the exiting ODBC connection to create an account for extracting data.
Note: Only Healthjump can perform the following installation. Please reach out to your CSM for details if you require this process to be performed.
- Healthjump will install the Agent to establish a Heartbeat between HJ and the Server(s).
- Healthjump will point the Healthjump 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 Healthjump.
Example of an eCW ODBC Driver
- Once the agent is connected, Healthjump 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, Healthjump will point the agent to the EHRs database utilizing the new credentials.