You can connect D365 F&SCM to an external on-premises database. If you connect to an external on-premises database, you must connect through firewalls. With Connectivity studio, you can connect to an external on-premises database using an Azure Service Bus.
To establish a connection between an external on-premises database and D365 F&SCM with Connectivity studio, these elements must be in place:
Azure Service Bus namespace.
BIS Azure Service Bus client installed on the external on-premises server.
Data Source Name (DSN) on external on-premises server.
Database connector and ODBC document in Connectivity studio on D365 F&SCM.
This picture gives an architectural overview of the Azure Service Bus solution in Connectivity studio with the required elements. (Note: The numbers in the picture correspond with the before-mentioned element numbers.):
Copy the Primary connection string and the Primary key of the namespace to a temporary location for later use. For more information, refer to Get the connection string.
Create a Data Source name (DSN) on the external on-premises server where you installed the BIS Azure Service Bus Windows service.
Note:
If you connect from D365 F&SCM on-premises to an external on-premises server, no Azure Service Bus is required. In this case, the Data Source Name (DSN) must be created on the D365 F&SCM server.