In SAP HANA system, there are many tools that can be used to manage application development in HANA XS Service Classic model and Advance model. You can provide administering and support services to XS service model or you can also perform development under SAP HANA system.

HANA XS Application service includes tools available under SAP HANA XS Administration Cockpit or you can also use SAP HANA Studio to maintain application development under HANA XS service.

Following are the various roles that exist under SAP HANA system to manage XS Application Service.

HTTPDestAdministrator

Full access to the details of HTTP destination configurations (display and edit).

HTTPDestViewer

Read-only access to HTTP destination configurations, which are used to specify connection details for outbound connections. For example, using the server-side JavaScript Connectivity API that is included with SAP HANA XS.

RuntimeConfAdministrator

Full access to the configuration settings for SAP HANA XS application security and related user-authentication providers.

RuntimeConfViewer

Read-only access to the configuration settings for SAP HANA XS application security and related user-authentication providers. For example, SAML or X509.

SAP 43

There are various roles that exist in SAP HANA system to manage HANA XS Application Service as shown in the above screenshot.

XS Service Tools Under SAP HANA Cockpit

In SAP HANA Cockpit, there are various tools that you can use to maintain HANA XS Service. They are web-based tool that allows you to configure and maintain the basic administration-related elements of the application-development process and environment.

sap 77

XS Artifact Administration

This is used to maintain runtime configurations for individual applications or a complete application hierarchy.

XS Job Dashboard

This is used to monitor and maintain SAP HANA XS job schedules defined using the XS job syntax.

Trust Manager

This is used to maintain certificates which are used to establish trust relationships between servers used by SAP HANA XS applications.

SMTP Configuration

This tile is used to define the details of SMTP server that is available for use by all applications running on an SAP HANA XS server.

User Self-service Tool

This tile provides the set of tools that allows to maintain self-service requests and administrate the self-service tools by the users.

How to View Configuration Parameters for SAP HANA XS Engine in HANA Studio?

To view the configuration details of HANA XS Engine in HANA Studio, double-click HANA system in the system view pane. Navigate to Configuration tab.

sap 78

Navigate to xsengine.ini file under the configuration tab and expand the folder. You can view the various configuration parameters as shown in the following screenshot.

sap 79

Application_container

This contains list of all the applications trusted by XS Engine.

Communication

This contains application-related connection requests and configuration.

Customer_usage

This defines customer specific usage details for HANA application service.

Debugger

This is used to manage debugger settings.

Httpserver

This provides SAP HANA XS Web Server details. Other options under xsengine.ini is used to define SAP HANA XS application service configuration.

SAP HANA Admin – Data Provisioning

SAP HANA Replication allows the migration of data from source systems to SAP HANA database. A simple way to move data from the existing SAP system to HANA is by using various data replication techniques.

System replication can be set up on the console via command line or by using HANA studio. The primary ECC or transaction systems can stay online during this process. There are three types of data replication methods in HANA system −

SAP LT Replication method
ETL tool SAP Business Object Data Service (BODS) method
Direct Extractor Connection method (DXC)

SAP LT Replication Method

SAP Landscape Transformation (SLT) Replication is a trigger-based data replication method in HANA system. It is a perfect solution for replicating real-time data or schedulebased replication from SAP and non-SAP sources. It has SAP LT Replication server, which takes care of all trigger requests. Replication server can be installed as a standalone server or can run on any SAP system with SAP NW 7.02 or above.

There is a trusted RFC connection between HANA DB and ECC transaction system, which enables trigger-based data replication in HANA system environment.

ETL SAP Data Services Replication

SAP HANA ETL based replication uses SAP Data Services to migrate data from SAP or nonSAP source system to target HANA database. BODS system is an ETL tool used to extract, transform, and load data from the source system to the target system.

It enables to read the business data at the Application layer. You need to define data flows in Data Services, scheduling a replication job, and defining the source and the target system in data store in Data Services designer.

Direct Extractor Connection Method (DXC)

Direct Extractor Connection data replication reuses the existing extraction, transformation, and load mechanism built into SAP Business Suite systems via a simple HTTP(S) connection to SAP HANA. It is a batch-driven data replication technique. It is considered as a method for extraction, transformation, and load with limited capabilities for data extraction.

DXC is a batch-driven process and data extraction using DXC at certain interval is enough in many cases. You can set an interval when batch job executes, for example, every 20 minutes. In most of the cases it is sufficient to extract data using these batch jobs at certain time intervals.

You can check complete details about Data Provisioning in our SAP HANA course.

So, this brings us to the end of blog. This Tecklearn ‘HANA XS Application Service and Data Provisioning in SAP Hana’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

516