Upgrade from Version 20.10 to Jet Analytics Classic

Overview

Jet Analytics version 20.10, colloquially known as "Classic", has been replaced by Jet Analytics Classic as the bearer of the Jet Analytics legacy.

Before support for Jet Analytics 20.10 ends in February 2027, we strongly recommend that you upgrade to either Jet Analytics Classic or Jet Analytics Data Integration. Both products are from insightsoftware and designed to meet different business needs.

Differences Between Jet Analytics Classic and Jet Analytics Data Integration

Jet Analytics Classic focuses on on-premises solutions based on Microsoft SQL databases, while Jet Analytics Data Integration is built to take full advantage of cloud-based infrastructure such as Microsoft Fabric, Azure Data Lake, and Snowflake.

Since Jet Analytics Classic is designed to solve a more specific use case than Jet Analytics 20.10, some 20.10 features are not available in Classic. We have also removed previously deprecated features to ease development going forward.

Feature Changes on Upgrade

ODX Removal

The ODX has been removed in favor of the business unit. On upgrade, all ODX objects and any data warehouse mappings that derive directly from an ODX will be deleted. The fields DW_ODXBatchId and DW_ODXBatchNumber will be converted to custom fields in the data warehouse.

CData Data Sources

The Classic licence does not include access to CData data source providers as a default. If you are currently using CData data sources, you have two options:

• Get in touch with insightsoftware to have the feature added (note that it is a paid add-on)
• Convert your CData data sources to Jet Analytics Enhanced data sources

Qlik Support Changes

Qlik Models and the Qlik Sense Server have been removed. All Qlik Models and their global database settings will be deleted. In Jet Analytics Classic, Qlik is supported through semantic models with endpoints for QlikView and Qlik Sense.

SQL Data Warehouse Support

The deployment target setting 'SQL Data Warehouse' has been removed. As a result of the focus on on-premises solutions, Jet Analytics Classic does not support SQL Data Warehouse (currently known as Dedicated SQL Pool). Any existing deployment targets set to 'SQL Data Warehouse' will be changed to 'Not Set'.

Removed Data Sources and Deprecated Objects

Navision 2.60 through 4.00 data sources have been removed.

The following deprecated objects have been removed:

• 'Split' and 'Concatenation' field mappings (all existing mappings will be deleted)
• Time table feature (existing time tables and their fields will be converted to custom tables)
• Data aggregations (existing aggregations will be removed)
• Mapping tables on the business unit (existing mapping tables will be converted to custom tables)

Removed Table Options and Settings

The following have been removed from tables:

• 'Enable BK hash key' option (if enabled, the corresponding field will be converted to a custom field)
• 'Entire row hash key' option (if enabled, the corresponding field will be converted to a custom field)
• 'Use left out join' history setting
• 'Enable target-based incremental load' option (if enabled, the fields 'Incremental Hash Key' and 'Incremental Value Key' will be converted to custom fields)

Removed Conditional Lookup Field Options

The following have been removed from conditional lookup fields:

• 'Force sub select' option
• 'Use temporary table' setting for the 'Multiple lookup fields' option
• 'Partition by' setting for the 'SQL mode' option

Activation Requirements

To ensure that you're always up to date on important changes, Classic must be activated using an activation file every six months. When you download the file from the Portal, you can review important announcements about the product.

Before You Upgrade

Obtain a License

Get in touch with your Jet Analytics partner or insightsoftware directly to obtain a Jet Analytics Classic license. If you have CData data sources and plan to keep using CData providers, make sure to get the CData feature added to your license (note that it is a paid add-on).

Download an Activation File

Sign in to the Portal, go to Admin > Licenses, and download an activation file for Classic. See the Jet Analytics Classic activation guide for more information.

Upgrade Your Current Version

Upgrade to the latest version of Jet Analytics 20.10 to ensure you are on a version that can be upgraded to Jet Analytics Classic. If you attempt to upgrade from a version that is too old, you will see an error message in Jet Analytics Classic when you attempt the upgrade.

Review and Refactor Projects

Go through each project that you want to upgrade and refactor it with an eye on the feature changes listed above. Decide what changes you want to make before the upgrade and let the upgrade script handle the rest, or leave the changes until after the upgrade.

If you use the ODX, implement your data sources in the business unit before you upgrade. If you have CData data sources and plan to keep them, update your CData providers to version 25.x.x.x, as previous versions are not available for Classic. If you have CData data sources and want to avoid the fee for using CData, convert your CData data sources to Jet Analytics Enhanced data sources using the 'Change Provider' feature in Jet Analytics 20.10.

Upgrade Steps

Step 1: Back Up Your Projects

Save the projects you want to upgrade in a new repository to protect against accidental data loss and disruption of service to the business.

Step 2: Install and Activate Classic

Download and install the latest version of Jet Analytics Classic. Open the application and activate it. Set the repository to the database containing the projects you want to upgrade.

Step 3: Perform the Upgrade

When the application detects a repository from a version of Jet Analytics 20.10 that can be upgraded, you will be asked if you want to upgrade the repository. Click Yes and the upgrade will continue as usual. During the upgrade, unsupported features and objects will be removed or converted as listed above.