Tag Archives: sap hana certification training

SAP HANA Application Sectors


SAP HANA Cloud Platform comes with enormous features that enable real-time, secure applications required to succeed in today’s mobile, social and data driven world. Applications built with SAP HANA Cloud Platform support interfaces to enable integration with other cloud-based applications, such as those from SuccessFactors, an SAP company, to build loosely coupled applications that extend the value of SAP and non-SAP enterprise solutions, whether they are running on-premise or on the cloud platform. Different Application Sectors of SAP HANA:

Travel Risk Management

These days travelling has become dangerous and risk, due to growing number of crime rates. People who love to travel are stopping themselves, for the only reason that it is not safe. Travel businesses were unable to take care of safety of travellers, who take tour packages from them. This is true especially with government travel agencies. To address this issue, a new application was built using SAP HANA. The application easily helps businesses and government agencies with travel risk management. It helps travellers from sending alerts if they encounter something dangerous while they are on their travel. It also alerts travellers about danger areas, when they are about to get there. It helps the security stakeholders in companies by keeping track of their traveller’s locations and alerting them if trouble occurs.


Digital age calls financial institutions to stay up to date with the new and evolving business models for providing instant insights to decision makers. With SAP S/4 HANA Finance, Finance organizations can create a common view of all financial and operational data, provide flexible, easily consumable reporting and automate processes. They can instantly evaluate the financial implications of business options with real-time analytics, prediction, and simulation, all with a beautiful user experience.


For all HR processes, SAP HANA is a must. They can also connect with non-SAP HR core systems. SAP S/4 HANA will feature a simplified HR mini-master but no HR data management features so the HR data must be replicated from whatever HR system of record the customer chooses to use for example SAP Enterprise Resource Planning Human Capital Management (ERP HCM) or SuccessFactors Employee Central. This is similar in the way in which SAP ERP HCM and SAP ERP Finance and Controlling (FICO) integrate now, so for most of the  customers it’s not really a change; it just highlights that the HR data model can more easily and natively store data from Employee Central, which makes sense given that it is the next-generation core HR system from SAP.

Customer Engagement

Improve customer engagement at every stage of the buying cycle with new and innovative marketing software built on SAP HANA. It supports everything from real-time customer analytics to contextual marketing, and can help you deliver individualized marketing that will boost customer engagements and brand loyalty across all channels. Enable real-time marketing in the cloud or on- premise and use the latest technology to enhance your email, content, and digital marketing activities.

Call Centre Operations

With SAP HANA, you can improve call centre order management with a user-friendly business-to-employee application with a very low budget and with minimal up-front investment. You can expand the application usage to additional call centres, including those managed by the third parties. The SAP HANA Cloud Platform provides fast deployment and integration with existing SAP software systems. It provides robust data security and identity management tools. It also eases the upgradation, expansion to other areas of the business and Integration and interface with softphone devices.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-309-7846 or email  info@zarantech.com.

Important Areas Where SAP HANA is implemented


Business cases where SAP HANA proved its efficiency

The first of the HANA deployments were the business cases that required real time analytics. For example, DataMart and Data Warehouses. Because, the benefits are there right out the box. Enterprise Data Warehouse (EDW) like SAP BW can run very fast with a simple database swap.

With a transactional application like Finance or Supply Chain, most things run a little better from a simple database swap (SAP claim 50% faster for their own core finance). The real benefits come when logic from the applications are optimized and pushed down to the database level, from simplification of the apps (SAP is building a simplified version of their Business Suite), or from ancillary benefits like real-time operational reporting, real-time supply chain management or real-time offer management.

Most importantly, unlike the other database systems in the market, HANA supports all applications on the same instance of data, at the same time.  Now, you can get rid of traditional copying, transforming and re-organizing data all over the enterprise to meet the needs of different applications. HANA perfectly serves the needs of all applications with one “system of record” instance.

What SAP Applications run on SAP HANA?

SAP CEO Bill McDermott says, ‘’HANA is attached to everything we have.’’

