Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP HANA Articles
Page 55 of 58
Use of SAP Host Agent in SAP HANA
To manage software updates and patch management in HANA system environment, you should install SAP Host Agent on all the machines that are part of SAP system landscape. SAP Host Agent is used by Software Update Manager to install the software patches on all the component servers in your system landscape.
Read MoreUsing LM Structure in SAP HANA environment
LM structure in SAP HANA system landscape is used to manage installation details of all the components under HANA. LM structure information helps to manage software updates and patches. The information with LM structure is used by Software Update Manager SUM to install the software updates and new releases in HANA environment.
Read MoreUse of SAP HANA Repository to maintain objects
This is used to update versions of HANA Studio to newer versions. Studio Repository maintains the code to perform updates for HANA Studio.All the objects that you develop are maintained in Packages which are maintained under SAP HANA Repository. These packages are arranged in the form of hierarchy to make them easy to understand and logical.
Read MoreDifferentiating between row and column store table in SAP HANA database
Yes, it is possible to differentiate between both the table types. When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a Row store table and Column store table.
Read MoreMaintaining password policy parameters in SAP HANA system
Note that actual parameter of password policy section is maintained by indexserver.ini system file. It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.
Read MoreChanges to indexserver.ini file auditable to maintain password policy in SAP HANA
It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.Note that direct changes to the indexserver.ini file cannot be audited.
Read MoreAdding system archive link in SAP HANA Studio
To allow users who work in the SAP HANA studio to connect efficiently to multiple SAP HANA systems, you can manage a list of all systems in a centrally-accessible archive. Users can then simply link to this archive.
Read MoreInformation exported using export system in SAP HANA Studio
When you use export option from main menu, it also exports the list of systems and their properties (name, description, host name, instance, and so on) is exported as an XML file to the specified location.
Read MoreInformation required to connect MS Excel to SAP HANA
Choose SAP HANA MDX Provider from this list to connect to any MDX data source → Enter HANA system details (server name, instance, user name and password) and you need to click on Test Connection → Connection succeeded → OKIt will give you the list of all packages in drop down list that are available in HANA system. You can choose an Information view → click Next → Select Pivot table/others → OK.
Read MoreFunctions of Index server in SAP HANA system
Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.Index Server also contains Persistence layer for scalability and restoration of the system. In case of system failure, power failure or database corruption, Persistence layer is responsible for the restoration of HANA system to last save point.When you are running complex and large calculations, and there is a system failure Persistence layer is used to ensure that transactions are either fully executed or complete ...
Read More