The Jet Administration Console is a user interface that makes it easy for administrators to create and manage the information in the Services Database when the Jet Service Tier (a set of Windows services used by Jet Reports and Jet Analytics dashboards) is used.
With the Jet Administration Console, you can edit:
- Jet data source properties for all your users
- User permissions
- The Jet Service Tier and Jet Administration Console must be installed.
- Users must be on Jet Reports version 2015 or later.
How to use the Jet Administration Console
Use the links below to jump to the corresponding section:
- Opening the Jet Administration Console
- Saving changes in the Jet Administration Console
- Establishing the connection to the Jet Services
- Managing Users
- Managing Data Sources
- Managing Scopes
- Managing Permissions
Opening the Jet Administration Console
You can open the Jet Administration Console from your Windows Start Menu.
Saving changes in the Jet Administration Console
Changes are saved:
- In the background when you switch between tabs.
- When you click Save on the ribbon
- When you close the Jet Administration Console.
Establishing the connection to the Jet Services
Go to the Settings tab of the Jet Administration Console.
Type the name of the Server where your Jet Services database and the Jet Service Tier are running.
If you have changed your Port number during the installation of the Service Tier, make sure that you update it on this tab as well. Otherwise, you can accept the default port number.
Click Connect on the ribbon.
When a connection to the Jet Services has been established successfully, you will be notified.
Click OK to close the message.
Go to the Users tab to add, manage, and remove users.
A User is a person who can access data sources defined in the Jet Administration Console to design and/or run reports using the Jet Excel add-in. A user may be defined as an individual Active Directory user, or as an Active Directory group. Defining users as groups enables an administrator to grant permissions to a group of users, greatly reducing security workload.
An Administrator can grant other users Administrator rights by changing the users’ security level. The individual who installed the Jet Service Tier has Administrator rights by default.
You can allow users to create Personal Data Sources. These are data sources that other individuals would not be able to see or use. Personal Data Sources are created inside the Jet Excel add-in. The data source connection properties are stored in the Services Database and are specific to the individual.
Managing Data Sources
Go to the Data Sources tab to add, manage, and remove data sources. You can configure data sources manually, or import existing data source settings from the Jet Excel add-in.
To import existing data source settings
Export your data source settings from the Jet Excel add-in:
In the Jet ribbon, select Data Source Settings.
Select Export > Data Sources...
Select the data sources you want to export.
Import your data source settings in the Jet Administration Console:
Open the Jet Administration Console and select the Data Sources tab.
In the ribbon, click Import. A File Explorer window opens.
Navigate to the export file you saved and open it.
Select the data sources you want to import. The imported data source settings are entered automatically.
Go to the Data Sources tab to edit the scope of your data source settings. Each setting on a data source has a 'scope' that you can customize.
To edit the scopes of your data source settings
In the ribbon, click Edit Scopes.
Configure the data source settings and scopes:
- Shared settings are identical for all users. Some settings must be shared and are locked. Server and Database are examples of settings that must be shared. Users cannot modify the value of shared settings from the Jet Excel add-in.
- User settings can vary by user. Display preferences and authentication information are examples of settings that should be defined as user settings.
- Machine/User settings can vary based on the combination of machine and user. File paths are examples of settings that should be set to machine/user.
When you have finished editing the scopes of your data source settings, click Edit Scopes again to confirm your changes.
Go to the Permissions tab to manage the permissions of your users.
You can give a user access to a data source by selecting the checkbox in the data source's column. If a data source is selected for a user, they have permission to access the data source connection properties.