Today, all the major SAP Applications run on the SAP HANA platform. They include the SAP Business Suite (ERP, CRM, PLM, and SCM) and the SAP BW Data Warehouse.

The SAP HANA platform is designed to support the BI Suite which includes Business Objects Enterprise, Data Services and SAP Lumira.

SAP HANA powers a complete set of applications such as SAP Accelerated Trade Promotion Planning, SAP Collection Insight, SAP Convergent Pricing Simulation, SAP Customer Engagement Intelligence, SAP Demand Signal Management, SAP Assurance and Compliance Software, SAP Liquidity Risk Management, SAP Operational Process Intelligence and SAP Tax Declaration Framework for Brazil.

The cloud portfolio of SAP runs on HANA, along with the HANA Cloud Platform and SAP Business ByDesign. The latest set of apps which are on the verge of getting migrated to the HANA platform include Ariba and SuccessFactors Apps.Who should consider using SAP HANA?

An organization should strongly consider implementing SAP HANA, if:

  • There are few reports or analytic applications that are currently running very slowly and not getting the optimal business benefit.
  • They are constantly facing unacceptable downtimes, where your data warehouse is not available due to the need to load data.
  • They are in need to see current, till-the-moment data.
  • There is a frequent need to create new reports or analytical applications.

Even if organizations do not see a requirement for SAP HANA at this moment, they could still benefit from it, with a very thought of using it in the near future If they just go to their sales representatives of Oracle, or IBM, or Microsoft, and tell them that they are in the endeavour of migrating to HANA in the near future, they will be offered with a competitive price on licenses and also free maintenance of your current database. With this trend, it seems like soon most of the organizations will migrate to SAP HANA in the near future.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

The Future of SAP HANA


In this age of digitization, it became important and necessary for SAP, the premium ERP software to come up with the next generation business suite, and that is SAP HANA. In 2011, HANA (High performance Analytics Appliance) was available as in-memory computing database. The HANA database was used to power SAP BW to make analytical real-time reporting and reduce latency in the next year. In 2013, SAP HANA cloud services were introduced to power the SAP Business Suite. The S/4 HANA was released towards the end of 2015 and provided extremely user friendly User Experience (UX), simplified data models and a variety of cloud deployment options such as Public Cloud, On-Premise or Hybrid Cloud.

SAP has simplified their data structures with most of the database tables in columnar store and elimination of row store. This has resulted in dramatic increase in performance and faster results when running reports. SAP Fiori UX is the new user experience of SAP to business users for all lines of business across devices and deployments. The design is based on role-based, responsive, simple, coherent and delightful. The SAP S/4 HANA Cloud Platform is the solution for the Internet of Things (IoT) and provides the data driven intelligence business where the devices or machines will be connected by sensors. SAP S/4 HANA is very easy to adopt with quicker implementation cycles.

As we are entering into the middle of the year 2016, predictions for S/4 HANA is very clear – more HANA, more analytics. The Cloud for Analytics is a combo of Business Intelligence (BI), planning, budgeting, and predictive analytics. S/4 HANA is expected to bring more project systems, quality management, and sales and distribution functionality. The Hybris tools for the “Simplified Front Office” will usually become available including Hybris Profile and Hybris Customer Experience. The Cloud for Analytics in 2016 is predicted to have the power of broadened predictive analytics capabilities, scaled out modelling and what/if analysis for planning.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

SAP HANA Skills Required in Future


Vowing to the efficiency of processing huge business data in a few seconds, SAP HANA is becoming the most sought after Database Management System (DBMS) for most of the companies today. A lot of companies that use ERP systems that come from SAP, are finding HANA very compatible. Thus, companies who are using SAP functional tools are plugging in HANA. As a result, the jobs in HANA are increasing.

On the same note, the in-memory architecture and efficiency of SAP HANA has drawn attention of Fortune 500 companies who are handling enormous data on a daily basis. The growth curve of installation and usage of HANA is rising. Henceforth, the technology has become one of the hottest trends in the current job market.

