SQL server database for Pulse

#1

We’ve got two questions from a Pulse client that switched to SQL server. Could you please assist?

  1. How Pulse will behave in case of :
    a. SQL database server overload (for example, in case of operating system update or other updates on the server)?
    b. losing network connection with SQL server?
  2. Is it possible to get Flow Chart information in SQL database somehow (they want to use it in Power BI to build their own charts)?

Thanks!

#2

Hi @ssarvartdinova,

When you configure Pulse to use SQL Server, Pulse will migrate data from its current local database to the new database in SQL server. Pulse will then only use the database in SQL Server. Having access to SQL server is critical for Pulse, If Pulse looses connection to SQL Server for whatever reasons (operating system update, losing connection with SQL Server…), Pulse will stop working.

I hope this help.

Cheers,

Vincent

#3

Hi @ssarvartdinova,

The Relation table has a summary of relationships between TM1 objects.

#4

@Vincent @tryan Thank you!
One more question:
Is there any definition of data model / list and description of tables of Pulse database?

#5

Hi @ssarvartdinova,

There isn’t a diagram available to share but if you have any specific questions please ask on the forum.

What are you trying to achieve? If you are interested by specific data, we can tell you which table you should look at.

Cheers,

Vincent