Jet from insightsoftware

Jet Reports – Configuration with Active Directory Group Security
Jet Reports – Configuration with Active Directory Group Security Overview This document describes the necessary configuration for Jet Reports if you are managing the security in your NAV or BC environment by Active Directory Security Groups.  The screenshots in this example are based on local groups, but the principle is the same. Group Setup A group is setup, ...
Dynamics NAV Security with Jet Reports
Dynamics NAV Security with Jet Reports Overview When defining a Jet Reports data source connection to a Dynamics NAV database, it is necessary to provide the account credentials that will be used to create that connection: These credentials are used to ensure that the user's roles and permissions defined with Dynamics NAV are respected by Jet Reports. Related Articles ...
Dynamics GP Security with Jet Reports
Dynamics GP Security with Jet Reports Overview When defining a Jet Reports data source connection to a Dynamics GP database, it is necessary to provide the account credentials that will be used to create that connection: The Jet Excel add-in does not utilize the Dynamics GP client but, instead, connects directly to the SQL server itself in order to retrieve information from the d...
Jet Excel Scheduler Permissions - Running Scheduled Tasks When Logged Off
Jet Excel Scheduler Permissions - Running Scheduled Tasks When Logged Off Expert Overview The Jet Scheduler is a Jet-specific interface for creating Windows Tasks that are then run by the Windows Task Scheduler. In addition to any permissions that Microsoft requires for being able to create and run scheduled tasks (for detailed information, please refer to Microsoft's document...
Configuring Multi-Dimensional Analysis Services (OLAP) Security in the Jet Data Manager
Configuring Multi-Dimensional Analysis Services (OLAP) Security in the Jet Data Manager Related Articles This article applies ONLY to multi-dimensional Analysis Services. If your installation is using tabular analysis services, please see the appropriate article. End users must be granted rights before they can access the cubes. These rights are configured using the ...
Using "Basic User" Authentication with Jet Reports and Jet Hub
Using "Basic User" Authentication with Jet Reports and Jet Hub This feature is available in Jet Reports v20.3 and higher. Overview Jet Reports and Jet Hub support Basic User Authentication .  This enables those organizations who are *not* using Active Directory or Microsoft Entra ID to continue to add users through the use of a simple username and password method and allow tho...
Data Warehouse Security (JDM 2016 and Newer)
Data Warehouse Security (JDM 2016 and Newer) Overview In the Jet Data Manager, users can control access to database objects and data directly in the data warehouse.  It is easy to configure access on the object level, data level, or both. Assigning data warehouse security at the object (ie: table) level is accomplished in two steps: Adding a Database Role Assigning Obj...
Environment Security with the Jet Data Manager
Environment Security with the Jet Data Manager Overview You can limit access to certain functionality to members of specific Active Directory (AD) groups. The JDM will also log events in the environment to the Server Log table in the repository. This can be disabled by clearing Enable detailed logging under Additional Settings for the environment. Adding Security to an E...
Using Dynamics NAV Row-Level Security with Jet Reports - NAV 2013 - 2018
Using Dynamics NAV Row-Level Security with Jet Reports - NAV 2013 - 2018 This information applies to NAV 2013 - 2018 Overview Row-Level security in Dynamics NAV 2013 and higher (officially referred to as "Security Filters") can be used with Jet Reports. Dynamics NAV 2013 - 2018 make Security Filters available to both the Dynamics NAV 2013 - 2018 (SQL Server) data so...
Dynamic Cube Security with the Jet Data Manager
Dynamic Cube Security with the Jet Data Manager Introduction Maintaining complex security in a cube can be a challenge and rather cumbersome, especially if there are a lot of different user roles that need to be accounted for. One example would be a company has 100 salespeople and each salesperson is only allowed to see their own data. If you want to do this using a non-dynamic approa...
Removing Active Directory Distribution Groups from Jet Reports
Removing Active Directory Distribution Groups from Jet Reports Overview The installation program for Jet Reports 2019 and higher will automatically remove any Active Directory Distribution Groups that may have been configured for use in previous versions of Jet Reports. Distribution Groups should not be used to grant users access to resources.  Any existing A/D Distribution Groups th...
Kerberos "Double Hop" and "Delegation"
Kerberos "Double Hop" and "Delegation" Overview When Kerberos authentication requires a "Double Hop" of credentials, Delegation must be configured on the network. DefinitionsKerberos Kerberos is a network authentication protocol which allows computers on a network to communicate with each other in a secure manner. Single Hop Before we define "Double Hop", let's look at a ...
Configuring user and group access to the JRDS
Configuring user and group access to the JRDS Overview Jet Remote Data Source (JRDS) access By default, all users are authorized to access the JRDS.  The full set of allowed and denied users can be viewed with the Get-JetRemoteDataServiceInstance command and noting the values shown for Authorized Users, Authorized Groups, Denied Users, and Denied Groups. Through the use of Set...
Giving Jet Reports permission to access Azure Cloud data
Giving Jet Reports permission to access Azure Cloud data Technical Overview Dynamics NAV and Dynamics 365 can utilize Microsoft's Azure -  a secure cloud service that integrates operating systems with applications.  By adding Jet Reports to your organization's NAV environment, you get the all the abilities of NAV/365 and all the reporting power of Jet products. ...
NAV Row-Level Security with Jet Reports (NAV 2009R2 and earlier)
NAV Row-Level Security with Jet Reports (NAV 2009R2 and earlier) In NAV versions 2009R2 and earlier, the Dynamics NAV C/Front utility handles most of the communications between NAV and other applications (such as Jet Reports). C/Front does not support Row-Level Security (also know as "NAV Security Filters").
Serenic Navigator User Access Rules
Serenic Navigator User Access Rules Overview Jet has the ability to apply Serenic Navigator's User Access Rules to all queries that are run by a user to which one or more rules apply. This feature can be enabled by importing the Navigator to Jet Bus Objects table into the Navigator database. Configuring Business Objects (available from Serenic) For each Busine...
SSL Certificates for Jet Hub
SSL Certificates for Jet Hub In order for your Jet Reports and/or Jet Analytics dashboards to be available over the Internet and accessible on mobile devices such as tablets and phones, an SSL Certificate from a trusted Certificate Authority is required.  Once you have acquired the SSL Certificate, the following article describes how to import it into Microsoft Management Console (MMC) and h...
Using Jet Reports in a Shared Desktop Environment
Using Jet Reports in a Shared Desktop Environment Overview Jet Reports can be installed and used in a variety of "shared desktop" environments including Citrix and Terminal Services (Remote Desktop). In order to use Jet Reports in a shared environment, the following guidelines apply: Publish the entire desktop (insightsoftware is unable to support using Jet Reports in a shared enviro...
Allowlisting Domain IPs on Azure
Allowlisting Domain IPs on Azure Overview When using an Azure VM or Azure SQL-based database with Jet products, it may occasionally be necessary to explicitly grant access to your data for those within your organization. This can be accomplished by "allowlisting" your organization's range of IP addresses. Access your Azure SQL Server Within the Settings ...
Configuring Row-Level Data Warehouse Security
Configuring Row-Level Data Warehouse Security This article only applies to the data warehouse. For configuration of OLAP Security see: Configuring OLAP Security When users are reporting from the data warehouse it is often necessary to restrict what they can see based on the data contained within a table. This type of security configuration is referred to as ro...
Custom Password Protection for SSIS Packages
Custom Password Protection for SSIS Packages Overview When working with data sources that use SQL Server authentication, the Jet Data Manager (version 16.2 and higher) allows you to supply a custom password to protect SSIS packages. Sources that use Windows authentication do not require encrypted SSIS packages. Process SSIS packages that contain SQL Server logins are encry...
First Page
Back
For an optimal Community experience, Please view on Desktop