This article provides the following step-by-step guide for establishing the connection of ConnectWise Automate On-Premise to MSPbots.
Ensure you have a new read-only account in your SQL Server or MySQL for communicating with MSPbots. You can refer to the article How to Create a Read-only Account for Your SQL Server or MySQL for guidance.
Use this integration setup option only if you are an advanced user with knowledge of SQL databases and scripts. For more information on connecting your software to MSPbots using API or SQL agent, refer to Reminders for Connecting to MSPbots via API or SQL Agent. |
The last success auth shows the last time when the MSPbots Agent successfully pulled the database configuration information. This process is set to occur every 5 minutes by default. |
It may take a few moments for the agent to check in after installation. |
When the New window appears, click Integration and select ConnectWise Automate On-Premise. Don't forget to fill in the dataset Name and Description fields.
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 constraints it would place on both your server and ours. |