OData – what happens with your Microsoft Dynamics integration when you need to upgrade to 365?

By Henning Lund - October 13, 2020

Want to try RapidiOnline?

Integrate any Salesforce and Microsoft Dynamics systems fast


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?

OData (Open Data Protocol) is a standard protocol for creating and consuming data. The purpose of OData is to provide a protocol that is based on Representational State Transfer (REST) for create, read, update, and delete (CRUD) operations. OData applies web technologies such as HTTP and JavaScript Object Notation (JSON) to provide access to information from various programs. Microsoft initiated OData in 2007 so it is not surprising that is it become an important part of their newly released 365 solution. OData is an interesting way to integrate as it provides the following benefits:
•         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.

Read also: Is your data integration future-proof?


Should you worry about your integration?

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.


Read also: Integrate Salesforce with Microsoft Dynamics 365

Read also: The future of Microsoft Dynamics integration


About the author

Henning Lund

Picture of
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.
INTEGRATE Salesforce and Microsoft Dynamics 365 - FAST and EASILY. Read more now
   CUSTOMER SUCCESS STORY: Alimed  Position yourself for FUTURE SUCCESS: smoothly INTEGRATE Salesforce and  Microsoft Dynamics AX. Read the full story
THE RAPIDI TECHNOLOGY  At Rapidi, we make data integration and replication easier, faster, and more  secure.  Why the Rapidi technology is different:   * No programming needed.   * Easy to implement and simple to use.   * Robust and yet flexible.   * Our RapidiConnector encrypts data to keep your data safe.    * Scalable to fit your needs as you grow.   * Can be used out-of the box or customized to fit your needs.   * Top-rated support. 

Data Integration Handbook

Your business is 10 steps away from perfectly integrated data systems. Learn about key preparation, best practise and more in our data integration handbook.