SAP HANA Articles

Page 14 of 58

Trusted RFC connection in SAP system

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 3K+ Views

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 More

Embedded BW parameters for SAP HANA

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 359 Views

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 More

Enabling Web dispatcher in SAP HANA Studio

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 2K+ Views

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 More

Using Delivery unit in SAP HANA

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 622 Views

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 More

Role Required to use LCM in SAP HANA

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 240 Views

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 More

Different mapping options in SAP HANA while importing data from flat file

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 338 Views

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 More

Creating a Delivery unit in SAP HANA using HANA Application Lifecycle Management

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 358 Views

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 More

Adding LCM Administrator role to a user profile in SAP HANA

Anil SAP Gupta
Anil SAP Gupta
Updated on 25-Jun-2020 349 Views

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 More

Execution time while running a SQL query in HANA Studio

John SAP
John SAP
Updated on 22-Jun-2020 839 Views

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 More

Create table SQL query in SAP HANA

John SAP
John SAP
Updated on 22-Jun-2020 9K+ Views

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
Showing 131–140 of 573 articles
« Prev 1 12 13 14 15 16 58 Next »
Advertisements