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