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 46 of 58
Default location for installation of SAP HANA Studio
You can install SAP HANA studio on Linux platform without Root user. In Windows platform, you can perform the installation without administration rights but it will be available only to the user who has installed it.Default Location on Window Platform: C:\Program Files\sap\hdbstudioDefault installation Location under MAC OS: /Applications/sap/hdbstudio (old) or /Applications/sap/hdbstudio.app (new)Default installation Linux x86 64 bit: /usr/sap/hdbstudio
Read MoreUsing TCP/IP ports for accessing SAP HANA database
To access HANA system on client tools, you need to open different ports to database for these clients. These ports refer to different servers and application service in HANA system.
Read MoreSQL Operation supported in SAP HANA SPS06 SDA
With use of SAP HANA SPS06 Smart Data Access, you can only perform SELECT operation on virtual tables moved using new remote data source.
Read MoreSQL Operation supported in SAP HANA SPS07 SDA
With use of SAP HANA SPS06 Smart Data Access, you can only perform Select, Insert, Update and Delete operation on virtual tables moved using new remote data source.
Read MoreUpdating configuration property file in SAP HANA Remote source
Note that while modifying or creating the property configuration file, only the property which is different from default value needs to be set. The mistake in property configuration file may result in incorrect action or result of data source.
Read MoreUsing different Engine types in SAP HANA
It will use both OLAP and Join engine. The join between the FACT and DIM will be executed in the OLAP engine and joins inside the attribute views will be executed in the JOIN engine so both the engines will be used.
Read MoreHandling failed transactions in SAP HANA system
In SAP HANA system, Session and Transaction Manager is responsible to keep track of all the executed transactions in HANA database. It includes both running transactions and closed transaction. When a transaction in HANA system is failed due to any reason, Transaction Manager informs corresponding engine to handle the error.Session Manager is responsible to manage open and closed sessions and to authorize all the transactions executed in HANA db.
Read MorePerforming text data analysis and Search capability in SAP HANA
Preprocessor server provides text data analysis and search capabilities in HANA system. Preprocessor server is used by Index search to analyze the text data and to perform any search on the text data. This server is used to extract the information based on text search capabilities in HANA 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 More