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.
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.
Navigate to the data visualization software products website and follow the on screen instructions to download and install the applicable MySQL ODBC drivers.
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 should have received an e-mail from the Enterprise Health development team containing the following information needed for configuration:
- Port: 3306
- 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.