The default Uptime Infrastructure Monitor datastore (up.time Data Store) uses a MySQL database although MS SQL and Oracle are also supported. You can access the datastore for custom reporting or data warehousing by using an ODBC connection with various tools such as MySQL Query Browser, Microsoft Excel, and Crystal Reports.
Before accessing the datastore, you must install the MySQL ODBC driver on the client system that accesses the database. You can download the Windows ODBC driver from the MySQL web site. This driver enables the client system to communicate with the UIM MySQL database. Note that the examples in this article are based on MySQL Connector / ODBC 5.1.8 using Windows 7.
After installing the MySQL ODBC driver, create a data source on the client system that you want to use to access the database.
To create a data source on your client system
- Browse to Administrator Tools in Windows, and then open ODBC Data Source Administrator.
There are three types of ODBC Data Source Names (DSN): User, System, and File. A User DSN is used only by the user who created it. Any user on the system can use a System DSN. A File DSN simply saves the settings to a file that you can share across multiple systems. The following example creates a User DSN (leave the User DSN tab selected) so only our user can access it. - Click Add as shown above to open the following dialog box:
- Select the MySQL ODBC 5.x Driver option, and then click Finish.
- Enter the settings in the Data Source Configuration dialog box (similar to the image above), replacing the Data Source Name with the hostname of your UIM server. The password for the reports user is "reports." Note that the reports user is a MySQL user with limited permissions that can only run queries from remote systems.
You should now be able to connect to the UIM DataStore through a number of applications. For detailed information, please refer to your application documentation.