Some of the top companies that have switched over to SAP HANA are Asian Paints, Mercedes-AMG, Vodafone, EMC, eBay, Colgate Palmolive, Coca-Cola, Accenture, SanDisk, Unilever, Lenovo, Infosys, Cisco and many more.

Now, these companies certainly need HANA experts. The most popular jobs in SAP HANA include, SAP HANA DB Admin, SAP HANA Modeler and SAP HANA Application Developer.

SAP HANA DB Admin: As a SAP HANA Database Administrator, an individual generally does HANA installation, upgrades, configuration, performance optimization, backup and recovery and replication process. The employers expect the prospective candidate to know and be aware of some of these tasks.

SAP HANA Modeler: A SAP HANA Modeler should have an idea about different data provisioning methods that are available to fetch data from different sources to SAP HANA, build information models (modelling objects) based on business requirements, Performance tuning, Data Security, Different Reporting tools that can connect to SAP HANA and much more.

SAP HANA Application Developer: For a developer role, there are no such fixed tasks. It would depend on the nature of the project development and in which area the developer is working. It could be a functionality, design by ABAP, or some application development with Java, could be user experience design that is a UI deign by JQuery, HTML5, CSS etc. After the introduction of HANA Cloud, even a professional with developer role would get an opportunity to find work related cloud application deployment.

As SAP HANA is making technological advancements, the area of SAP HANA is becoming vast with Cloud being introduced, the concept of Internet of Things (iOT) coming up, and beginning of apps development for iOT. Henceforth, there several works would open up for the role of developers.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

Overview of SAP HANA

what-is-sap-hanaWhat is SAP HANA?

SAP HANA is a data platform with in-built memory marketed by SAP SE. SAP HANA is deployable in the cloud. It is a progressive platform that is most suitable for performing real-time analytics and developing and deploying real-time applications. SAP HANA is an evolution in the field of database, which has happened over a period of more than 30 years, with constant enhancements, research and development. It supports the build of those applications, which are not supported by any regular RDBMS. It also helps renewal of existing applications like SAP Business Suite.

Why did SAP build a database?

With traditional data processing and ordinary database and application platform, when the large or complex data was getting too difficult to manage challenges such as analysis, capture, data curation, search, sharing, storage, transfer, visualization, querying, updating and information privacy emerged.

Believing that if a database is built with a zero response time, then the business applications would be written in a unique manner so that the IT landscapes can be simplified, SAP built a database.

SAP has been providing business applications for years. It was clear that none of the incumbent software vendors like Oracle would write such a database and application platform. That is when they decided to build their own. When SAP went to build HANA, they also realized that the next generation of business applications would require a much more integrated approach than in the past.

What makes SAP HANA different from other Database Management System (DBMS)?

SAP HANA is different by design. It stores all data in-memory, in columnar format and in a compressed manner. Because HANA is fast, and does not require sums, indexes, materialized views and aggregates, it reduces the database footprint by 95%. Everything is calculated on-demand, as and when needed, in the main memory.  This makes it possible for companies run OLTP and analytic applications on the same instance at the same time, thus allowing any type of real-time and adhoc queries.

Advantages of SAP HANA

Works well with data of all sizes: Being exclusively build for complex business applications, HANA deploys data of all sizes and whilst they vary, there are a few common themes as well.

Reduction in Total Cost of Ownership (TCO): In many cases, HANA has a lower TCO. Hardware renewal costs get reduced, eases valuable enterprise storage and mainframes, and the maintenance is also low.

Complex to simple:  HANA simplifies landscapes by using the same copy of dataset for multiple applications, and adding additional dataset to SAP HANA is quick and easy, delivering business benefits faster.

Differentiation: The combination of HANA’s performance, advanced analytics (Predictive, Geospatial, and Text analytics) and simplicity, offer companies for changing their business process for making it stand out from that of the competitors. Customer-oriented programs like loyalty management and personalized recommendations become easy with SAP HANA.

