Connecting to the Pulse Databases through an ODBC driver

This article will guide the Pulse Administrator to configure ODBC connections to the Pulse Databases.

The reader of this article should be familiar with the Pulse terminology and should have a moderate knowledge of how to configure ODBC connections in a Windows PC or Server.

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. Since v5.6 you can migrate your Pulse data from h2 to a MS SQL Server.

If you would like to extract information from Pulse using SQL queries you can access information that is not available in the user interface. Accessing the Pulse database can be achieved through an ODBC driver.

docs.h2.db: A H2 database that stores all of the documentation, TM1Web usage and Excel usage.

Before configuring the ODBC connections the Pg (Postgresql) interface must be enabled:

1. Open confPulse.cfg in the Pulse install directory with Notepad or your favourite text editor
2. Find the database section of the config file
3. Set PgStart setting to true as highlighted below
4. If you want to be able to access the database from other computers enable PgRemoteAllowed by setting its value to true
5. Save the file
6. Restart the Pulse for TM1 Application Server service in the Services Control Panel

[Database]

ConsoleStart = false
ConsoleRemoteAllowed = false
ConsolePort = 8090
PgStart = true
PgRemoteAllowed = false
PgPort = 8091
TcpStart = false
TcpRemoteAllowed = false
TcpPort = 8092

To access the databases via ODBC you need to download the following drivers drivers: Postgresql

1. Go to Administrative Tools -> Data Sources (ODBC)
2. Click on the System DSN tab
3. Click Add
4. Select PostgreSQL Unicode(x64)
5. Click Finish
6. Enter in the Data Source Name: Pulse Docs
7. Set the Database to docs;DATABASE_TO_UPPER=false;
8. Set the Server to localhost or the name of the server
9. Set Port to 8091
10. Set User Name to reader
11. Set Password, to retrieve the password, go to the Pulse Web Client and under Administration/Configuration, copy the password from the settings, as shown below

  12. Click on OK