NowForce Database Schema

Symphia NowForce uses an MSSQL Server database to aggregate operational data. Analysis and visualization of the data using a third party BI system, provides operational insights.

NowForce supports any BI system that has the capability to connect to an SQL database and query data from a relational database, such as Grafana, Microsoft BI, Sisense, and Tableau.

Before you begin
  • The NowForce database uses MSSQL Server version 2019.
  • BI systems require a dedicated read-only user to access the database.
  • If the NowForce installation consists of a read-replica, we recommend that you connect the BI system to the read-only node.
  • The database schema is complex. We therefore recommend using a few professional services hours for an introduction to the system and an orientation to the database.
  • It is the customer's responsibility to make sure that the BI queries do not affect the system performance.
  • NowForce is not responsible for any malfunctions due to changes in the database schema, or any other configuration changes in the SQL Server.