Jet Analytics Data Integration 6024.1

Released October 18, 2022. This is the inaugural release of Jet Analytics Data Integration, introducing a new cloud-enabled architecture based on Ingest, Prepare, and Deliver instances managed through the Jet Analytics Portal.

New

Platform

• A Jet Analytics solution is now based on Ingest, Prepare, and Deliver instances set up and managed in the Jet Analytics Portal. The Jet Analytics portal is managed by the insightsoftware Support team. For assistance or additional information, reach out to Product Support .
• User management and access control in the Portal.
• License keys and client secrets replaced with sign-in authentication for Jet Analytics Data Integration.
• New usage-based pricing model.

Ingest

• Manage data sources in the Portal — create and share data source connections without distributing credentials.
• Oracle data source provider.
• Dynamics 365 Business Central data sources.
• Rollup data files in Azure Data Lake.
• Sync data sources through Azure Data Factory.

Prepare

• Data profiling.
• Lookup transformation.
• Multiple Ingest table mappings based on filters (Mapping Sets).
• Support for multiple Ingest instances as sources for a single Prepare instance.

Deliver

• Power BI Premium XMLA endpoint support.
• CSV endpoint for sDeliver instances.

Changed

• Improved synchronisation from Prepare to Deliver instances and from Ingest to Prepare instances.
• Select tables from a list in addition to rule-based selection in Ingest instances.
• Improved creation of Azure Data Factory pipelines for transfer between Data Lake and Prepare instance storage, delivering better performance and reduced cost.
• SSIS has been removed as a transfer option for Prepare instances.
• Business Units have been removed (replaced by Prepare instance data areas).
• SSAS Multidimensional (OLAP) Cubes, the Qlik modeller, and Data Export have been removed from Deliver instances.
• All previously deprecated features have been removed.