1. To-Increase Dynamics 365 for Finance & Operations
  2. Connectivity studio
  3. Flows

Set up Azure Service Bus for ODBC connection
Activity Flow

You can connect D365 FO 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 FO with Connectivity studio, these elements must be in place:
  1. Azure Service Bus namespace.
  2. BIS Azure Service Bus client installed on the external on-premises server.
  3. Data Source Name (DSN) on external on-premises server.
  4. Database connector and ODBC document in Connectivity studio on D365 FO.

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.):

Prerequisites to establish this connection:
  • Azure subscription.
  • D365 FO with Connectivity studio installed.
  • External on-premises server and database.

Application Consultant Application Consultant Start Start Create Azure Service Bus namespace Create Azure Service Bus namespace Create an Azure Service Bus namespace. For more information, refer to Create a Service Bus namespace using the Azure portal.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. Install on-premises Windows service - BIS Azure Service Bus Install on-premises Windows service - BIS Azure Service Bus Install the BIS Azure Service Bus as Windows service on the external on-premises server.To install the BIS Azure Service Bus, first download the BIS Azure Service Bus.zip file. Procedure 1. Open the on-premises server. 2. In 'C:\Program Files\', create a folder named 'BIS Azure Service Bus'. 3. Extract the 'BIS Azure Service Bus.zip' file and copy the files to the 'C:\Program Files\BIS Azure Service Bus' folder. 4. Open the 'BIS.Azure.ServiceBus.WindowsService.exe.config' file with a text editor and replace: [YOUR SERVICE BUS NAMESPACE] with the primary connection string of the Azure Service Bus namespace. Example: Your service bus endpoint is: "Endpoint=sb://myservicebusname.servicebus.windows.net". In this endpoint, the primary connection string is "myservicebusname". Use this to replace [YOUR SERVICE BUS NAMESPACE].[YOUR PRIMARY KEY] with the primary key of the Azure Service Bus namespace. 5. To install the BIS Azure Service Bus Windows service, run the 'installService.cmd' file from the Command Prompt. 6. Open Computer Management, in the navigation pane, click Services, and open 'Business Integration Solutions - Azure Service bus Connector'. 7. On the Log On tab, fill in a service account with access to the on-premises database and the relevant password. 8. Click OK Notes Errors and warnings for the BIS Azure Service Bus Windows service are logged in the Event Viewer > Windows Logs > Application event log of the on-premises server. Create on-premises Data Source Name (DSN) Create on-premises Data Source Name (DSN) 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 FO 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 FO server. Procedure 1. In Windows, open the Control Panel. 2. Click Administrative Tools. 3. Double-click ODBC Data Sources (64-bit). 4. On the System DSN tab, click Add, select the desired driver, and finish the relevant setup. End End

Activities

Name Responsible Description

Create Azure Service Bus namespace

Application Consultant

 		Create an Azure Service Bus namespace. For more information, refer to Create a Service Bus namespace using the Azure portal.
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.

Install on-premises Windows service - BIS Azure Service Bus

Application Consultant

 		Install the BIS Azure Service Bus as Windows service on the external on-premises server.
To install the BIS Azure Service Bus, first download the BIS Azure Service Bus.zip file.

Create on-premises Data Source Name (DSN)

Application Consultant

 		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 FO 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 FO server.

Activities

Name Responsible Description

Create Azure Service Bus namespace

Application Consultant

 		Create an Azure Service Bus namespace. For more information, refer to Create a Service Bus namespace using the Azure portal.
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.

Install on-premises Windows service - BIS Azure Service Bus

Application Consultant

 		Install the BIS Azure Service Bus as Windows service on the external on-premises server.
To install the BIS Azure Service Bus, first download the BIS Azure Service Bus.zip file.

Create on-premises Data Source Name (DSN)

Application Consultant

 		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 FO 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 FO server.
Related to Notes

Set up Database connector

 		 

Set up Azure Service Bus for ODBC connection

 		 

See also

Provide feedback