Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process



Real Time vs. Scheduler Based Integrations

Email | Print

Having read “Reasons for ERP and eCommerce Integration” and “ERP and eCommerce are Two Different Systems” I am sure you are convinced of the benefits of integration and at the same time appreciate the complexity of it. After realizing and identifying the need for integration for your business, how do you select a solution from the number of options available in the market?


Integration solutions can be broadly classified into two categories Real Time Integrations and Scheduler Based Integrations. In this article we will compare these two categories of integration and help you move one step closer toward your dream integration solution.


  • Real Time Integration – Real time integration is a process by which information gets synced between eCommerce and ERP systems (or any two systems) automatically, without any delay when the event happens.
  • Scheduler Based Integration – As the name suggests in a scheduler based integration, all the updates are accumulated and synced between the eCommerce and ERP systems at every scheduled interval. They are also known as batch updates.


But why is the method of integration a concern? And, how does one stack up against the other?


Why is the method of Integration a concern?

While the end result in both methods is availability of the same information in both ERP and ecommerce systems, the way the information is synced, when it is synced and how it is synced can be critical for businesses. For example, scheduler based integration runs every scheduled interval but for some businesses it might be critical to have this information available in the other system immediately. In that scenario a scheduler based integration might not be very useful for the business.


Real Time vs. Scheduler Based Integrations

In the table below we briefly compare the two methods of integration but before we proceed there it is important to understand that based on the business requirement the same feature might act as a benefit for one business and a drawback for another.

Screen Shot 2014-10-17 at 9.47.00 AM

Bottom line, Real time integration is ideal for businesses that require

  • Real time updates
  • Customization
  • Enhanced data security

and Scheduler based integration is ideal for businesses that require

  • Out of the box integration features,
  • Integrating multiple systems to multiple systems


For more information on scenarios when real time integration is better than scheduler based integration read our ebook Real Time vs. Scheduler Based Integrations and blog Is Real-Time Processing Better than Batch Processing?


by i95Dev – Partner for your Ecommerce and Microsoft Dynamics Integration Needs.


Comments are closed.