NexJ Logo

Turning on BI data synchronization

The reporting database is populated using the NexJ synchronization engine.

Before any user can use Ad Hoc Reports, a user with the BIWrite privilege must enable synchronization between the operational and reporting databases. Also, the reporting database needs to be activated and seeded with the data in the operational database.
After a target for the server is created, the real-time synchronization engine starts, so any new data or changes to existing data will be sent to the reporting database. However, the reporting database is not automatically populated with all of the existing data. To populate the database, you need to send a snapshot of the operational database to the reporting database.

If you make changes that affect the source data for BI synchronization in the existing database without using the model, you must perform a bulk BI synchronization of that data.

To enable BI data synchronization:

  1. In NexJ Admin Console, navigate to the Synchronization page.
  2. In the Targets area, select Outbound sync for 'BI'. Perform a full synchronization to all links or synchronize to selected links. If you are performing an initial setup, send a snapshot to all links.
    • To send a snapshot of all the links, click the Send snapshot to the external system (All links) button , located on top of the Targets area.
    • To send a snapshot of just one of the links, select the link in the Links area below the Targets area. Click the Send snapshot to the external system (Selected link only) button , located on top of the Links area. Repeat for other links if required.

Check the Audit Trail tab to see the synchronization events. After each link completes its task, information will appear in the Audit Log.

Disabling pool pausing

When performing a bulk sync, it is possible for an instance of a class to be created and synchronized within real time. However, when the bulk sync reaches this instance and attempts to create it, an SQL failure occurs because the bulk sync process is trying to duplicate existing data. To prevent this situation, pool pausing is used to pause real-time synchronization during a bulk sync. Pool pausing is enabled by default but can be disabled, if required.

Disabling pool pausing may produce unexpected results. Work with your NexJ service representative to ensure you are using this setting correctly.

To disable pool pausing:

  1. In NexJ Admin Console, navigate to the Synchronization page.
  2. In the Targets area, select the Outbound sync for 'BI' target. Properties of the target appear in the Details area.
  3. In the Details area, click the Edit button. The Edit Target Class dialog appears.
  4. Clear the Pause real-time synchronization while sending snapshot checkbox. Click OK.