What’s New in SAP HANA 2.0 SPS 01 smart data access
This blog will cover the SAP HANA smart data access (SDA) highlights of the SAP HANA 2.0 SPS 01 release. New with this release is support for the export/import of virtual tables, enhancements to the SAP HANA smart data access cockpit tile, release of the new linked database feature, and enhancements to our Hadoop integration.
Export/import of virtual tables
The new export/import of virtual tables feature will give our users the ability to transport virtual table metadata between DEV/QA/PROD system landscapes, meaning that virtual tables no longer have to be created in all environments manually.
Image 1: Export/import of virtual tables
The transportation workflow is greatly simplified and users have the option to RENAME REMOTE OBJECT to easily connect to a new productive remote source. To transport virtual tables from one system to another follow these steps:
- Export the virtual table schema into directory “/tmp/” in the source system
- Create the remote source in the target system before importing the virtual tables
- Run the IMPORT function in the target system*
* To change the location or name of the remote object, use the RENAME REMOTE OBJECT function when importing the virtual table schema
Please note that the RENAME REMOTE OBJECT option is intended to change the database name and the schema name of the remote location, but not the remote object itself.
Cockpit tile enhancement
New with SAP HANA 2.0 SPS 01 is a count of running statements and active connections right in the overview SAP HANA smart data access tile.
Image 2: SAP HANA smart data access cockpit tile
By clicking on the running statements view or active connections view, users will be able to see what remote statements are running or have recently ran, as well as monitor remote connections and their status.
The new linked database feature allows users to directly access remote tables and views without having to manually define virtual tables. Once the remote source is added users will have the ability to perform DML queries directly against remote tables using three part names (remote_source.schema.table). To query the remote source, users will need to be granted the LINKED DATABASE privilege. Currently this feature is only supported for SDA connections from SAP HANA to SAP HANA.
In the Hadoop integration space, we have added a few notable enhancements for this release. We have extended DLM support by adding support for synonyms (.hdbsynonym) for declaring remote destinations using CDS, we have enabled data movement from SAP HANA extended tables to Hadoop, as well as added support for different file formats in Hadoop.
Image 3: SAP HANA Hadoop integration overview
Additionally, we now support SAP Cloud Platform Big Data Services (formerly Altiscale) for connections with the SAP HANA Spark Controller 2.1. Lastly, we have enabled support for inserts into SAP Vora tables for connections via the SAP Vora adapter. For more information on SAP HANA Hadoop connectivity please refer to the SAP HANA administration guide.