Page History

...

1. 1. Go to Datasets on the MSPbots app menu and click the New Agent Dataset button. 
      

   2. When the New window appears, click Integration and select SQL Agent. Don't forget to fill in dataset Name and Description fields.

      
      
   3. Next, go to the Data Cleaning tab to show the Validate SQL section below. Select a database from the DB dropdown list. 

      The most common SQL statement to use here is “select * from TABLENAME”.

      
      
      
      
   4. Scroll down to the Validate SQL section, fill in the SQL field, and input your desired Sync Frequency in minutes.
      Sync Frequency is currently limited to 30 minutes and can only be decreased for smaller datasets. For larger datasets, the frequency may be limited due to a large amount of data ingestion and the constraint it would place on both your server and ours. 
      
      
   5. Click Confirm when done. This will show a preview of the data for your validation. You can customize or use the default character length for string-type fields, and the time field can be set with a timezone.
      Image RemovedImage Added
   6. Once you confirm the data is correct, click OK to create and save the dataset. The data will be synchronized in 10 minutes.

...