ODBC Install & Configuration
Covered by this topic
As an add-on feature, some clients may choose to implement ODBC (Open Database Connectivity). ODBC access allows customers to access and datamine their Enterprise Health database tables. Clients familiar with MySQL, can create their own custom reports using 3rd party report data visualization software products.
3rd Party Tools
There are several data visualization software products that clients can utilize with an Enterprise Health ODBC connection. Examples of recommended products include Tableau, Power BI/Power Query and Informatica.
Installation of the MySQL ODBC Driver
Navigate to the data visualization software products website and follow the on screen instructions to download and install the applicable MySQL ODBC drivers.
ODBC Data Source Configuration
Once the drivers have been downloaded and installed, users will need to set up a connection and set up the data source. Your Enterprise Health deployment consultant or support contact will work with our development team to send you additional information for this step of the installation process.
- You may download the Enterprise Health CA (Certificate Authority) from here: Med-Web SSL CA2
- You should have received an e-mail from the
Enterprise Health
development team containing the following information needed for configuration:
- Hostname
- Port: 3306
- Username
- Password
- SSL Key
- SSL Cert
- SSL CA
- SSL Cipher
Instructions on connecting and setting up the data source will vary depending on the 3rd party report data visualization software utilized. If you are having trouble connecting via ODBC, your Enterprise Health deployment consultant or support contact will facilitate a meeting with the Enterprise Health database administrator.
Enterprise Health Documentation
Last Updated:
Last Build:
Wed, 09 Oct 2024 23:08:26 UTC
WikiGDrive Version: 2aacb51f060d0354a678419290943a99bd16aad1