Connecting to the Pulse Database

Pulse uses two databases to hold the information that is recorded during monitoring and the documentation process. As a Pulse customer you are free to browse these databases and extract data into your own tools (such as TM1) to analyse the information. A brief description of the content of the two databases is as follows:

docs.h2.db

  • Database Type: H2
  • Documentation: A catalog of all application, cubes, dimensions, processes, chores, views and subsets for each instance of TM1.
  • Cube Statistics: A full history of the size of cubes, number of feeders, etc for each cube daily and each time an attached rule was changed.
  • Change Tracking: A history of every change and whom it was changed by.
  • TM1 Web Tracking: Who used TM1 Web and what pages they used.
  • Excel Tracking: Who used TM1 enabled workbooks and a description of the workbooks.
  • Migration Packages: Information about each migration package and when it was executed.

Monitor.db

  • Database Type: SQLite
  • Sessions: Each time a user has logged into and out of TM1.
  • Flight Recorder: History of the key performance statistics for TM1: memory, CPU, disk space, start up time, concurrent usage, users waiting, etc.
  • Operation Log: Detailed information about each time an operation, normally a TI process or query, takes longer than 10 secs.
  • Process and Chore History: Summary information for how long a process or chore to takes run, errors, etc.
  • Settings: Settings, alerts, saved reports, etc.

 

Connecting VIA ODBC

To connect to either database via ODBC please see this article: Connecting to Pulse via ODBC

Connecting to docs.h2.db

There are a number of methods you can use to connect to the docs database that allows you to navigate the table structure and query the data. 

Console

The simplest method is to enable the Console in the Pulse.cfg file:

  1. Edit Pulse.cfg with a text editor. Default location is C:\Program Files\Pulse for TM1\conf\Pulse.cfg.
  2. Set ConsoleStart setting to true.
  3. Save the Pulse.cfg file.
  4. Restart the Pulse for TM1 Application Server service.
  5. On the server go to http://localhost:8090
    • JDBC URL: jdbc:h2:docs
    • Username: READER
    • Password: Copy from the Configuration page in Pulse.
DB Password.png

Connecting via JDBC

You can also connect to the docs database using any UI that supports the JDBC interface. The one that we recommend to use is DBeaver, it can be used to connect to either of the Pulse databases and is very user friendly.

  1. Edit Pulse.cfg with a text editor. Default location is C:\Program Files\Pulse for TM1\conf\Pulse.cfg.
  2. Set TcpStart setting to true.
  3. Save the Pulse.cfg file.
  4. Restart the Pulse for TM1 Application Server service.
  5. Download the DBeaver installer.
  6. Start DBeaver
  7. A "create new connection" wizard will start.
  8. Select from the Connection Type, H2 --> Server
  9. Confirm the download the H2 driver.
  10. Enter the connection settings:
    • Host: localhost
    • Port: 8092
    • Database/Schema: docs
    • Username: READER
    • Password: Copy from the Configuration page in Pulse.
  11. Click Test Connection.
  12. Click on Next.
  13. Click Next.
  14. Click Finish.
  15. Double click on H2 - docs in the Database Navigator.
  16. Go to the PUBLIC schema and open Tables.

 

Connecting to Monitor.db

The Monitor.db is a standalone DB file that can be connected to directly with any SQLite admin tool by simply opening the file.

Some example tools that can be used are:

Connect using DBeaver

  1. Open DBeaver. 
    • NOTE: If Pulse is stored in a directory that has restricted access you may have to start DBeaver with Administrative privileges. 
  2. Click on the New Connection button on the toolbar.
  3. Select the SQLite connection type.
  4. Click Next.
  5. Download the SQLite driver.
  6. Enter the connection settings
    • Path: (Default Location) C:\Program Files\Pulse for TM1\db\Monitor.db 
  7. Click Next.
  8. Click Finish.