Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

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.

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

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

    jac_ds_config.png

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

    hub_ds_config.png

    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

Related Articles

Published:

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

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.

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

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

    jac_ds_config.png

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

    hub_ds_config.png

    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

Related Articles

For an optimal Community experience, Please view on Desktop