Set up a connector of type Database. Use this type to directly connect to an external database. This external database can be an on-premises database or a cloud database.
If you want to connect to an external database via ODBC and you run D365 FO:
You can also directly connect to an Azure SQL database.
Name | Responsible | Description |
---|---|---|
Set up Azure Service Bus for ODBC connection |
Application Consultant |
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:
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:
|
Create Azure SQL database |
Application Consultant |
You can use a connector of type Database to connect to an Azure SQL database. For more information on Azure SQL databases, refer to Azure SQL Database. |
Set up Database connector |
Application Consultant |
Set up a connector of type Database. Use this type to directly connect to an external database. This external database can be an on-premises database or a cloud database. You can connect to an external database with an:
|