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

Create and Configure Data Sources- Admin Guide

This article is intended to help Administrators evaluate methods for defining data source settings.  End users should reference Create and Configure Data Sources

Related Articles...


As a Jet administrator, you have choices regarding what tools you use to define the data source settings that will be used within your organization.

Depending upon the type of data source you need to access and your organization's User Management (Active Directory or Azure Active Directory), you can choose from among the three tools available.

  1. Jet Excel add-in

    All supported data source types can be created, exported from, and imported into the Jet Excel add-in


    For specific details, see Create and Configure Data Sources

  2. Jet Administration Console

    If your organization uses the Active Directory user management system, you can utilize the Jet Administration Console (JAC)


    The JAC is a utility that allows you to define data source settings, configure users, and assign data source permissions to those users.
  3. If your organization uses Azure Active Directory (AAD) or Active Directory, you can use Jet Hub to create settings for any Jet Hub-supported data source type.


    Data Sources in Jet Hub

    Dynamics NAV (SQL Direct)

    Dynamics 365 Business Central (Public Cloud)

    Dynamics NAV (Web Services)

    Dynamics GP

    Note: Testing your data source settings before use will require you to access your settings from within the Jet Excel add-in

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