OpenText Core Analytics Database

Create comprehensive database designs with database designer

The database designer is enhanced to help database administrators create comprehensive database designs. These comprehensive database designs enable administrators to perform a detailed design analysis by providing additional inputs, including design type, objectives, options, and sample queries for both schemas and tables.

Enhanced Query Console

The SQL query console is now enhanced to significantly improve SQL execution experience. You can run multiple SQL statements in a single execution and view their result sets sequentially, simplifying complex operations.

Enhanced schema and object management

The SQL editor provides improved object management. This update simplifies the creation and management of database objects, allowing you to effortlessly create views, procedures, and flex tables. You can also preview the generated SQL at each step, ensuring greater control and accuracy.

Create and manage data loading from local files

Data loading capabilities are enhanced in OTCAD. This new feature empowers you to effortlessly load data directly from your local files. CSV, TSV, and parquet file types are supported for data ingestion.

Generation of Scrutinizer log files from the UI

Database administrators can now directly generate Scrutinizer log files from the OTCAD UI. This new capability significantly reduces manual touchpoints and accelerates the turnaround time for support and service requests, enhancing efficiency and simplifying troubleshooting workflows.

Voltage SecureData integration

Voltage SecureData is a suite of encryption technologies that let you integrate end-to-end data encryption into other applications. OTCAD now supports Voltage SecureData integration. For more information about Voltage Secure Data, see the Voltage web site.