Page History

...

Before accessing the datastore, you must install the MySQL ODBC driver on the client system that will be accessing accesses the database. You can download the Windows ODBC driver from the MySQL the MySQL web site. This driver enables the client system to communicate with the Uptime Infrastructure Monitor 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 will be used you want to use to access the database by following these steps:.

To create a data source on your client system

1. Browse to Administrator Tools in Windows, and then open ODBC Data Source Administrator.
   Image Modified
   There are three types of ODBC Data Source Names (DSN): User, System, and File. A User DSN

...

1. is used only by the user who created it

...

1. . Any user on the system

...

1. can use a System DSN. A File DSN simply saves the settings to a file that you can

...

1. share across

...

1. multiple systems. The following example creates a User DSN (leave the User DSN tab selected) so only our user can access it. 
2. Click

...

1. Add

...

1. as shown above to open the following dialog box:
   Image Modified
2. Select the MySQL ODBC 5.x Driver option, and then click Finish.
   Image Modified
3. Enter the settings in the Data Source Configuration dialog box (similar to the image above), replacing the

...

1. Data Source Name with the hostname of your

...

1. 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 Uptime Infrastructure Monitor datastore UIM DataStore through a number of applications. For detailed information, please refer to your application documentation.