Jet Analytics Data Integration Prerequisites

This article describes the software requirements needed to run Jet Analytics Data Integration. It does not cover hardware requirements or recommendations on server configuration. Refer to Microsoft's recommendations for Microsoft SQL Server sizing when deciding on hardware needs and configuration.

The minimum software requirements to run Jet Analytics Data Integration are listed below, split into two areas: Application Server and Database Server. When Jet Analytics Data Integration is installed on a server that does not run Microsoft SQL Server, those requirements must be installed manually. If Microsoft SQL Server and Jet Analytics Data Integration reside on the same server, all components (except the .NET Framework) are already installed by the SQL Server installation.

Application Server

When data will be hosted in on-premise SQL Server

When installing Jet Analytics on a separate server from Microsoft SQL Server, the following components must be installed or configured:

• .NET Framework 4.8 or higher
• IPv4 connectivity for connecting to Ingest Cloud instances
• Core XML Services (MSXML) 6.0
• Microsoft SQL Server Native Client
• Microsoft SQL Server System CLR Types
  • Install the version that corresponds to the version of SQL Server. Not required for SQL Server 2017 or later.
• Microsoft SQL Server Management Objects (SMO)
  • Install the version that corresponds to the version of SQL Server. Not required for SQL Server 2017 or later.
• Microsoft Analysis Management Objects (AMO), ADOMD, and AS_OLEDB
  • Install the version that corresponds to the version of SQL Server. See the Analysis Server 2016 Feature Pack.
• WebView2 — install using the Evergreen Standalone Installer from Microsoft's WebView2 download page.

When data will be hosted in Azure SQL or Azure SQL Managed Instance

Using a Microsoft Azure SQL server requires the following components to be installed on the application server:

• .NET Framework 4.8 or higher
• IPv4 connectivity for connecting to Ingest Cloud instances
• SQL Server Management Studio — download the latest edition. Because Azure SQL databases are SQL Server 2017, the necessary DLLs for versions newer than this are applied during the Jet Analytics installation.
• Client libraries for connecting to Azure Analysis Services

When using developer client workstations

The Application Server requirements also apply when Jet Analytics is not installed on a dedicated application server, but instead has multiple installations on individual developer workstations. Any machine that has Jet Analytics Data Integration installed without SQL Server is considered an Application Server and must comply with the Application Server software prerequisites.

Database Server

On Microsoft SQL Server, the Application Server requirements above (except the .NET Framework) are installed during the SQL Server installation. In addition to those, the following minimum requirements must also be met:

• Microsoft SQL Server 2008 or later — minimum edition is Standard, with the following components:
  • DB Engine
  • Analysis Services (SSAS) — only required when using OLAP Cubes or Tabular Models
• Microsoft Azure SQL Server (DB Engine only)
• IPv4 connectivity for connecting to Ingest Cloud instances

Advanced Feature Requirements

Most Jet Analytics functionality can be accomplished using the Standard Edition of Microsoft SQL Server; however, the following features require the Enterprise Edition, or SQL Server 2016 SP1 or later:

• Compression of tables and indexes
• Partitioning on tables
• Non-Physical Cube Perspectives (Standard Perspectives on SSAS)
• Incremental Load on Cubes
• OLAP translations for translating dimension member display values

Verify Requirements

.NET verification

Navigate to the following path in the Registry Editor to verify the .NET version installed:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full

Microsoft SQL components verification

Microsoft SQL Server Native Client, Microsoft SQL Server System CLR Types, and Microsoft SQL Server Management Objects can all be verified by checking the list of installed programs.

In Windows, navigate to Control Panel > Programs and Features. The image below shows the required components listed above have been installed, along with Microsoft SQL Server 2016 (64-bit).

Jet Analytics Data Integration Activation

When you start the program, a Sign in dialog will appear. After a successful sign-in, you will see the instances that the current user has access to. For more information on granting users access to an Ingest instance in the Jet Analytics Portal, see Grant and Revoke Access to Instances.

The Jet Analytics portal is managed by the insightsoftware Support team. For assistance or additional information, reach out to Product Support .

Troubleshooting

The following common errors may occur due to missing prerequisites.

Error writing to file

• Issue: Microsoft .NET 4.8 or higher is not installed.
• Resolution: Install Microsoft .NET 4.8 or higher, or run the setup.exe (not the MSI) from the Jet Analytics Data Integration installer.

Could not load file or assembly

• Issue: SQL Shared Management Objects (SMO) or Analysis Management Objects (AMO) is not installed.
• Resolution: Install the appropriate version of Microsoft SQL SMO or AMO that corresponds to the version of Microsoft SQL Server in use.

Jet Analytics Data Integration not launching after installation

• Issue: Missing the appropriate .NET Framework.
• Resolution: Reinstall Jet Analytics Data Integration using the setup file, or download and install Microsoft .NET Framework 4.8 or higher.

Additional Information

Jet Analytics Data Integration supports newer versions of Windows OS, including Windows 11 and Windows Server 2022.