Skip to Content
Technical Articles
Author's profile photo Jonathan Bregler

What’s New in the SAP HANA Database Explorer Visual Studio Code Extension

Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. This version included the database connection list and a SQL console for executing queries against a database.

What’s New?

Today, version 1.4 of the extension has been released to the Visual Studio Code marketplace. In addition to some bug fixing and general improvements, the new version brings several noteworthy features.

Catalog Browser

The catalog browser now shows the list of objects per type.

Catalog%20Browser

By default, only objects from the current database user’s default schema are shown. To show objects from other schemas the catalog browser offers a filtering option.

To filter the objects in the catalog browser (or even the list of databases for that matter) you can use the standard Visual Studio Code document tree filtering feature.

SAP HANA User Store Connections

Previously it was possible to add new local database connections by entering the connection data and credentials into the “Add Database” dialog.

To prevent double maintenance of credentials it is now possible to add local database connections that use credentials maintained in the SAP HANA user store.

Note!

Connecting via the SAP HANA user store requires the full SAP HANA client package to be installed, including the hdbuserstore executable.

Note!

Additionally, SAP HANA user store connections are only available on platforms supported by the SAP HANA database client. A notable platform that is not supported is macOS on Apple M1 processors.

Note!

The credentials cannot be changed via the SAP HANA Database Explorer Visual Studio Code extension. Credentials stored in the SAP HANA user store must be maintained via the appropriate SAP HANA user store commands.

SQL Console File Support

The SQL console now supports loading content from and saving content to files. This allows saving the content of the SQL console and loading it again at a later point in time.

The three new buttons allow to open a file, save to the current file, and save to a different file (from left to right).

If a file is opened in the SQL console the title of the SQL console tab is changed to the file name from the default “SQL Console”.

Open SAP HANA Database Explorer

Since the web-based version of SAP HANA Database Explorer offers much more functionality it can be necessary to perform an action in the web-based version. To make switching between the versions easier it is now possible to directly jump to a database in the web-based version from each SAP HANA Database Explorer connection in the database list.

 

Hide SAP HANA Database Explorer Connections

If no connection to SAP HANA Database Explorer connections in the cloud is required, the connections can now be hidden via the setting “SAP HANA Database Explorer” > “Show Database Explorer Connections”.

 


Stay tuned for more exciting new features in future releases!

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Lars Hvam
      Lars Hvam

      Hi,

      According to the license, https://marketplace.visualstudio.com/items/SAPSE.hana-database-explorer/license, it is not allowed to do

      mass data extraction from an SAP product to a non-SAP product

      And vscode is a non-SAP product, as a user, how is it possible to get a license to use the extension? And

      This Developer Agreement is the complete agreement for the API and Tools licensed (including reference to information/documentation contained in a URL). This Developer Agreement supersedes all prior or contemporaneous agreements or representations with regards to the subject matter of this Developer Agreement.