A Guide to Integrating Cloud-Based Applications – Part 2

Last week we discussed the shift to cloud-based applications among business and the various ways those businesses are connecting to their data in the cloud. Today, I’ll give you my recommendations when you are looking at integrating data to or from cloud applications.

Five Recommendations for Integrating Cloud-Based Apps:

  1. Evaluate your best option. First look to see if there is built-in integration available at little to no charge, after that find a middleware tool and lastly, move to custom development. (Why did I skip the manual approach? The purpose is to automate not do more work!)
  2. Determine where home base is for the data. Which system owns the record? Does the integration need to only go one direction? Are there other systems that need the same information? I find it works best to keep the process as simple as possible and keep one system as the master and have other systems only receive the latest data.
  3. Be careful with duplicating the data in all systems. What if you have 50 million records? Do you want that duplicated in both systems? Ensure that a valid business reason exists to push the information between cloud apps and other systems. There are other options sometimes that can aggregate the data from multiple systems (reporting tools like PowerBI or Popdock.com) and that can be a better option for some applications.
  4. Define internal processes before picking an approach. Make sure you gather the requirements and involve members from cross functional teams to get feedback before you start the process. Also, document the process for the people that follow so they can understand the business justification for taking the approach that was recommended.
  5. Finally, prepare for errors. There will be times when the internet is down, setup information is missing from one system or the other, and legitimately incorrect data made it in that must be addressed. Have a process in place to fix data and resubmit.


Options are available for businesses today along the spectrum of no-code, low-code and developer built solutions.  Before you decide on the best approach for your organization, make sure you have a strategy in place that covers the real possibility of people that know your process leaving your organization and taking all of that knowledge with them.

Good luck on your projects integrating cloud apps to other systems and may you all be able to go home at a decent time each day!

Didn’t catch Part 1 of this 2 part series? Read it here


Leave a Comment


Tech Tuesday: Useful Javascript Commands
SmartConnect Office Hours Recap for Feb. 15th, 2019
A Customer Story: Extender Saves 140 Hours a Week
SmartConnect Sales Journal Template for Business Central
Join Our Q1-2019 Partner Call! Important Changes Coming!


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps



open all | close all


CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartPost SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.