Date printed: 12-19-2018   Last updated: 01-23-2008

To view our complete support knowledge base and most current version of this article visit

Applies to versions: 1.8, 1.9

ODBC Access

The TimeIPS® Database Read-Only Access Module allows setting a password to enable read-only access directly to the TimeIPS database. This allows users with database experience to write queries for external applications including custom reporting.


Security Level Required: Full Access or System Administrator

Using the left pane Main Menu, click on: Administration » System » System Settings


Master Configuration



  1. Type in a password in the "Limited Remote Database Password:" field

  2. Retype the password in the "Limited Remote Database Password (again):" field

  3. Click on the Update Database Configuration button

Database Access

To access the database, you will need an ODBC driver compatible with your operating system.

Visit the MySQL download page for compatible ODBC drivers for many operating systems.

After the ODBC driver is installed, configure it to communicate with your TimeIPS system's IP address and a database called "timecard." The location of the configuration varies by operating system.

As an example, in Windows XP, access ODBC settings by going to Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC). Click "Add" to add a new data source and select the MySQL 3.51 driver. Pick a name, like TimeIPS for the connection. Specify the IP address of your TimeIPS System in the Server field. The database name will be '"timecard" and you will use the username "readonly" and the password you configured.

After the ODBC connection is configured, you will need an application that can use ODBC to process queries and/or generate reports. There are many tools available. For example, the free office suite 2.0 includes a database component that can be used.

There are many database tables available in TimeIPS. The following list covers some of the main tables with the purpose of the table and notes on using it. The role of tables not listed here are beyond the scope of this document.

Table - Purpose

Please note that the tables sometimes change between versions and the way the data in the tables is used also sometimes changes. If you have critical reports pulling from these tables, we suggest verifying your reports after each TimeIPS upgrade.

©2004-2018 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.