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.
Overview
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 Microsoft Entra ID), you can choose from among the three tools available.
-
Jet Excel add-in
All supported data source types can be created, exported from, and imported into the Jet Excel add-in.
To access data Source settings from Jet Excel add-in, select Settings > Data Source Settings.
For specific details, see Create and Configure Data Sources.
-
Jet Administration Console
If your organization uses the Active Directory user management system, you can utilize the Jet Administration Console (JAC) from the Windows Start menu.
The JAC is a utility that allows you to define data source settings, configure users, and assign data source permissions to those users.
-
If your organization uses Microsoft Entra ID (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