

Hide SAP HANA Database Explorer Connections 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. 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. 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”. The three new buttons allow to open a file, save to the current file, and save to a different file (from left to right). This allows saving the content of the SQL console and loading it again at a later point in time. The SQL console now supports loading content from and saving content to files. Credentials stored in the SAP HANA user store must be maintained via the appropriate SAP HANA user store commands. The credentials cannot be changed via the SAP HANA Database Explorer Visual Studio Code extension. A notable platform that is not supported is macOS on Apple M1 processors. 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.Ĭonnecting via the SAP HANA user store requires the full SAP HANA client package to be installed, including the hdbuserstore executable.Īdditionally, SAP HANA user store connections are only available on platforms supported by the SAP HANA database client. Previously it was possible to add new local database connections by entering the connection data and credentials into the “Add Database” dialog. 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.

To show objects from other schemas the catalog browser offers a filtering option. The catalog browser now shows the list of objects per type.īy default, only objects from the current database user’s default schema are shown. In addition to some bug fixing and general improvements, the new version brings several noteworthy features. Today, version 1.4 of the extension has been released to the Visual Studio Code marketplace. This version included the database connection list and a SQL console for executing queries against a database. Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace.
