2019-20 What's New (Archive)

SAP HANA Database Explorer

2018

Technical Component

Capability

Environment

Title

Description

Type

Available as of

SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: SQL Console Enhancement Database Explorer: A new History tab has been added to the SQL console. This tab shows the 50 most recently executed statements. Changed 2020-02-25
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Custom Command Separator If your SQL statements contain a custom command separator, then set the custom separator in the SQL Console section of the Global Preferences so that the parser recognizes your command separator. Command separators differ from statement delimiters in that they separate commands, which can be either a single-line SQL statement or a block of SQL statements that are separated by their own statement delimiter. New 2020-03-27
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Import Catalog Object Enhancement If you are including object data when importing a catalog object, you now have the option of selecting Fail import if it contains invalid data. Selecting this checkbox on the Import Catalog Objects dialog ensures that your import is canceled if any of the object data is incomplete or corrupt. Changed 2020-02-25
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: View Diagnostic Files To view a diagnostic file in an editor, you now right-click the file and click Show Files in the context menu. Changed 2020-03-27
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Overview Enhancement The database Overview page now shows Resident Memory usage. Changed 2020-02-25
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Table Editor Enhancement The table editor now contains a Runtime Information tab that shows general information as well as information about your database's partitions and columns. Changed 2020-03-27
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: SDI Enhancements

The following enhancements have been made to SDI catalog objects:

Adapters

On the Adapters overview page, use the new Reload button to update your selected adapter, or use the new Remove Location button to remove the adapter from an agent instance.

Agents

You can now create, edit, and drop agents from the Agents overview page.

You can also add an adapter for your agent by clicking the new Add Adapter button in the Agents overview page when you have an agent selected.

Agent Groups

You can now create and drop agents from the Agent Groups overview page.

You can also add an agent to your agent group by clicking the new Add Agent button in the Agent Groups overview page when you have an agent selected.

For more information about SDI and the privileges required to work with SDI objects, see the SAP HANA Smart Data Integration and SAP HANA Smart Data Quality guide.

Changed 2020-02-25
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Change Database Display Name You can now change the name that is displayed for your database in the catalog browser tree. Right-click your database and click Properties, then edit the Name to Show in Display field. New 2020-03-27
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Expensive Statements Trace Enhancement

When configuring expensive statements trace, you can now configure the following settings:

  • CPU Threshold

  • Memory Threshold

  • Table or View Filter

  • Store Trace Information

  • In-Memory Tracing Records

  • Trace Flush Interval

See Configure Tracing in the SAP HANA Database Explorer (SAP HANA Service Only).

Changed 2020-03-27
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Catalog Browser Enhancement When searching column views, use the new filter button to search for All column views, Calculation Views only, or Calculation Views and User-Defined Hierarchies. Changed 2020-03-27
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: SQL Console Enhancement he SQL Console page of the Global Preferences contains a new On error option, which allows you to control the behavior of the SQL console when it encounters a SQL error. Changed 2020-04-16
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Database Overview Enhancement The database Overview page now shows CPU Usage information. Changed 2020-04-16
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Smart Data Integration Enhancement

As part of an SDI task execution, you can now see the remote statements that were executed. Click on a task in the catalog browser to view the task's details, then click on either a completed execution or the specific partition of a completed execution and click the Remote Statements button to view remote statements for the task.

For more information about Smart Data Integration, see the SAP HANA Smart Data Integration and SAP HANA Smart Data Quality guide.

Changed 2020-04-16
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Add a Database With a Different User

When adding a cockpit database to the database explorer, you can now choose to enter a User and Password that is different than that provided in the cockpit for that database.

Moreover, once you've added a database to the database explorer, you can go back later and re-add it with different user credentials by right-clicking the database and clicking Add Database with Different User.

New 2020-05-28
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Tracing Enhancements

You can now configure performance tracing in the database explorer. Right-click your database, click Trace Configuration and select Performance Trace.

You can also refresh trace file contents by clicking the Refresh trace file button.

Changed 2020-05-28
SAP HANA Service Extension Suite - Development Efficiency Cloud Foundry Database Explorer: Import and Export Catalog Objects Enhancement

You can now import and export database objects from and to Amazon S3 and Azure.

For more information see Import Schemas, Tables, and Other Catalog Objects and Export Schemas, Tables, and Other Catalog Objects.

Changed 2020-07-08