While in the Jet Data Manager, you define the settings for your Dynamics 365 Business Central data source by right-clicking the specific data source and selecting Edit CData Data Source:
You then need to provide the URL for your organization's implementation of Business Central and whether or not you are connecting to a BC Sandbox:
There are three specific types of Business Central implementations and each requires a specific format for the URL
How to find your Business Central URL
Within Business Central, navigate to the Web Services area and then click on any URL listed:
The format of the resulting URL determines the type of connection you need to use.
Standard Production Connection
You can see below that the standard production tenant uses the normal businesscentral.dynamics.com followed by the Business Central GUID:
This URL would be placed in the Organization URL field of the JDM Edit CData Data Source window.
Standard Sandbox Connection
You can see below that the standard sandbox tenant uses the normal Business Central URL with /Sandbox appended to the end:
It is this URL that would be placed in the Organization URL field of the JDM Edit CData Data Source window and the field for Use Sandbox would be set to True.
Full Control Connection
Some implementations of Business Central (both for production and for sandbox) do not use the standard URL format. Instead, these use specific versions of the Microsoft Business Central API.
This type of URL contains:
- an indicator of the version of the API that is being used
- the Business Central GUID
- additional information about the BC environment
It is this URL that must be placed in the Organization URL field of the JDM Edit CData Data Source window. If this is a Business Central Sandbox, the field for Use Sandbox must be set to True.
Your Jet Analytics data source will now access the desired Business Central data.