Home / SAP Hana

SAP HANA – Administration and Operations

Rating: 4.0Blog-star
Views: 2575
by Ravindra Savaram
Last modified: August 10th 2020

Enterprises rely on their teams of software  developers and DBAs    to create the next generation of applications to properly leverage Big Data. SAP HANA SP6 supports these critical constituents with a collection of powerful capabilities aimed at increasing their effectiveness.

Simplified  predictive  application development

The application function modeler in SAP HANA studio presents model-driven access to native functions and predictive algorithms, which helps speed the software development process. Meanwhile, SAP HANA Extended Application Services (SAP HANA XS) provide a faster, more open, and highly flexible application and web server services supporting HTML5 and server-side JavaScript. This reduces TCO and development times, thanks to the minimized “layers” required to deploy applications. It also provides an enhanced architecture with a collection of essential capabilities such as:

High availability failover.

  • Expanded OData support.
  • Authentication.
  • Increased connectivity options.

New lighter-weight, browser-based IDEs for SAP  HANA  native development.

SAP HANA SP6 provides an easy integration between SAP HANA studio and SAP HANA repository. This lets developers browse design-time related  objects in the repository, as well as use context-sensitive menus to   perform the most regularly used commands related to the repository. A command line interface is available, too.

SAP HANA SQL has been expanded, with new statements for  access  control, data definition, and system management. There are also many new SQL functions to assist developers and DBAs. SP7 built on these changes, adding even more SQL statements and functions.

SAP HANA SP6 also expands on the database’s SQLScript capabilities, including ARRAY, APPLY_FILTER, column view parameter binding, and scalar user-defined functions. The SAP HANA SQLScript Editor has benefited from enrichments such as a wizard to create new procedures, aids for building templates, and noteworthy new debugging capabilities.

Developers and DBAs are now free to define the appropriate access techniques for each deployed application package, including:

  1. Authentication method.
  2. Anonymous SQL connection enablement.
  3. Cache control.
  4. Cross-origin requests.
  5. Default entry.

Integrated data provisioning and modeling

SAP HANA SP6 introduces the Data Provisioning Workbench. This is a new editor inside SAP HANA STUDIO that furnishes developers and DBAs with a common unified data model and user interface for end-to-end replication scenarios. It makes it much easier to create, develop, administer, and manage data provisioning workflows. SAP HANA open unified architecture supports administration and monitoring API Services for all Data Replication components.

Enhanced data services

SAP HANA SP6 supplies database administrators with a native extract, transform, load (ETL) solution that boosts performance, and an innovative, guided advisor that profiles and assesses the quality of incoming data. Traditionally, ETL tasks have proven to be some of the more problematic  areas of configuring a comprehensive  Big Data  environment. Consequently, by streamlining and simplifying this essential process, SAP lets  developers and DBAs  focus  on their main responsibilities  rather than    time-consuming ancillary tasks.

Embedded interactive education

SAP HANA interactive education is a pre-packaged, interactive learning offering consisting of business applications, data models, sample data and application code, and data generation tools. It serves as a source of best practice implementation examples, and accelerates development of quality customer and partner content. This approach augments the knowledge of developers and DBAs, while furnishing a baseline model for use in SAP educational materials that customers and partners can tap for self-study.

SAP HANA interactive education contains 17 models across 22 database tables, with scalable data record sizes via a configurable data generator. It’s also aligned with SAP HANA Academy educational content, and base for openSAP courses.

Checkout SAP HANA  Interview Questions

Enterprise-wide data modeling

SAP HANA, in concert with SAP® Sybase® PowerDesigner®, generates and shares the necessary metadata to drive end-to-end data modeling, from planning to implementation. This integration makes it possible for developers and DBAs to “close the loop” with complete visibility into the full range of the organization’s data. They can then build more comprehensive, and accurate, applications and reports.

More sophisticated monitoring

DBAs benefit from a collection of monitoring improvements to SAP HANA studio, such as additional visibility into the costs of statement execution, the ability to repeat SQL statement execution, and supplementary metrics and alerts of critical situations such as:

  • Savepoint duration.
  • Column-store unloads.
  • Status of Python trace.

Operational  improvements

