Microsoft introduced a new feature called Virtual Entity which will help you access data residing in an external system via OData 4.0 API. You can build your own OData API for your database, plug it in to Dynamics 365 to access your data which would take significant development, maintenance and testing efforts. With Progress Hybrid Data Pipeline, you get an out of the box solution which will help you create an OData 4.0 endpoint, which you can configure as Virtual entity and access your data. In this tutorial, we will walk you through how you can use the virtual entity feature by showing how you can access SQL Server data using OData API generated by Progress Hybrid Data Pipeline.
Follow the below tutorials on how to install Progress Hybrid Data Pipeline in Azure or AWS
Important: Make sure you redirect traffic on 80 ports on your machine to port 8080 of HDP server using a proxy or firewall rules. This is important, as Dynamics CRM will not work if your endpoint URL has a port in it.
Enabling On-Premise Connectivity (if applicable)
If your database is behind a corporate firewall or in a private network, you can use our On-Premises connector which will enable a secure connection to your database for Hybrid Data Pipeline Server, without having to open any ports in your firewall. To get started, you would need to install this On-Premises Connector on your on-premise infrastructure as the name suggests. Follow the below tutorial on how to install the On-Premises Connector.
If Hybrid Data Pipeline Server is on AWS
If Hybrid Data Pipeline Server is on Azure
The URL might be of following format : https://server_name:8443/api/odata4/SQLServer/ , but you should be able to access it via https://server_name/api/odata4/SQLServer (if SSL enabled) or http://server_name/api/odata4/SQLServer as you have redirected traffic.
We hope this tutorial helped you in accessing your external data in SQL Server or on-premises database from Dynamics CRM. Feel free to try Progress Hybrid Data Pipeline and let us know if you have questions or issues.