Page History

You can integrate e-automate with MSPbots by adding a connector for the SQL Server or MSQL. Only users with editing privileges for integrations can link e-automate On-Premise with MSPbots. Ensure that you have admin rights before performing the integration steps below. 

Prerequisites

• Before configuring E-Automate On-Premise Integration, you need to have already connected the MSPbots SQL Agent client.
  • If you have already connected the MSPbots SQL Agent client, please proceed with the following steps.
    Image Added 
  • If you have not connected yet, please refer to "SQL Agent Integration Setup#ConnecttheMSPbotsagent" to connect the MSPbots SQL Agent client.

How to connect e-automate On-Premise

1. Navigate to Integrations on the MSPbots app. 
   
   
2. Search for e-automate On-Premise and click it to open the connection settings. 
   
   
3. Click the +Add Connector button.
   
   
4. Fill in all of the following required fields.
   • Database Type - Select either SQL Server or MySQL.
   • Agent - The agent will be populated automatically with the name of the installed machine.
   • IP - Provide the internal IP address or FQDN of the SQL or MySQL server.
   • Database Name
   • Time Zone - Select the time zone used by the connected database.
   • User ID - This is the username of the user with read-only access to the database.
   • Password - This is the password of the user with read-only access to the database.
           

     Note
     It may take a few moments for the agent to check in after installation.  If you have installed multiple MSPbots agents with different databases in different network segments, you have to select the device name where you manually installed the MSPbots Agent. You can find the device name in the Agent selection box. Select the one under the corresponding gateway of the database.

                                                                                                           
5. Click Save And Sync.

...