Enterprises  are  increasingly relying on Big Data  to drive  critical    business decisions. This dependency demands a fresh look at key technology infrastructure, with a  particular emphasis  on reliability, security, and   high availability.

Streamlined configuration

The new SAP HANA Platform Lifecycle Manager incorporates the major functions of the Software Update Manager for SAP HANA, and streamlines major administrative tasks such as:

Integrating the SAP HANA system in the landscape.

Administering SAP HANA systems and  hosts.


Updating SAP HANA systems with single support packages as well as support package stacks.

Managing additional components.

Deploying products and transports.

The essential tasks of backup and recovery have also been improved through enhancements to the  backup editor — including the  Backup   Wizard — in SAP HANA studio. It’s now possible to view details about the most  recent successful backup, along with information about active backups. Administrators are able to delete old backups, as well as split data backups into files of limited size. They may also instruct the Recovery Wizard to ensure that all required log backups are available before starting the recovery process. Finally, it’s now possible to copy a database in a scale-out environment by using SAP HANA backup and recovery capabilities.

Enhanced disaster recovery

SAP HANA SP6 introduces new asynchronous and  asymmetrical  long- distance remote data center failover capabilities. This supports maximum data protection performance for disaster recovery across long geographic distances (>50 km) with enhanced system availability and recovery capabilities via Asynchronous System Replication (based on transactional sub-system). Additionally, it expands system availability and business continuity with near-zero downtime for upgrades, and patches targeted at disaster recovery systems. It also reduces effort and improves flexibility with enhanced system copies, with snapshot support and asymmetrical disaster recovery support systems. SAP HANA SP6 also extends its data center replication capabilities for upgraded system availability and business continuity.

Open hardware architecture for tailored data center integration

SAP has introduced an initiative to drive the availability and the openness of the SAP HANA platform. It includes tailored data center integration to provide customers the choice to integrate the SAP HANA platform with their existing network storage infrastructure.

Moreover, the new program will also involve the existing certification program for SAP HANA, which targets third-party tools such as business intelligence (BI), ETL and backup/recovery products.

In addition, SAP HANA SP6 concludes the pledged integration with Sybase Data Management technologies such as:

SAP Sybase ASE.
SAP Sybase IQ.
SAP Sybase Event Stream Processor (SAP Sybase ESP).
SAP Data Services.
SAP® Sybase® SQL Anywhere®.
SAP Sybase Replication Server.
SAP Sybase PowerDesigner.

Mobile  synchronization

Mobile devices are an increasingly popular method for capturing and working with enterprise data. The SAP Sybase SQL Anywhere mobile and embedded database now supports bi-directional synchronization with SAP HANA across wireless networks. This gives authorized users the ability to securely interact with their data on the device of their choice.

Explore SAP HANA Administration Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

System  management

The new and enriched SAP HANA data center management environment provides extended system management, visibility, and monitoring capabilities for more productive and effective enterprise system administration. It offers enhanced table distribution and partitioning management, for both scale out and scale up, along with tracing capabilities for high-performing, scalable systems. It also delivers a comprehensive collection of security improvements designed to safeguard information through:

Authentication mechanisms that now include SAML 2.0 and X.509 client certificates.
Encryption via automatic inclusion of the secure store file system  (SSFS) in backup and recovery.
Access  authorization  that covers validity  period, time zone, email address, and locale.
Additional privilege categories.
Password configuration directly through SAP HANA studio.  Supplementary audit logging capabilities for actions such as session disconnects, dropping tables, repository interaction, and backups/recoveries.
A secure internal credential repository that permits safe storage of credentials for outbound connections from SAP HANA applications.
Improved authentication and access control options for connections to remote data sources that will be presented as if they were stored in SAP HANA.
On the other hand, SP 7 incorporates additional security features, including SPNEGO support for SAP HANA XS
SAP Logon Ticket and SAP Assertion Ticket support
Flexibility around password changes
The ability to set a validity period for a user in SAP HANA Studio. The ability to create users by copying existing users
New privileges for repository change management, debugging SQLScript code, and smart data access
Support for SAP’s new cryptographic library, CommonCryptoLib SSL support for system replication

About Author

NameRavindra Savaram
Author Bio


Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.