Niagara - SystemDbService - Integration of controllers' databases in the Supervisor

The SystemDbService is used to integrate the MAC36NL or JACE 8000 controller database into the Supervisor's database. By performing this procedure, NEQL queries executed in the Supervisor station are also executed on the Niagara controller via a network connection and without the need to add all components in the NiagaraNetwork.

Before proceeding with the following steps, the Niagara controller (MAC36NL or JACE 8000) must be integrated in the Supervisor after the FOX protocol - under the NiagaraNetwork driver.

1. From the niagaraSystemIndex palette from the Typical configuration folder, add the SystemDbService component to the Config->Services location.

2. Then, in the added component in the System Database Type Selection slot, set the values of orientSystemDb as below and save the configuration, so that the status of the component will change from Fault to Ok:

3. The next step is to go to Config->Services->SystemDbService->SystemIndexService->NiagaraNetworkSystemIndexSource->GlobalNiagaraNetworkIndex.

There is the Default Index Queries slot, which contains the BQL queries that will be executed to the Niagara driver database. Only the items returned by these queries will be integrated into the Supervisor's database.

NOTE: Note that some of the queries exclude NiagaraNetwork - this is important to prevent recursive searches over the network!

To enter your custom query conditions, use the list of queries from the Custom Index Queries slot.

Then, invoke the database synchronization.

NOTE: Keep in mind that all queries are executed once a day by default, every day at 2:00 am. To manually perform the synchronization, click PPM on the Global Niagara Network Indexer component and invoke the Execute action.

4. (Optional) Go to Config->Services->SystemDbService->SystemIndexService->LocalSystemIndexer and change the status of the Enabled slot to true, save the changes and call the Execute action on the LocalSystemIndexer component. If the local station is not to be included in the database then this step can be skipped.

NOTE: Query configuration is done exactly the same as for the GlobalNiagaraNetworkIndex component described in section 3.

5. If a station of any Niagara controller or Supervisor station is pulled into the Supervisor database, it is possible to test the NEQL query to the database using the Quick Search field, specifying, for example, n:point. From each integrated empty station should appear 1 result, in the example below results from Supervisor station and one JACE 8000 controller were displayed:

NOTE: If point 4 is skipped and no Niagara controller is configured beforehand, the query will return an empty result.