Dynamics 365 Business Central Connector Setup

Version 21.0.8222


Dynamics 365 Business Central Connector Setup


The Dynamics 365 Business Central connector allows you to integrate Dynamics 365 Business Central into your data flow by pushing or pulling data from Dynamics 365 Business Central. Follow the steps below to connect ArcESB to Dynamics 365 Business Central.

Establish a Connection

To allow ArcESB to use data from Dynamics 365 Business Central, you must first establish a connection using OAuth login. You can create the connection from either the connector configuration pane or the Connections tab of the Settings page.

Note:

  • The login process is only required the first time the connection is created.
  • Connections to Dynamics 365 Business Central can be re-used across multiple Dynamics 365 Business Central connectors.

From the Connector Configuration Pane

  1. Drag the Dynamics 365 Business Central connector into an ArcESB flow and give it a name.

  2. In the Connector Configuration pane, click + Create next to the Connection drop-down list.

  3. The Add Connection modal appears. Enter a name for the connection.

  4. The default Organization URL is correct for most users. However, if the default value does not match your configuration, enter the correct Organization URL.

  5. Enter your Company.

  6. Select your Auth Scheme from the drop-down menu.

  7. Click Connect.

  8. A new window opens for logging into Dynamics 365 Business Central. Enter your credentials and log in.

  9. If prompted, grant permissions for ArcESB to connect to Dynamics 365 Business Central. You will then return to ArcESB.

  10. Click Add Connection to finalize the connection.

  11. In the Connection drop-down list of the connector configuration pane, select the newly-created connection.

  12. Click Save Changes.

From the Settings Page

  1. Open the Settings page, and then click the Connections tab.

  2. Click Add to open the Connection Type modal.

  3. Click Dynamics 365 Business Central, then click Next.

  4. Continue from step 3 above for Connection Configuration Pane.

Select an Action

After establishing a connection to Dynamics 365 Business Central, you must choose the action that the Dynamics 365 Business Central connector will perform. The table below outlines each action and where it belongs in an ArcESB flow.

Action Description Position in Flow
Upsert Inserts or updates Dynamics 365 Business Central data. By default, if a record already exists in Dynamics 365 Business Central, an update is performed on the existing data in Dynamics 365 Business Central using the values provided from the input. End
Lookup Retrieves a value from Dynamics 365 Business Central and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from Dynamics 365 Business Central. It should be formatted as a SQL query against the Dynamics 365 Business Central tables.
Middle
Select Retrieves data from Dynamics 365 Business Central and brings it into ArcESB.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Beginning
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.
Middle