Connecting to the Pulse Database

Since Pulse v5.6, Pulse uses only one h2 database by default, to access the data you just need to connect to the docs.h2.db. Instead of the h2 database, since v5.6 you can migrate your Pulse data to a MS SQL Server.

• 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.

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

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. 

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 FilesPulse for TM1confPulse.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.

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 FilesPulse for TM1confPulse.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.