Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Create a Business Central (public cloud) Data source in Jet Hub

This feature is available in Jet 2019 R2 and higher

Related Articles...


You can define a data source connection to a public cloud installation of Dynamics 365 Business Central directly within Jet Hub.  The data source will be available from both within Jet Hub and the Jet Excel add-in.


  1. From the Jet Hub Admin menu, select Data Source Setup

  2. On the Data Source Setup window, click the + Add Data Source button

  3. On the Details screen...

    • Give your data source a descriptive name

    • For the Database Type, select Dynamics 365 Business Central

    • For the Connection Method, select Web Services - Public Cloud

    • Click Save
  4. On to the Authentication screen...

    • Ensure that Dynamics 365 authentication is shown.

    • Click Save.

  5. Move to the Web Service settings...

    • Select the type of Web Service connection you would like to utilize. Please reference the article Using OData if you have any questions. 
    • Enter the full Instance for Business Central, please include an Environment name if there is one associated with your Business Central Tenant ID.  
    • Enter the name of the default (even if it is the only) Company name within the database.
    • Ensure that the Jet Codeunit setting is configured for JetDataSource.

    • Configure any other settings are instructed by your system administrator.

    • Click Save.


    Please note, Microsoft announced changes in Business Central 2021 release wave 2 (version 19.0) that SOAP has been superseded by OData V4. It's recommended that integrations are migrated to OData V4 as soon as possible.

  6. If needed, adjust any defaults in the other settings sections (contact your system administrator or specifics).

  7. Click the back arrow next to the Save button

  8. Your new data source will be displayed on the Data Source Setup screen.


To test your settings: start Excel with the Jet Excel add-in enabled; using the Jet Data Source Settings, access your newly-defined settings; from the Authentication tab, click Log in.


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