Page History

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

For ConnectWise Automate, manage, and Kaseya VSA, we need the dedicated Wiki and add the following notes there:

You can connect the software via API AND SQL agent, here are the pros and cons for the API dataset vs SQL dataset, sometimes, you might want to connect to both, but here are things that you should be aware:

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 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

...

• 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 the same for a smooth migration 
  • You are an

...

• • advanced SQL user

...

• • developing new SQL-based datasets. MSPbots

...

• • do not develop new SQL datasets or widgets for clients because doing so is inefficient and not beneficial to all MSPbots users.
• 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.