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 14 of 58
Trusted RFC connection in SAP system
A trusted RFC connection is used to define Remote Function Call (RFC Connection) between two systems. By creating a trusted RFC connection between two systems, it allows you to create a trusted-trusting relationship between systems wherein, you can communicate and exchange information and data.To create a new trusted RFC connection, you can use T-Code − SM59. There are different RFC connections supported as per requirement.Click on the 3rd icon to open a new connection wizard → click on Create button and a new window will open.
Read MoreEmbedded BW parameters for SAP HANA
To setup the following Parameters in BW Using Program SAP_RSADMIN_MAINTAIN or you can also use T-code SE38 or SA38PSA_TO_HDB_DESTINATION − This parameter defines that where we need to move the Incoming dataPSA_TO_HDB_SCHEMA − This parameter is used to define which schema the replicated data will be assigned to.PSA_TO_HDB − GLOBAL − This parameter is used to replicate all data source to SAP HANASYSTEM − This parameter is used to specify clients to use DXC replicationDATASOURCE − This is used to specify the Data Source usedPSA_TO_HDB_DATASOURCETABLE − This parameter is used to provide the table name which are having list of ...
Read MoreEnabling Web dispatcher in SAP HANA Studio
To enable SAP Web dispatcher, you have to change Instance Value 0 to 1 in sapwebdisp in SAP HANA Studio → Configuration tab. This will enable ICM Web dispatcher and it uses ICM Method to load or read the data from SAP HANA system. Note that this method of data load supports large volume of data.
Read MoreUsing Delivery unit in SAP HANA
In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit
Read MoreRole Required to use LCM in SAP HANA
In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit
Read MoreDifferent mapping options in SAP HANA while importing data from flat file
In SAP HANA, using file import you can load data to an existing table or can create a new table with the same column names as in the flat file.While using import wizard, you can define the mapping of columns. Following options are available −One to OneMap by NameUsing Map by Name option, you can map columns in CSV files to the columns in an existing table.
Read MoreCreating a Delivery unit in SAP HANA using HANA Application Lifecycle Management
To create a delivery unit in SAP HANA, you have to navigate to SAP HANA Application Lifecycle Management.Next is to select PRODUCTS tab → Select Delivery Units tabTo create a new Delivery unit, click on the Create button. Enter the details as shown in the below window and click on Create.
Read MoreAdding LCM Administrator role to a user profile in SAP HANA
To add a role to user profile, open user profile in HANA Studio by navigating to Security folder. Go to Roles tab and click on “+” sign. In search window you have to search for this role − “sap.hana.xs.lm.roles::Administrator”
Read MoreExecution time while running a SQL query in HANA Studio
When a SQL query is executed, you can see the confirmation that the query is executed in time duration and also with server processing time. In this scenario, you can see the time taken by SAP HANA processor to create a new table in the HANA database as below −“Statement 'Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 3 ms 117 µs (server processing time − 2 ms 458 µs) - Rows Affected − 0”
Read MoreCreate table SQL query in SAP HANA
In below SQL query, you can see a create table command in SQL editor to create a new table with name-“Demo_HANA” in schema name AA_HANA11 with column names- ID and NAME and corresponding data types. In the below example, we have defined ID as “Primary Key” which means it is unique and not null.Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );
Read More