SAP HANA – Administration and Operations
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
High availability failover.
- Expanded OData support.
- 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 deﬁnition, 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-deﬁned functions. The SAP HANA SQLScript Editor has beneﬁted 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 deﬁne the appropriate access techniques for each deployed application package, including:
- Authentication method.
- Anonymous SQL connection enablement.
- Cache control.
- Cross-origin requests.
- 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 uniﬁed data model and user interface for end-to-end replication scenarios. It makes it much easier to create, develop, administer, and manage data provisioning workﬂows. SAP HANA open uniﬁed 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 proﬁles and assesses the quality of incoming data. Traditionally, ETL tasks have proven to be some of the more problematic areas of conﬁguring 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 oﬀering 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 conﬁgurable data generator. It’s also aligned with SAP HANA Academy educational content, and base for openSAP courses.
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 beneﬁt 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.
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.
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.
Managing SAP HANA applications content.
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 ﬁles 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 eﬀort and improves ﬂexibility 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 certiﬁcation 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 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.
The new and enriched SAP HANA data center management environment provides extended system management, visibility, and monitoring capabilities for more productive and eﬀective enterprise system administration. It oﬀers 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 ﬁle 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