Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Connecting to Business Central Using the Jet Data Manager


Related Articles...

Overview

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:

jdm01.png

 

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:

jdm02.png

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:

findurl.png

The format of the resulting URL determines the type of connection you need to use.

  1. Standard Production Connection

    You can see below that the standard production tenant uses the normal businesscentral.dynamics.com followed by the Business Central GUID:

    sandbox1b.png

    This URL would be placed in the Organization URL field of the JDM Edit CData Data Source window.

  2. Standard Sandbox Connection

    You can see below that the standard sandbox tenant uses the normal Business Central URL with /Sandbox appended to the end:

    sandbox2b.png

    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.

    sandbox2c.png

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

    • api.businesscentral.dynamics.com
    • an indicator of the version of the API that is being used
    • the Business Central GUID
    • additional information about the BC environment
    sandbox3c.png

    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.

    sandbox2d.png

Your Jet Analytics data source will now access the desired Business Central data.

 

Was this article helpful?
0 out of 0 found this helpful

Comments