Reminders for Connecting to MSPbots via API or SQL Agent

Connecting ConnectWise Automate, ConnectWise Manage, and Kaseya VSA to MSPbots is done via API or SQL Agent integration. Use either or both ways to connect your software and meet your integration requirements.

Before you choose how to integrate your PSA with MSPbots, here are some points for consideration. 

• API integration and on-premise SQL Agent integration have different dataset structures. The widgets and dashboards cannot be exchanged or migrated easily even if data is pulled from the same server. 
• You can also use the API dataset for on-premise servers for ConnectWise Manage, ConnectWise Automate, and Kaseya VSA. 
• API Integrations are more efficient because many of these, including Webhook API, use incremental synchronization where most data calculation is done in the cloud. The calculation for API integrations with MSPbots is done on the MSPbots server, minimizing work for your on-site server and significantly enhancing the speed and efficiency of complex calculations, especially those that require high processing power or involve large datasets. 
• MSPbots has more datasets, widgets, and templates for API than SQL datasets and widgets. This allows your software to interact seamlessly with MSPbots functions and features, enabling greater flexibility in connecting and exchanging data.
• SQL Agent (on-premise) integration should only be used in the following situations:
  • You are migrating from another software and want to keep everything unchanged for a smooth migration. 
  • You are an advanced SQL user developing new SQL-based datasets. MSPbots do not create new SQL datasets or widgets for clients due to unique database structures that require significant effort and may cause inefficiencies.
• If you choose to set up both API integration and SQL integration for the same server, an extra workload will be added to your server. Monitor your server's performance.