Use a connector to set up a connection to a data source. A connector defines the type of connection and how to connect to the relevant data source. You can use a connector for both incoming and outgoing messages.
You can use these connector types:
Connector type |
Description |
D365 FO |
Directly connects to a D365 FO database. |
Database |
Connects to an external database via ODBC or to an external Azure SQL database. |
Staging journal |
Uses a staging table validate and approve data before it is imported into D365 FO. |
Azure file storage |
Exchanges data files using Azure file storage or Windows folders as file storage. |
Web service |
Exchanges data via a web service using a stream. |
Blob storage |
Exchanges data files using an Azure Blob storage. |
Upload and download |
Uploads or downloads a data file. |
SharePoint |
Exchanges data files using SharePoint as file storage. |
Service Bus queue |
Exchanges data using an Azure Service Bus queue or topic subscription. |
Example
If you want to export D365 FO data into a file, you need these connectors:
Name | Responsible | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Set up D365 FO connector |
Application Consultant |
Set up a connector of type D365 FO. Use this type to directly connect to a D365 FO database. |
||||||||||||||||||||||
Set up Staging journal connector |
Application Consultant |
Set up a connector of type Staging journal. Use this type to validate and approve data before it is imported into D365 FO. A staging journal scenario consists of:
|
||||||||||||||||||||||
Set up ODBC 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 also directly connect to an Azure SQL database. |
||||||||||||||||||||||
Set up Azure file storage connector |
Application Consultant |
Set up a connector of type Azure file storage. Use this type to exchange data files between your D365 FO environment (on-cloud or on-premises) and another environment, for example an on-premises environment. With the Azure file storage type connector, you can exchange these external file-based documents: EDI, Fixed text, Microsoft Word, Microsoft Excel, Text, XML, JSON. You can exchange data files using:
|
||||||||||||||||||||||
Set up Web service connector |
Application Consultant |
Set up a connector of type Web service. Use this type to exchange data via a web service using a stream. If you:
The related document defines which data is added to or taken from a stream and in which format and structure. So, the document does not result in a file. With the Web service type connector, you can use these external file-based documents: EDI, Fixed text, Text, XML, JSON. You can only use this connector in combination with a document for which the version 3 (V3) handler class is selected.
|
||||||||||||||||||||||
Set up Blob storage connector |
Application Consultant |
Set up a connector of type Blob storage to exchange data files between your D365 FO environment and another environment, using Azure Blob storage. Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. With the Blob storage type connector, you can exchange these external file-based documents: EDI, Fixed text, Microsoft Word, Microsoft Excel, Text, XML, JSON. |
||||||||||||||||||||||
Set up Upload and download connector |
Application Consultant |
Set up a connector of type Upload and download. Use this type to:
With the Upload and download type connector, you can upload or download these external file-based documents: EDI, Fixed text, Microsoft Word, Microsoft Excel, Text, XML, JSON. You can only use this connector in combination with a document for which the version 3 (V3) handler class is selected. |
||||||||||||||||||||||
Validate connectivity setup |
Application Consultant |
If you open a form or save (changes to) the setup of a key element in Connectivity studio, the setup is validated automatically. If errors are found in the setup, an error icon is shown. You can click the icon to show the related error messages. You can also manually start an automated test to check for errors in the setup. As a result, the found errors are shown. Also, the error icons are shown where applicable.
When errors are found, you can try to fix these errors automatically.
You can check and auto-fix errors for these key elements in Connectivity studio:
In this flow, in the activity steps, as an example, the validation is done for documents.
|
||||||||||||||||||||||
Set up SharePoint connector |
Application Consultant |
Set up a connector of type SharePoint to exchange data files between your D365 FO environment and another environment, using SharePoint. SharePoint is a solution to share and manage content, knowledge, and applications to empower teamwork, quickly find information, and seamlessly collaborate across the organization. With the SharePoint type connector, you can exchange these external file-based documents: EDI, Fixed text, Microsoft Word, Microsoft Excel, Text, XML, JSON. |
||||||||||||||||||||||
Set up Service Bus queue connector |
Application Consultant |
Set up a connector of type 'Service Bus queue' to exchange information via an Azure Service bus queue or topic. The 'Service Bus queue' connector supports these Service Bus entities:
For more information, refer to Service Bus queues, topics, and subscriptions. |