Background information
You can set a primary Id in the Dataset, so MSPbots can identify the uniqueness of data based on this primary Id. Then, according to the update frequency you set, MSPbots will timely locate and update only the changed data, rather than deleting all data and resynchronizing, as there is no data in the dataset during this time.
This approach can save a considerable amount of time and resources, while reducing the complexity of data processing. By updating only the changed data on a scheduled basis, you can maintain the data's latest state, ensuring the consistency and accuracy of the system's data.
How to set a primary Id
- Log in to MSPbots and go to Datasets.
- Search for the dataset you want to edit.
- Click More options and choose Edit.
- Click Data Cleaning.
- Fill in the following fields:
- Select a database as the DB, for example, sqlagent.
- Input SQL commands that can be used to query the data to be set as the ID.
- Enter the appropriate frequency for syncing data in Sync Frequency (Mins).
It is generally recommended to set it to at least 30 minutes.
- Click Confirm.
- Click the Set As Id button in the row where you want to set the primary Id field.
Only fields with unique data values can be set as Id.
- Once the setup is completed, a label will appear in front of the primary Id field that has been selected.
- If you want to change the primary Id field, click Remove As Id, and then reset the primary Id.
- If you want to change the primary Id field, click Remove As Id, and then reset the primary Id.