SAP HANA Introduction
- SAP HANA - Core Architecture
- SAP HANA - Information Modeler
- SAP HANA - System Monitor
- Studio Administration View
- SAP HANA - Studio
- In-Memory Computing Engine
- SAP HANA - Overview
SAP HANA Modeling
- SAP HANA - Export and Import
- SAP HANA - Information Composer
- SAP HANA - Analytic Privileges
- SAP HANA - Calculation View
- SAP HANA - Analytic View
- SAP HANA - Attribute View
- SAP HANA - Packages
- SAP HANA - Tables
- SAP HANA - Data Warehouse
- SAP HANA - Modeling
SAP HANA Reporting
- SAP HANA - Excel Integration
- SAP HANA - Crystal Reports
- Bi 4.0 Connectivity to HANA Views
- SAP HANA - Reporting View
SAP HANA Security
- SAP HANA - Auditing
- SAP HANA - License Management
- SAP HANA - Authorization methods
- SAP HANA - Authentications
- User Administration & Management
- SAP HANA - Security Overview
SAP HANA Data Replication
- SAP HANA - MDX Provider
- SAP HANA - CTL Method
- SAP HANA - DXC Method
- SAP HANA - Log Based Replication
- SAP HANA - ETL Based Replication
- SAP HANA - Data Replication Overview
SAP HANA Monitoring
- SAP HANA - Log Configuration
- SAP HANA - High Availability
- SAP HANA - Backup & Recovery
- SAP HANA - Persistent Layer
- SAP HANA - Monitoring and Alerting
SAP HANA SQL
- SAP HANA - SQL Script
- SAP HANA - SQL Data Profiling
- SAP HANA - SQL Explain Plans
- SAP HANA - SQL Synonym
- SAP HANA - SQL Triggers
- SAP HANA - SQL Sequences
- SAP HANA - SQL Stored Procedures
- SAP HANA - SQL Expressions
- SAP HANA - SQL Functions
- SAP HANA - SQL Operators
- SAP HANA - Data Types
- SAP HANA - SQL Overview
SAP HANA Useful Resources
- SAP HANA - Discussion
- SAP HANA - Useful Resources
- SAP HANA - Quick Guide
- SAP HANA - Questions and Answers
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
SAP HANA - Data Reppcation Overview
SAP HANA Reppcation allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data reppcation techniques.
System reppcation can be set up on the console via command pne or by using HANA studio. The primary ECC or transaction systems can stay onpne during this process. We have three types of data reppcation methods in HANA system −
SAP LT Reppcation method
ETL tool SAP Business Object Data Service (BODS) method
Direct Extractor connection method (DXC)
SAP LT Reppcation Method
SAP Landscape Transformation Reppcation is a trigger based data reppcation method in HANA system. It is a perfect solution for reppcating real time data or schedule based reppcation from SAP and non-SAP sources. It has SAP LT Reppcation server, which takes care of all trigger requests. Reppcation server can be installed as standalone server or can run on any SAP system with SAP NW 7.02 or above.
There is a Trusted RFC connection between HANA DB and ECC transaction system, which enables trigger based data reppcation in HANA system environment.
![SAP LT Reppcation Method](/sap_hana/images/sap_lt_reppcation_method.jpg)
Advantages of SLT Reppcation
SLT Reppcation method allows data reppcation from multiple source systems to one HANA system and also from one source system to multiple HANA systems.
SAP LT uses trigger based approach. It has no measureable performance impact in source system.
It also provides data transformation and filtering capabipty before loading to HANA database.
It allows real-time data reppcation, reppcating only relevant data into HANA from SAP and non-SAP source systems.
It is fully integrated with HANA System and HANA studio.
Creating a Trusted RFC Connection in ECC system
On your source SAP system AA1 you want to setup a trusted RFC towards target system BB1. When it is done, it would mean that when you are logged onto AA1 and your user has enough authorization in BB1, you can use the RFC connection and logon to BB1 without having to re-enter user and password.
Using RFC trusted/trusting relationship between two SAP systems, RFC from a trusted system to a trusting system, password is no required for logging on to the trusting system.
Open SAP ECC system using SAP logon. Enter transaction number sm59 → this is transaction number to create a new Trusted RFC connection → Cpck on 3rd icon to open a new connection wizard → cpck on Create and new window will open.
![SAP ECC System](/sap_hana/images/sap_ecc_system.jpg)
RFC Destination ECCHANA (enter name of RFC destination) Connection Type − 3 (for ABAP system)
Go to Technical Setting
Enter Target host − ECC system name, IP and enter System number.
![Technical Setting1](/sap_hana/images/technical_setting1.jpg)
Go to Logon & Security tab, Enter Language, Cpent, ECC system user name and password.
![Technical Setting2](/sap_hana/images/technical_setting2.jpg)
Cpck on the Save option at the top.
![Destination](/sap_hana/images/destination.jpg)
Cpck on Test Connection and it will successfully test the connection.
![RFC Connection Test](/sap_hana/images/rfc_connection_test.jpg)
To Configure RFC connection
Run transaction − ltr (to configure RFC connection) → New browser will open → enter ECC system user name and password and logon.
![Configure RFC Connection](/sap_hana/images/configure_rfc_connection.jpg)
Cpck on New → New Window will open → Enter configuration name → Cpck Next → Enter RFC Destination (connection name created earper), Use search option, choose name and cpck next.
![Create Configuration](/sap_hana/images/create_configuration.jpg)
In Specify Target system, Enter HANA system admin user name & password, host name, Instance number and cpck next. Enter No of Data transfer jobs pke 007(it cannot be 000) → Next → Create Configuration.
Now go to HANA Studio to use this connection −
Go to HANA Studio → Cpck on Data Provisioning → choose HANA system
![Hana System](/sap_hana/images/hana_system.jpg)
Select source system (name of trusted RFC connection) and target schema name where you want to load tables from ECC system. Select tables you want to move to HANA database → ADD → Finish.
![Source System](/sap_hana/images/source_system.jpg)
Selected tables will move to chosen schema under HANA database.
Advertisements