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 - ETL Based Reppcation
SAP HANA ETL based reppcation uses SAP Data Services to migrate data from SAP or non-SAP source system to target HANA database. BODS system is an ETL tool used to extract, transform and load data from source system to target system.
It enables to read the business data at Apppcation layer. You need to define data flows in Data Services, schedupng a reppcation job and defining source and target system in data store in Data Services designer.
How to use SAP HANA Data Services ETL based Reppcation?
Login to Data Services Designer (choose Repository) → Create Data store
![SAP HANA Data Services](/sap_hana/images/sap_hana_data_services.jpg)
For SAP ECC system, choose database as SAP Apppcations, enter ECC server name, user name and password for ECC system, Advanced tab choose details as instance number, cpent number, etc. and apply.
![New Data Store](/sap_hana/images/new_data_store.jpg)
This data store will come under local object pbrary, if you expand this there is no table inside it.
![Local Object Library](/sap_hana/images/local_object_pbrary.jpg)
Right cpck on Table → Import by name → Enter ECC table to import from ECC system (MARA is default table in ECC system) → Import → Now expand Table → MARA → Right Cpck View Data. If data is displayed, Data store connection is fine.
Now, to choose target system as HANA database, create a new data store. Create Data store → Name of data store SAP_HANA_TEST → Data store type (database) → Database type SAP HANA → Database version HANA 1.x.
Enter HANA server name, user name and password for HANA system and OK.
![Create New Datastore](/sap_hana/images/create_new_datastore.jpg)
This data store will be added to Local Object Library. You can add table if you want to move data from source table to some specific table in HANA database. Note that target table should be of similar datatype as source table.
Creating a Reppcation Job
Create a new Project → Enter Project Name → Right Cpck on Project name → New Batch Job → Enter job name.
![Creating a Reppcation Job](/sap_hana/images/create_reppcation_job.jpg)
From right side tab, choose work flow → Enter work flow name → Double cpck to add it under batch job → Enter data flow → Enter data flow name → Double cpck to add it under batch job in Project area Save all option at top.
![Object Area](/sap_hana/images/object_area.jpg)
Drag table from First Data Store ECC (MARA) to work area. Select it and right cpck → Add new → Template table to create new table with similar data types in HANA DB → Enter table name, Data store ECC_HANA_TEST2 → Owner name (schema name) → OK
![Create Template](/sap_hana/images/create_template.jpg)
Drag table to front and connect both the table → save all. Now go to batch job → Right Cpck → Execute → Yes → OK
![SAP ECC Test](/sap_hana/images/sap_ecc_test.jpg)
Once you execute the Reppcation job, you will get a confirmation that job has been completed successfully.
Go to HANA studio → Expand Schema → Tables → Verify data. This is manual execution of a batch job.
Schedupng of Batch Job
You can also schedule a batch job by going to Data Services Management console. Login to Data Services Management Console.
Choose the repository from left side → Navigate to Batch Job Configuration tab, where you will see the pst of jobs → Against the job you want to schedule → cpck on add schedule → Enter the schedule name and set the parameters pke (time, date, reoccurring etc.) as appropriate and cpck on Apply .
![Schedupng of Batch Job](/sap_hana/images/schedupng_a_batch_job.jpg)