Versions Compared

Old Version 3

changes.mady.by.user Shindie Linatoc

Saved on

compared with

New Version 4

changes.mady.by.user Shindie Linatoc

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open SQL Server Management.
  2. Download the Microsoft SQL Server Agent configuration file from Integrations to the SQL Server Management computer.
    download sql donfig file
  3. Decompress the compressed package and open the appsettings file.
    app settings file

  4. Go back to the MSPbots app. Copy the Secret string from the Microsoft SQL Server Agent to the Secret location in the configuration file and save it.
    app secret string
    sql secret location

  5. On the MSPbots app, expand the testcase section and configure the database information on the MSPbots app. 
    1. Indicate the IP address of the server where the SQL server is located. 
    2. Provide the Database Name. 
    3. Enter the User ID of the one database login account.
    4. Enter the one database login Password.
      sql agent config
  6. Click Save And Sync. 

  7. On the SQL Server Agent server, open the downloaded configuration file. Find the AgentService program and run it.

    agentservice program 

  8. On the MSPbots app, go to Datasets and click the New button to create a dataset. 
  9. Configure the fields to be queried in Database Source and the table name in the SQL Server to be queried:
    1. Use select username and password from sys_user for the SQL field.
    2. Select the Database Name configured on the Integration section (Refer to step 5) and indicate the Sync Frequency (calculated in minutes).
      edit database 
  10. Click Update and save the Dataset.

  11. At this point, the SQL Agent configuration is completed, and the data will be pulled into the tenant_agent_data table according to the set synchronization time.

...