Jet from insightsoftware

Setting up Dynamics 365 Export to Data Lake
Set up Dynamics 365 Export to Data Lake Overview Setting up Export to Data Lake in Dynamics 365 F&SCM consists of the following steps: Configure the Azure Resources Install the Export to Data Lake add-in Use Serverless Pool as a Source to read data The References section contains references to the Microsoft documentation on the subjects in this procedure. Configu...
How to Download and Install ISW Data Entity Packages
How to Download and Install ISW Data Entity Packages This procedure is to be performed by your F&SCM Administrator. Once this procedure has been completed, you can proceed to How to set up the F&SCM Hybrid data source connector with Jet Reports . To download and Install ISW Data Entity Packages Receive and download the ISW package zip file. Log in to Li...
How to set up the F&SCM hybrid connector with Jet Reports
How to set up the F&SCM hybrid connector with Jet Reports You can use Jet Reports with F&SCM using the F&SCM hybrid data source connector. With this connector, you can combine the power of F&SCM entity information with the robustness of BYOD. This article explains how you can set up the F&SCM hybrid connector with Jet Reports. Prerequisites Make sure that your F&SCM environment i...
Connecting Jet Analytics to Dynamics CRM with CData
Connect Jet Analytics to Dynamics CRM with CDataPrerequisitesBefore starting the connection: Make sure that you have the Dynamics CRM provider downloaded into your project and updated to the latest version.  See Managing CData Providers. Create an App. See also Steps to Create a Custom OAuth App. Follow the steps below to connect Dynamics CRM with CData. Connect to Dyna...
Create a Dynamics NAV 2013 to 2018 - SQL Server Data Source with Jet Reports
Create a Dynamics NAV 2013 to 2018 - SQL Server Data Source with Jet Reports Applies to Jet Reports versions 2013 Update 1 and higher Related Articles... Overview Jet Reports includes a data source type for Dynamics NAV 2013 to 2018 (SQL Server) . For organizations and users with direct access to the SQL Server on which their NAV 2013-2018 database is stored, this...
Business Central 15.0-15.5, 16.0, 17.0, 18.0-19.0 Jet Reports Extensions
Business Central 16 Or Later Jet Reports Extensions Business Central retired the legacy development tool, C/SIDE, and development language, C/AL in Wave 2, replacing them with a modern solution based on Visual Studio Code, Azure DevOps, and an AL language that supports an extension-based approach to customization. Because of this, Jet Reports customers using a Business Central Wave 2 on-premis...
Create and Configure Data Sources
Create and Configure Data Sources Jet Administrators may also want to see the Data Source Admin Guide Related Articles... Overview The Data Source Settings are used to define one or more database connections. Before you can generate reports using the Jet Excel add-in, you must first define how to access the data you want to display in your repo...
Create a Dynamics NAV data source with Jet Reports
Create a Dynamics NAV data source with Jet ReportsHelp Topics... Overview Jet Reports can connect to your Dynamics NAV data in a variety of ways - depending upon the version and type of NAV configuration your organization uses. Here are some helpful knowledgebase articles to help you access your NAV data. NAV 2013 and higher SQL D...
Create a Dynamics GP data source with Jet Reports
Create a Dynamics GP data source with Jet Reports Beginner Related Articles... Overview Before you can create a Data Source connection to a GP database located on a server on your network, you must first download and install the Jet Excel add-in from the Jet Reports download website . Because Jet Reports does not connect to the Dynamics GP client, you will need ...
Using Analysis Services Tabular Model with Jet Analytics
Using Analysis Services Tabular Model with Jet Analytics The article applies to Jet Analytics 2019 and higher Overview In addition to working with OLAP Cubes, Jet Analytics also supports the use of a Tabular Model .  This works well for those environments that do not support the SQL Server Analysis Services required for OLAP Cubes. Jet Analytics supports both on-premise...
Using Power BI with Jet Analytics
Using Power BI with Jet Analytics Overview Power BI offers great data visualization tools.  To take full advantage of those tools, you will want to ensure that the data you are using is in the best format for those tools. The Jet Analytics OLAP Cubes and Data Warehouse make using Power BI easy and powerful. How-To Video Using Power BI with Jet Analytics This ...
Create and Configure Data Sources- Admin Guide
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 ...
User and Data Source Management in Jet Hub
User and Data Source Management in Jet HubRelated Articles Overview Jet Hub includes administrative functionality which makes it easy for administrators to create and manage user and data source information. The settings within Jet Hub allow administrators to: Managing Data Sources Managing Users Assigning Data Sources to Users Prerequisites Jet Hub and the Jet Serv...
Create a Dynamics 365 Business Central Data Source
Create a Dynamics 365 Business Central Data Source Overview Jet Reports can connect to your Dynamics 365 Business Central data in a variety of ways - depending upon the version and type of BC configuration your organization uses. Here are some helpful instructions to help you access your BC data. SQL Direct If you have direct access to...
Create A Business Central (Public Cloud Web Services) Data Source
Create A Business Central (Public Cloud Web Services) Data SourceRelated Articles... Overview Configuring a Jet Reports data source connection to your Dynamics 365 Business Central data require two steps: Installing the Jet Reports extension within your Business Central environment Setting up a Dynamics 365 Business Central data source within Jet Reports Note that Mu...
Dynamics 365 - Custom Data Source Configuration
Dynamics 365 - Custom Data Source Configuration OVERVIEW Data sources contain the data that you want to retrieve and use for analysis. This article details the required steps to add a custom data source to connect to Dynamics 365. Your license determines the number and type of data sources that you can connect to. A standard license permits a connection to one data source. Additi...
Using Azure SQL for Repository, Data Warehouse and Staging Databases
Using Azure SQL for Repository, Data Warehouse and Staging Databases Overview As cloud services grow ubiquitous and more and more powerful, Jet Analytics expands its support. Jet Analytics 17.5 and higher supports using Azure SQL Server for your repository, data warehouse, and staging databases (earlier versions require a local SQL Server for running Jet Analytics). The main b...
Create a Dynamics NAV SQL Data Source in Jet Hub
Create a Dynamics NAV SQL Data Source in Jet Hub This feature is available in Jet 2019 R2 and higher Related Articles... Overview You can define a data source connection to Dynamics 2013-2018 from directly within Jet Hub. Process From the Jet Hub Admin menu, select Data Source Setup On the Data Source Setup window, click the + Add Data Source butt...
Create a Dynamics NAV Web Services Data Source in Jet Hub
Create a Dynamics NAV Web Services Data Source in Jet Hub This feature is available in Jet 2019 R2 and higher Related Articles... Overview You can define a data source connection to Dynamics 2013-2018 Web Services from directly within Jet Hub. Process From the Jet Hub Admin menu, select Data Source Setup On the Data Source Setup window, click the + Add...
Create a Dynamics GP Data Source in Jet Hub
Create a Dynamics GP Data Source in Jet Hub This feature is available in Jet 2019 R2 and higher Related Articles... Overview You can define a data source connection to an on-premises Dynamics GP database from directly within Jet Hub. Process From the Jet Hub Admin menu, select Data Source Setup On the Data Source Setup window, click the + Add Data Sour...
Create A Business Central (On-Premises Web Services) Data Source
Create A Business Central (On-Premises Web Services) Data Source This information applies to Jet Reports 2019R2 and higherModerate - Business Central administration knowledge needed Related Articles... Overview Once the Jet Excel add-in has been installed, Dynamics 365 Business Central has been configured to access your local Business Central data, and Web Services ...
Create a Business Central (SQL Server) Data Source
Create a Business Central (SQL Server) Data Source This information applies to Jet Reports2019R2 and higherRelated Articles... Overview You must be using either Windows Authentication or User/Password Authentication to access Dynamics 365 Business Central. Creating a Jet Reports Connection to the Business Central SQL Database From within Excel, go to the Jet ...
Create A Multi-Tenant Business Central (Dynamics 365 SQL Server) Data Source
Create A Multi-Tenant Business Central (Dynamics 365 SQL Server) Data Source This information applies to Jet Reports2019R2 and higher Overview Configuring the Data Source in the Jet Administration Console If your organization uses the Jet Service Tier to provide centralized data source settings to the Jet Excel add-in and/or Jet Hub, you can use the Jet Administration...
GP Update Utility
GP Update UtilityHelp Topics... Overview The GP Update Utility creates a set of tables, views and security roles in your Microsoft Dynamics GP database which help with security and significantly improve the reporting experience. Jet Reports recommends that the GP Update Utility be used with all Microsoft Dynamics GP databases. The GP Update utility is intended to be used by a data...
Configure Microsoft 365 Authentication for Dynamics NAV or Business Central On Premises
Configure Microsoft 365 Authentication for Dynamics NAV or Business Central On Premises This article applies to using the Jet Excel Add-in (2017 or higher) with Dynamics NAV 2015 - 2018 or Business Central On Premises Related Articles... Overview The purpose of this guide is to outline the procedures necessary in order to configure the Jet Excel add-in to use Microsoft 365 creden...
Use Business Central with Jet Analytics
Use Business Central with Jet Analytics Overview This KB article has been deprecated. Please refer to this updated article. Configuring a connection between Jet Analytics and your Business Central tenant is accomplished through two distinct steps: Importing the Jet Reports Queries into Business Central Configuring Jet Analytics for use with Business Central ...
Connect to Multiple Environments with the Dynamics 365 Business Central Public Cloud Data Source
Connect to Multiple Environments with the Dynamics 365 Business Central Public Cloud Data SourceRelated Articles... Overview As a Dynamics 365 Business Central public cloud user who maintains multiple Business Central environments, you may occasionally wish to connect your Jet Reports to an environment besides your default production environment. When connecting to Business Cen...
Business Objects (FOB) for Dynamics NAV and Business Central
Business Objects (FOB) for Dynamics NAV and Business Central Advanced - NAV/BC Admin Access Required Related Articles... Overview When connecting the Jet Excel add-in to your Dynamics NAV 2013 - 2018 through NAV Web Services, you will need to use the Jet Reports Business Objects for NAV. There are three steps to configuring NAV's Web Services Installing the Jet R...
Business Central Team Member Licenses with the Jet Excel add-in
Business Central Team Member Licenses with the Jet Excel add-in This article applies to using the Jet Excel Add-in (2019 or higher) with Dynamics 365 Business Central Related Articles... Overview The Dynamics 365 Business Central Team Member subscription is a named user subscription designed for users who are not tied to a particular function, but who require basic Dynamics 365 Bu...
Connect to the Jet Service Tier using Jet Reports
Connect to the Jet Service Tier using Jet Reports Overview When the Jet Service Tier is deployed within an an organization, users can easily connect to their company databases without having to define data source connections on each individual computer. Prerequisites Users must be using Jet Reports (version 2013 or higher). The Jet Service Tier must be installed and run...
First Page
Back
For an optimal Community experience, Please view on Desktop