Last modified on: 08 May 2020
Microsoft Dynamics 365 is a cloud-based business applications platform that combines components of customer relationship management (CRM) and enterprise resource planning (ERP). It was launched in 2016, when Microsoft combined Dynamics AX (its ERP application) with its Dynamics CRM application.
Dynamics 365 removes the divide between traditional ERP and CRM functionality into a unified, multi-functional application with specific business processes designed for Sales, Marketing, Finance, Customer Service, Field Service, Operations, Project management and more for all the roles and business units across your business.
As this results in a very large amount of data, menus, views… that will be a hard work to port all of them to Denodo. To make this process more friendly, we distribute this utility. Spending only a few minutes configuring one properties file and your Denodo installation with the needed tools, you’ll be able to access to your Dynamics 365 Customer Engagement data.
Importing the Dynamics 365 customer engagement VQL templates will grant you the access to the following functionalities:
For each one of the mentioned views, there will be a simplified one (only shows the fields already shown in the Dynamics 365 web interface) and a full one (shows all the fields of the entity).
In the Configuration section you’ll find how to generate your own Dynamics 365 VQL templates.
In order to get the parameters needed to authenticate to Dynamics 365, you need to follow these steps:
Now, you have all the data needed for the OAuth 2.0 Credentials wizard in Denodo:
Once you have filled all the inputs fields of the step one of this wizard, just click Generate the authorization URL and a URL will be displayed just below the link. Open it in a browser and you will see something like this:
Finally, you have to copy that code and paste it in the step 3 of the wizard and click in Obtain the OAuth 2.0 credentials. You can copy the credentials to the clipboard as you will need to use them later on the configuration process.
Before importing the VQL templates in Denodo, you have to set the following parameters defined in the dynamics_365_CE.properties file:
Note: Make sure you leave an empty line at the end of the properties file.
There is one last thing to do before importing the VQL templates into Denodo. The templates will create an OData data source so, if you don’t have this custom wrapper imported in your Denodo installation, now you’ll have to do it.
Navigate to the Denodo Support Site (https://support.denodo.com/) and go through Downloads → DenodoConnects and you will see a list of the available connects. Select the tab that matches your Denodo installation version, look for Denodo OData 4 Custom Wrapper and click in the Download link. Note that you need to install the 20180903 version or higher.
Your browser will download a zip file. You must open it and extract denodo-odata4-wrapper-<denodo_version>-<version>-jar-with-dependencies.jar, located in the dist folder.
For each one of the mentioned views
The last step is importing this jar file into Denodo:
Once you have completed all the previous steps of this configuration section, you finally can load the dynamics_365_CE.vql file into Denodo. You only have to import it using the Import option of the VDP Administration Tool, including also dynamics_365_CE.properties:
After the importation process finishes, refresh the Server Explorer by selecting File → Refresh and you will be able to see the data source and base views for accessing to Dynamics 365 Customer Engagement:
Dynamics 365 base views
Now, you can execute queries over the Dynamics 365 Customer Engagement base views that have been created.
If you use Denodo 6 you need to have installed the update 20180206 or higher versions.
Both Denodo 6 and 7 need to use 20180903 version or higher of the OData4 Custom Wrapper.