Risk Mitigation: Many customers know how in-memory technologies are changing the world. So they want to put an application like SAP BW on HANA or LOB Datamart as a first step, so that they can quickly take an action for meeting the business demands.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

Attend a Live WEBINAR about SAP HANA 1.0 Training on July 06, 2016 @7:30 p.m. CST


Time : Wednesday July 06, 2016 @ 7:30 p.m. CST

You are most welcome to join our upcoming batch, details of the same are as follows:

Attend a Live Demo Session Sign up for SAP HANA Webinar
Batch Start Date : July 08, 2016 @ 07:30 p.m. CST
For More Information
SAP HANA Course Details
Class Schedule : Mon-Wed-Fri@ 7:30 p.m. CST, 3 hrs each session 

Contact : Kavya @ 515-309-7846 , Email : kavya@zarantech.com

Demo by Trainer Rahul

Attend a Free Live WEBINAR about SAP HANA 1.0 Training on July 06, 2016 @7:30 p.m. CST. Register Link  – http://goo.gl/BMkz6k

Attend a Live WEBINAR about SAP HANA 1.0 Training on May 26, 2016 @7:30 p.m. CST


Time : Thursday May 26, 2016 @ 7:30 p.m. CST

You are most welcome to join our upcoming batch, details of the same are as follows:

Attend a Live Demo Session Sign up for SAP HANA Webinar
Batch Start Date : May 31, 2016 @ 07:30 p.m. CST
For More Information
SAP HANA Course Details
Class Schedule : Tue-Thu-Sat@ 7:30 p.m. CST, 3 hrs each session 

Contact : Kavya @ 515-309-7846 , Email : kavya@zarantech.com

Demo by Trainer Eliaz

Attend a Free Live WEBINAR about SAP HANA 1.0 Training on May 26, 2016 @7:30 p.m. CST. Register Link  – http://goo.gl/BMkz6k

SAP HANA Interview Questions and Answers you must prepare for in 2016


HANA is a revolutionary Relational Database Management System developed by SAP. Its column based search for data retrieval saves memory and results into reporting twice as fast as traditional databases. While SAP HANA Certification has gained tremendous popularity, some of the significant SAP HANA interview questions you should be aware of are –

  1. What are some tasks performed by Modeling Studio?
    • Check database tables and retrieve META DATA
    • Monitoring data transfer from SAPM Business Warehouse to other systems
    • Schedule data replication jobs
    • Utilize data services for modeling
  1. What is Latency?
    The total stretch of time consumed to replicate data from source system to target system is calculated as Latency.
  1. What is Row based and Column based approach?
    The database table is populated in the sequence of rows. Relational databases till now have been following Row based approach. On the contrary, Column based approach has tables being populated in sequence of columns occupying all contiguous memory locations.  HANA supports both but is optimized more for Column approach.
  1. What is SLT? How do you configure it?
    It stands for SAP Landscape Transformation. It triggers replication of data from source to target system where either of the two ends has to be SAP HANA.
    The configuration is performed in the Configuration & Monitoring dashboard using t-code LTR.
  1. What are the prerequisites to configure SLT?
    For SAP source systems – The role IUUC_REPL_REMOTE is assigned to the RFC user
    DMIS add-on has to be installed in the SLT system.For non-SAP systems – DMIS is not essential here. A database user can be authorized to perform replication activities.
  1. What are the different Replication techniques?
    • Trigger based replication using SLT
    • ETL based replication using BODS
    • Extractor data acquisition using DXC
  1. What are Transformation rules?
    These are the rules defined in the Advanced Replication Settings such that the data for the source tables is transformed during replication process.Fill Empty Fields
    Convert Fields
    Skip Records
  1. What factors affect the change in number of jobs?
    Number of Jobs depends upon the following –

    • The number of tables to be replicated
    • Number of configurations managed in SLT system
    • Initial Load speed
    • Expected Replication Latency time
  1. What are the different scenarios in Replication?
    Load – Starts the initial load of replication of data from the source system. It is a one-time process.
    Replicate – Actual phase of replication. Database triggers and different logging tables for every table is created in SLT.
    Stop – Stops any replication currently in process. Database triggers are aborted.
    Suspend – Table replication is paused. Database trigger will not be deleted and changes will be filled in logging tables.
    Resume – Restarts the replication for a suspended table.
  1. What is the maximum table name length and the Max number of columns allowed?
    Max table name length – 127 characters
    Max no of columns – 1000All geared up for a career in SAP HANA? Stay tuned and keep updated with more insights.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

