Jet Analytics Data Integration 6744.1

Released September 3, 2024. Desktop version 6744.1.

New

• String aggregation for aggregation tables: String aggregation is now available as an aggregation option. Output values are comma-separated and ordered by column content.

• Persist View: Views can now be persisted as a table.

• Data provider filter: A filter for available data providers has been introduced to improve data source selection.

• Clone instances: Instances can now be cloned for more efficient environment management.

• Hidden fields in data source connection forms: Support for hidden fields has been added to data source connection forms.

• Parallel Deliver instance executions: In the Execution Service Configuration tool, the maximum number of parallel Deliver instance executions can now be configured. The default is 1.

Improved

• The Jet Analytics Data Integration database cleanup tool can now run without requiring a data area to exist.
• The Solution Explorer in Jet Analytics Data Integration now remembers whether a node was collapsed when the solution tree is refreshed.
• Improved the error message displayed when opening an incompatible instance.
• The Environments page has been renamed to Migrations, accessible at /migrations. Non-migration-related functionality has been removed.
• The Instances page and Environments page have been merged, now accessible at /instances, with drag-and-drop support for moving instances between environments.
• A new design has been implemented for data tables.
• Improved loading speed of the organisation table.

Fixed

Portal

• Fixed an issue where it was not possible to save a Prepare instance after previously encountering an error.
• Fixed a bug that caused the customer table to not refresh after deleting a customer.
• Fixed an issue that made it impossible to delete some data source connections due to hidden double spaces in the name.
• Fixed an issue where important setup properties were accidentally overwritten during updates, and ensured that the connection string is securely encrypted when edited.
• Fixed an issue to ensure repository information and related secrets remain properly aligned and consistent.
• Fixed an issue that caused organisation creation to fail due to incorrect data handling.
• Comments are now properly added to the activity log when removing a company; duplicate comments that appeared when deleting an organisation have been removed.
• Resolved an issue where the hand cursor appeared on mouse-over of an instance on the Environments page but clicking did not trigger any action.
• Corrected an incorrect tooltip displayed for the Delete Instance button.
• Addressed alignment issues with dropdowns and the search icon in multi-select filters.

Jet Analytics Data Integration

• Double-clicking a view field in data lineage did not select the view field node.
• Shutting down Jet Analytics Data Integration with a step in the Execution Queue prompted an exit confirmation, but the application would exit when clicking No instead of Yes.
• Resizing the column width in the Ingest incremental load dialog was disabled.
• Dragging a table node from the Deliver source database browser to the Deliver tables node did not work.
• Dragging a field node from the Deliver source database browser to a Deliver table node did not work.
• The context menu for editing an environment was displayed on the default environment in Jet Analytics Data Integration.
• The buttons for showing schemas on the Ingest ADO and OLE.DB data source advanced settings were hidden.
• Null reference error when validating a Deliver Qlik endpoint of type Qlik View while using Snowflake as the source Prepare instance.
• Incorrect label for the table distribution setting for Dedicated SQL Pool.
• Synchronising a Prepare instance with an Ingest instance showed tables as missing when the data source had "data on demand" enabled and no execution tasks were added.
• Searching for tables for mapping sets in the Prepare instance did not find tables where the data source had "data on demand" enabled and no execution tasks were added.
• Listing constraint suggestions in the Prepare instance did not find tables where the data source had "data on demand" enabled and no execution tasks were added.
• Adding new view fields to a standard view was blocked after selecting a field in the overview pane.
• Some Ingest execution logs were occasionally missing due to a timing issue in the Ingest execution logic.
• Potential null reference error when two users concurrently committed a change on an Ingest data source or task.
• Some Deliver dialogs could only be resized horizontally.
• Tabular Security DAX was incorrect when more than one security setup was configured.
• Moving Ingest data type override rules up and down sometimes caused an index out of bounds exception.
• A circular reference in data lineage with history tables caused data lineage to run indefinitely.
• Warning and error report dialogs displayed "database" instead of "data area".
• When adding a private data source (ADO.NET), an error stating that an assembly file was not found was thrown.
• When right-clicking a table with a mapping type of Integration Table, the client sometimes crashed.
• Updated the layout of the Deliver Role dialog.
• Fixed an issue where the Ingest Service would become stuck in the "Starting" state when the authentication token could not be renewed.