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

Jet Hub - Data Source User Credentials


Related Articles...


When users of Jet Hub want to access data sources that require user-specific login credentials, they must - at least once - access the data source settings through the Jet Excel add-in.

This applies to any Dynamics GP, Jet Data Warehouse, Cube (over IIS), Jet Remote Data Service, Dynamics NAV Web Services, or Dynamics NAV SQL Server data source.


  1. The system administrator has set the Scopes for this data source connection to require that each user provide their own - user-specific - user name and password.

  2. usercred2.png
  3. Before a user on Jet Hub can run a report that reads from that data source, the user must first run Microsoft Excel with the Jet add-in and enter their user name and password in the Data Source Settings:


Helpful Hints

In some environments, not every user has Excel (nor the Jet Excel add-in) installed on their system.  In those situations, there are alternatives to enable accessing the Data Source Settings.

  1. If your environment would allow every Jet user to access the database with the exact same user permissions, you can configure a single user for accessing the data.


    The Scope for those settings would then be configured for Shared:

  2. Another option available to you would be to configure a single system with Excel, the Jet add-in, access to the Jet Service Tier, and Remote Desktop Services.  Users could then connect to that system (once), set up with user credentials, and then be able to run reports from Jet Hub.

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