article Connecting to the up.time DataStore via ODBC

Related Documentation Version of up.time Affected Affected Platforms

All Windows

The default up.time DataStore uses a MySQL database although MS SQL and Oracle are also supported. The DataStore can be accessed 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 will be accessing the database. You can download the Windows ODBC driver from the MySQL web site. This driver enables the client system to communicate with the up.time 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 to access the database by following these steps:

  1. Browse to Administrator Tools in Windows and open ODBC Data Source Administrator.

  2. There are three types of ODBC Data Source Names (DSN): User, System and File. A User DSN can only be used by the user that created it; a System DSN can be used by any user on the system and File DSN just saves the settings to a file that can be shared across multiple systems. The following example creates a User DSN (leave the User DSN tab selected) so only our user can access it. Click the Add button as shown above to open the following dialog box:

  3. Select the MySQL ODBC 5.x Driver option and click Finish.

  4. Enter the settings in the Data Source Configuration dialog box (similar to the image above), replacing the hostname with the hostname of your up.time 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 up.time DataStore through a number of applications. For detailed information, please refer to your application documentation.

Related Articles

Connecting to the DataStore directly or from another tool


The up.time DataStore can be accessed via ODBC or using appropriate db connection utilities. Please find more information here:

By: uptime Support | Date Created: 12-31-2002 | Last Modified: 8-26-2011 | Index: 329


Creating Excel Reports that use up.time Data


This article explains how to access the up.time DataStore and use up.time data in Excel reports.

By: uptime Support | Date Created: 10-30-2007 | Last Modified: 6-19-2012 | Index: 222


Exporting and Importing Your DataStore or Configuration


This article explains the DataStore export and import utilities.

By: uptime Support | Date Created: 2-13-2007 | Last Modified: 12-19-2012 | Index: 140


Shrinking your MySQL DataStore


At times it may be necessary to reduce the disk space that your MySQL DataStore consumes on your monitoring station. The process of reducing your DataStore size follows the general steps that are...

By: uptime Support | Date Created: 7-31-2006 | Last Modified: 2-19-2014 | Index: 088


Migrating Your DataStore To a New Database


This article outlines how to move your DataStore between different database types.

By: uptime Support | Date Created: 2-21-2007 | Last Modified: 6-30-2011 | Index: 142


User Comments

No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement