OData – what happens with your Microsoft Dynamics integration when you need to upgrade to 365?
By Henning Lund - June 20, 2018
When you invest in a data integration system, you need to make sure that it is future-proof; what I mean is that it should be able to support your organization’s needs today and in the many years to come. For example, if you have integrated Salesforce with Microsoft Dynamics NAV or GP, you might be worried about the introduction of OData with Microsoft Dynamics 365. What will happen when you want to upgrade your system to 365? Well, if you are using the RapidiOnline integration solution, this should not cause you any problem.
What is OData?
• It lets developers interact with data by using RESTful web services. • It provides a simple and uniform way to share data in a discoverable manner. • It enables broad integration across products. • It enables integration by using the HTTP protocol stack.
Should you worry about moving to Microsoft Dynamics 365 when you have integrated your Dynamics solution (NAV, AX, or GP) with Salesforce? Well, if you are using RapidiOnline the future looks pretty good and you can expect your upgrade to go smoothly.
Simply, this is how it works within RapidiOnline: when we write to Microsoft Dynamics 365, we use Microsoft Dynamics 365 Web Services or OData. RapidiOnline supports both reading and writing of data (insert and update) using Odata. In on-premise environments (or hosted) we typically read data from the SQL database directly it's fast and RapidiOnline can make the required SQL queries; full-blown SQL filter syntax including Select In, JOINS. In Microsoft Dynamics 365 multi tenant environments often it's not allowed to access the database directly, and that is why we read data via OData instead.
You can read more about our Salesforce – Microsoft Dynamics 365 integration by downloading our solution overview (below) or you can get all the details about how we use OData in the Rapidi Wiki pages here.
With over 25 years’ experience in strategically propelling businesses forward, Henning is considered a business development entrepreneur with a passion for transforming businesses, sales and marketing operations through out-of-the-box thinking, concepts building and process automation to improve overall performance and scalability.