Page History

...

• 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 even 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 SQL API than SQL datasets and Widgetswidgets. This allows your software to interact seamlessly with MSPbots functions and features, enabling greater flexibility in connecting and exchanging data.
• SQL Agent (Onon-premise) integration should only be used in the following situations:
  • You are migrating from another software and want to keep everything the same unchanged for a smooth migration migration. 
  • You are an advanced SQL user developing new SQL-based datasets. MSPbots do not develop create new SQL datasets or widgets for clients because doing so is inefficient and not beneficial to all MSPbots usersdue 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. 

...