Incorta Product Release: Announcing Release 5.2

[KailaT]

Incorta Release 5.2 is now available, you can get from the following links:

• Google Drive
• CloudSmith (+DA)
• Build ID#: Incorta-20220627-1708-11654

Release Highlights

The goal of the Incorta 5.2 release is to introduce new features, new connectors, and major enhancements, such as the Insights over Analyzer result sets, Incorta SQL Views, Oracle Enterprise Performance Management (EPM) connector, FTP and SFTP as data destinations, Cluster Management Console (CMC) Monitoring tool, and much more.

Incorta is now supporting the backslash as an escape character in the formulas as well as the TO_NUMBER PostgreSQL format function. In addition, this release introduces a new and improved Schema Manager and Designer.

Incorta has also enhanced several visualizations, such as the bubble and advanced map visualizations. Incorta is now also supporting Apache Tomcat 9.0.54.

These new features and enhancements improve the platform’s analytical capabilities, data management, and performance. It also enables you to further process your data and maximize your benefit from it.

New Features

Dashboards, Visualizations, and Analytics

• Insights over result sets
• Download to Excel support for user interface (UI) settings
• Support for date and timestamp data types in CASE and DECODE conditional statements
• Visualization enhancements for Donut Total and Table style and appearance
• Bubble Chart visualization enhancements
• Advanced Map visualization enhancements
• Backslash support as an escape character
• New format options for the Date column
• Dynamic Group By for multiple columns in Aggregated Tables

Data Management Layer

• Incorta SQL Views in Business Schema
• Infrastructure Monitoring tool in the Cluster Management Console
• Google Cloud Storage Connector
• Oracle Enterprise Performance Management (EPM) connector
• SAP ERP Connector enhancements
• Oracle Cloud Applications connector Maximum Cache Size
• Data lake connector file exclusion
• Automatically force load jobs stuck in the interruption process to abort
• Different incremental load strategies for Materialized Views (MVs)
• Limited access to the Business Schema Manager for Analyze and Individual Analyzer users
• Global variable support in MVs
• Notebook enforcement of physical schema permissions
• New security password for exporting and importing tenants in the CMC
• Data type lock in a multi-source table
• Delta Lake compatible catalog folder structure
• FTP and SFTP servers as Data Destinations
• Support for the TO_NUMBER PostgreSQL format function
• Schema Designer and Table Editor New User Interface (UI)
• Export and Import an Incorta Notebook
• Enhanced data loading into memory
• NetSuite SuiteQL connector to support REpresentational State Transfer (REST)
• New Connectors tab for managing CData connectors in the Cluster Management Console (CMC)
• Data Agent support for version option in the agent script
• Pre-SQL support for Oracle and MySQL connectors
• Notebook support for using specific paragraphs in the Materialized View (MV) script
• PostgreSQL MV support for an equivalent SparkSQL query with copy and refresh options

Architecture and Application Layer

• Encryption and decryption support in Scala Materialized Views
• Parallel enrichment of independent MVs within the same physical schema
• Enhanced Dashboard query performance
• Log in using Single-Sign On (SSO) from the Incorta login page
• Interrupt long-running dashboards that block sync processes
• Define the number of data frame partitions resulting from loading an MV
• Loader memory reduction for encrypted columns

Integrations

• A new version of the Excel Add-in