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
SAP HANA Articles
Page 47 of 58
Handling user requests for applications based on HANA system
It consists of various components as mentioned above for processing of SQL statements from application users hosted on the top of HANA system.User requests via user interface/web browsers are sent to Web server hosting application which is communicated to SQL/MDX Processor in form of SQL queries. These are further segregated to different data engines in Index server according to query types.Session and Transaction Manager authorize SQL transactions and keep track of all the transactions either completed or running in the system.
Read MoreExecuting a SQL query in SAP HANA Studio
To run the query, click on green arrow button on top right corner or press F8.
Read MoreUse 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 More