SAP HANA Articles - Page 10 of 69

SAP HANA also provides few of built-in tools which can be used for data provisioning in HANA database −Flat File Load (Import../Export.. option)Smart Data Streaming (This is available with HANA SPS09)Smart Data Access

Following RFC connection types are available in SAP system −Connection Type 3 (ABAP Connection) This connection type is used to specify connection between ABAP systems. You need to mention the host name and IP address of source system and also the logon information. This is applicable for both type of RFCs, between ABAP systems and external calls to ABAP systems.Connection Type I (Internal Connections)This connection Type I indicates ABAP systems connected to the same database as current system. Type I entries are predefined and you can’t edit these entries.Connection Type L (Logical Destinations)The logical destination connection type indicates a physical destination. ... Read More

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.

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

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.

You can try accessing XS Engine using below address in IE.http://:80 and you will get below screen to show that XS Engine is working fine.

To Configure DXC, you need to enable XS Engine (SAP HANA Extended Application Services). To enable XS Engine Change the Instance value to “1”. XS Engine Service in SAP HANA Studio is used to handle Control Flow Logic.

Data provisioning is available under SAP HANA Modeler Perspective.

SAP HANA is an in-memory database that supports real-time data replication from SAP and non SAP data sources. Following data replications are supported using SAP HANA −SAP Landscape Transformation (SLT) This is trigger based approach used to transfer data from source system to target systemSAP Data Services (BODS) This is commonly used to move data from SAP and non-SAP data sources to HANA db. It is an ETL based replication which extract, transform and load data from source system to target system.Sybase replication in SAP HANA This includes Sybase Replication agent which is part of SAP source application and Replication server implemented in ... Read More

M_PASSWORD_POLICY System View contains several lines of information about the current password policy.>Select * from M_PASSWORD_POLICY