SAP Hana Frequently Asked Questions Find out all available sap hana answers
Learn about sap hana step by step, with frequently asked questions
This site compiles all available Sap Hana Questions that can be found. Reading questions and answers will help towards getting an understanding of what is sap hana about. It is constantly updated with new questions and answers in order to keep uptodate a true sap hana knowledge content.
Let's Discover sap hana a different way, with questions and answers. It is a very useful introduction to sap hana as FAQ would be covering part of the theoretical aspects of sap hana courses anyone could enroled to.
This Hana Frequently Asked Questions section is a starting point to find out what is Sap Hana all about.
It is also giving an overview of what type of Hana administration subjects people are generally looking for.
It is offering quick help and also valuable information on Sap Hana Server, Hana Studio and hana cockpit without going through long inquiries.
Most common hana issues are raised and answered on various organized topics.
Sap hana is an in-memory database which is made of an application Server, a SAP database software, a storage, and a networking hardware. It is designed for real-time analytic but also transactional processing. It is running on specific and certified linux servers. It can be either delivered as a pre-installed package by the certified hardware manufacturer or it can be built according to client business requirements.
What is the best way to manage, operate, and monitor sap hana systems ?
Sap Hana is a young database with interesting features. First of all Sap Hana is a in-memory database. It is accessible for administration via various channels. Directly from the Server, It is not the most convenient method but you can use hdbsql to manage databases. With the web based interface Hana cockpit you can browse and manage sap hana environments. The Client Hana Studio is the most complete tool to administer Sap Hana but it has to be physically installed and therefore is dependent of the client hardware.
While tool interface is very good for monitoring, analyzing and setting parameters. When it comes to schema, Object development and implementation, Scripts and SQL are better in comparison to tool interface.
It is easier to debug, update and recreate that way. It is better to write SQL table script than going through the hana studio interface.
A Sap hana database user is protected in the first place with a password. However, a password is very often required at the command line in order to connect and execute a batch or an SQL script. The user name and password are then visible to anyone. In order to avoid that situation, it is possible to create a special key in relation to a particular user.
User name and password are then invisible via the use of that key.
A successful Sap Hana installation requires serious preparation at operating system level, memory allocation level and disk space allocation level. Although, only a certified person is eligible to perform an sap hana installation, it is very easy to follow step by step a complete sap hana installation procedure.
Sap hana studio is a java based multitasks tool that can be downloaded from various sites. Various plugin can be attached to hana studio. The main one is the sap hana administration plugin from which you can manage the entire hana system. Sql Console and Data modeller are also other standard plugins.
It is a client Eclipse based software. It can be obtained from SAP Software Download Center or from the eclipse site.
Hana studio is a complete Administration and Development tool for SAP HANA. There are various good tutorials available on the web. From those sites you will be able to learn about sap hana architecture but also you will get opportunities to get hands-on sap hana administration and hana development if you have access to a hana server.
Sap hana hdbsql is a command line tool. It is executed at the operating system level. It is possible to perform all sort of administration tasks with it. Hana backup via a scheduler would be essentially performed at that level.
It is very important to prepare a proper backup and recovery plan for all hana databases. Sap hana Data size can become extremely important. Therefore a good backup strategy is to be put in place. As regards hana recovery procedures, it is essentiel to cover and prepare for all possible scenarios.
A user has to be assigned the necessary privileges in order to work with sap hana database. Predefined privileges are available and ready to be granted to specific users such as Operation-users, Monitoring-User, backup-user.
Using roles is the best way to manage authorizations. Roles are entities which allow you to group privileges under the same roof. You can assign a single group of privileges to specific users without the need to apply multitude of authorizations.
Like any other database, sap hana could suffer from low performance at one stage. It is therefore important to have a monitoring strategy in place in order to catch any performance issues. Reasons for slow performance are known and advices are available.
Sap hana configuration is spread among differents sap hana parameter files. You can visualized and modify hana configuration via the common hana studio interface. It is the safier and easiest way to change any sap hana parameters. Alternatively, sql commands via hdbsql can be executed to update configurations.
Sap hana bug and errors will generate errors. They are also called Sap Alert Messages. They are known from sap and can be treated reasonably well via sap notes. In order to access the sap hana resolution and the sap hana investigation description, you have to be registered for sap support. Alternatively it is possible to find free solutions on the web.
Hana administration requires a very good understanding of sap hana architecture. The advice is to get to know sap hana before adventuring into the administration section. There are several ways to learn about sap hana. Before booking for a very expensive sap hana course, you have a number of options available. Find out whether you company has a sap hana test bench installed and ask to get access to it. Go on to a free online tutorial site., Install and use a free sap hana version. The sap hana express edition.
Knowing Sap hana Inside out
NB : If you want to access and read the Sap Notes you have to be registered for SAP SUPPORT.