Skip to content


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


eOne Sessions at Directions North America 2023
Connect with eOne Solutions at Directions North America 2023!
Tech Tuesday: Creating a Summarize List by States Between Two Systems
eOne Sessions at Days of Knowledge UK - Live from Birmingham!
Employee Spotlight: Ally Tronson, Business Development Representative


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



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.