How to start preparing for SAP HANA Certification

Ever since its inception 5 years ago, SAP HANA has successfully become the epicenter of all tech talks. Anticipated as the finest technology invention of these times, HANA promises a lucrative stint at business reporting and thus calls for a plethora of opportunities for beginners as well as professional technical consultants.

Preparing for HANA certification can be cumbersome affair if not executed appropriately. Right from initial research to appearing for the exam, it is necessary to cover everything completely.    


Know what HANA is

Certification is an expensive affair and plunging at it with no clear objective could delve you into more confusion. It’s better to gain a high level understanding of what HANA is all about. What is so unique about this database approach, its career scope and scalability are some areas you should do your homework. Talk to a reliable SAP HANA course provider or an experienced HANA consultant. You’ll surely earn some valuable feeds.

Plan for prerequisites

Depending entirely upon the course and the certification preparation is a task half-done especially when you have some experience in SAP. Hands on working knowledge of BO, BW and ABAP could be useful. Check within your organization if you can have some opportunity for performing some real time developments upon these.
Beginners can reboot their basic SQL skills with clear focus on Relational databases.

Decide upon your expertise

Earlier a common SAP HANA certification C_HANAIMP_10 was hosted for Associate Consultants. Now, a diversification has 2 different certification exams – C_HANAIMP_1 for Application Consultants and C_HANATEC_1 FOR Technical Consultants. Based on prior experience, SAP Functional Consultants should opt for C_HANAINP_1.

Not just passing the cut-off!

SAP Certification exams usually focus more on in detailed conceptual ability. Mastering theoretical syllabus can help clear the exam but the ultimate objective is to utilize the opportunity with a long term vision. Hunt for an institute that lets you perform a real time full scale implementation project. This will nourish your skills and the overall problem solving ability.

The right institute

SAP HANA is a trending course and institutes of all scales try to capitalize it. Opt for an institute that offers complete training. Compare the syllabus from the SAP training shop and be aware if any gaps exist. Also, e-learning should be a preferred choice and a full scale project is must.  Check for the institute’s website and look for relevant blogs, whitepapers etc that reflect their expertise in the domain.

Appropriate planning and undying hard work can weave a substantial career in HANA. Don’t just join the flock and do your research for an effective plan. Gear up and act wisely, HANA is a promising way.

Stay tuned for more valuable insights.

For SAP HANA Training needs, Visit http://www.zarantech.com/course-list/sap/SAP-HANA. Call 515-978-9042 or email  kavya@zarantech.com.

Attend a Live WEBINAR about SAP HANA 1.0 Training on Apr 06, 2016 @7:30 p.m. CST


Time : Wednesday Apr 06, 2016 @ 7:30 p.m. CST

You are most welcome to join our upcoming batch, details of the same are as follows:

Attend a Live Demo Session Sign up for SAP HANA Webinar
Batch Start Date : Apr 11, 2016 @ 07:30 p.m. CST
For More Information
SAP HANA Course Details
Class Schedule : Mon-Wed-Fri @ 7:30 p.m. CST, 3 hrs each session 

Contact : Kavya @ 515-309-7846 , Email : kavya@zarantech.com

Demo by Trainer Santhosh

Attend a Free Live WEBINAR about SAP HANA 1.0 Training on April 06, 2016 @7:30 p.m. CST. Register Link  – http://goo.gl/BMkz6k