Versions Compared

Key

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

This guide will help you do the following so you can successfully connect steps for connecting the SQL agent to MSPbots:  

Table of Contents
stylenone

...

1. Verify if you are using a previous version of SQL Agent.

If you have SQL Agent 3.0 installed, proceed to Step 2. If an older version is installed, uninstall it first with the following steps:  

    1. Go to the Agent installation directory. 
    2. Find the unins000.exe uninstall file and run it. 
      uninstall SQL AgentImage Modified 

2. Download and install SQL Agent 3.0.

    1. Go to Integrations on the MSPbots app menu. 
    2. Find the SQL Agent and click the Config icon.
      SQL agent configImage Modified
    3. Next, click the download icon for the MSPbots SQL Agent Client to start downloading the installer file.
      download sql agentImage Modified
    4. Locate and double-click on the downloaded installer.
    5. During the setup, select Automatic start and Create a desktop shortcut, then click Next
      sql setupImage Modified
    6. Follow the prompts. In the last step, tick the Launch MSPbotsAgentService checkbox and click Finish. The window will automatically close when the service starts.

      complete sql setupImage Modified 

3. Set up the MSPbots Agent Client.

    1. Open the Agent client by double-clicking on the shortcut you created in Step 2e above. 
    2. Log in using your MSPbots account. You can Minimize or Close the window after login but do not log out. 
      login agent clientImage Modified
    3. Go back to Integrations and click the Add Connector button.
      add connectorImage Modified
    4. Scroll down to the SQL Server section and select a Database type.
      sql server database configImage Modified 
    5. Configure the following database information:
      For SQL Server 
      The Database IP information configuration rules are:
      Default instance + Default port (1433): IP
      Default instance + Custom port: IP,XXXX
      Default instance + Custom port: IP\ Instance Name,XXXX 
      For My SQL
      The Database uses the default port (3306): IP 
      The Database uses a custom port number: IP;port=XXXX 

      sql db ip settingsImage Modified
    6. After the configuration is complete, click Save And Sync
    7. Refresh your browser. 

4. Create a dataset and validate the data.

    1. Go to Datasets on the MSPbots app menu and click the New SQL Agent Dataset button. 
      new sql datasetImage Modified
    2. When the New window appears, fill in the dataset Name and Description fields.
      dataset name and descriptionImage Modified
    3. Next, go to the Data Cleaning tab to show the Validate SQL section below. Select a database from the DB dropdown list. 
      DB name and sync frequencyImage Modified
    4. Scroll down to the Validate SQL section, fill in the SQL field, and input your desired Sync Frequency in minutes.
    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.
      validate dataset previewImage Modified
    6. Once you confirm the data is correct, click OK to create and save the dataset. The data will be synchronized in 10 minutes.