Data Services Replication

Data Services Replication

Data Integrator has been moving data into and out of SAP sources for many years. Data integrator can work with  almost any database to extarct and load data and both in batch and real time mode making it a robust tool for data replication.

Examples of databases /Apps that can connect to data integrator are sybase,oracle,my sql,COBOL,informix,DB2,MS excel,webservices,flat files,jd edwards,oracle apps,terradata,SAP BW,SAP ERP,XML File(batch),Siebel,XML messages (realtime)

Usage of SAP HANA

SAP Landscape Virtualization manager:

SAP LVM is sued to start and stop of SAP HANA with in SAP landscapes.

SAP Solution Manager:

For Monitoring of SAP HANA using DBACOCKPIT

SAP Support OSS:

For remote support to HANA database.

SAP SMP service market Place:

For downloading patches and support packs.

SAP HANA Studio:

For HANA Admin and data modeling

Data Extraction Connection (DXC):

Data from SAP Business content datasource extractor

SAP landscape transformation (SLT):

For Real Time replication

SAP Data Services:

For ETL based loading

HANA Information Composer:

For easy uploading of  data

SAP HANA UI for Information Access:

For search capability in SAP HANA

SAP Business Objects BI:

For analytics

SAP NW 7.3 BW:

For Primary Persistance  of SAP NW7.3 as ABAP

In memory APPS:

For direct access via SAP client

R runtime:

For direct integration with R runtime libraries


What to choose in SAP HANA-Row Store or Column Store??

What to choose in SAP HANA-Row Store or Column Store??

SQL queries involving aggregation functions take a lot of time on huge amounts of data because every single row is touched to collect the data for the query response.
In columnar tables, this information is stored physically next to each other, significantly increasing the speed of certain data queries. Data is also compressed, enabling shorter loading times.

To enable fast on-the-fly aggregations, ad-hoc reporting, and to benefit from compression mechanisms it is recommended that transaction data is stored in a column-based table.

The SAP HANA data-base allows joining row-based tables with column-based tables. However, it is more efficient to join tables that are located in the same row or column store. For example, master data that is frequently joined with transaction data should also be stored in column-based tables.

Important points about column table:

  1. HANA modeling views are only possible for column tables. Row based tables cannot be used in modeling views.
    2. Replication Server creates SAP HANA tables in column store by default.
    3. Data Services also creates target tables in column store as default for SAP HANA database
    4. The data storage type of a table can be modified from Row to Column storage with the SQL command or using HANA Studio

What is Row Store and Column Store Approach of SAP HANA

What is Row Store and Column Store Approach of SAP HANA

Row based tables:

It is the traditional Relational Database approach

It store a table in a sequence of rows

Column based tables:

It store a table in a sequence of columns i.e. the entries of a column is stored in contiguous memory locations.

SAP HANA is highly optimized for column-order storage.

SAP HANA uses and support both row-based and column-based approach making it very powerful and efficient for processing huge data quickly

Row based tables benefits:

The application needs to only process a single record at one time (many selects and/or updates of single records).

The application needs to access a complete record (or row).

Neither aggregations nor fast searching are required.

The table has a small number of rows (e. g. configuration tables, system tables).

Row based tables dis-advantages:

In case of analytic applications where aggregation are used and fast search and processing is required. In row based tables all data in a row has to be read even though the requirement may be to access data from a few columns.

Row store compression is very limited.

Advantages of column-based tables?

Faster Data Access:

Only affected columns have to be read during the selection process of a query. Any of the columns can serve as an index.

High Compression:

Columnar data storage allows highly efficient compression because the majority of the columns contain only few distinct values (compared to number of rows).

parallel Processing capacbility

In a column store, data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel. If multiple columns need to be searched or aggregated, each of these operations can be assigned to a different processor core




Hana appliance is a combination of SAP Hana database software and the Hardware specification.

As you see above A SPA HANA Database has CPU , Main memory (Ram) and then the persistance layer i.e the disk containing the log volumes and Data volumes.

RAM is physical memory – 128GB is minimum needed for SAP HANA, 256GB,512 GB,1TB


Data volumes should be 3-4 times of RAM

Log volumes should be equal to RAM size.

Data is stored in RAM in two types of data store- Row Store and Column Store.

Row Store –as you know traditional databases store data in row store residing in disk, where as in HANA all row store data are stored in RAM.

Cloumn store- this data is stored in columns as in BWA.

What is Persistance Layer: data is memory is volatile, i.e in case of power loss or server crashes, the data in the memory is lost. Hence We need a persistance layer containing the data volumes and log volumes in the disk. SAP HANA has a save point parameter where in every 300 seconds the changes done

In traditional database- only data is fetched from database and all calculation and analysis is done in application server and then sent to frontend.

Where as in SAP HANA the data is fetched and calculated and analyzed and then sent to application  layer making is very fast.



Why should customers/clients switch to SAP HANA

Why should customers/clients switch to SAP HANA


Below are the Reasons:

1)You have massive amount of data and you need to manage it efficiently and quickly

2)Get insights of your massive data both structured and unstructured

3)Develop innovations

4)Perform complex business and forecast  analysis quickly

5)Run next generation application like mobile apps ,web apps

6)Set up advanced cloud platform

7)Simple to manage and use

8)get most of the old obsolete data gives you new insight for your business

9)highly flexible and get immediate results on different platforms


What is SAP HANA

What is SAP HANA

HANA stands for High Performance Analytic Appliance. 90% of The coding is done in C++ and the key feature of SAP HANA is that it is in memory computing

1)In memory computing (RAM) makes it fast

2)Lowers cost of operation

3)users of all levels are empowered to conduct immediate ad hoc data

analyses and transaction with SAP HANA DB

processing using massive amounts of real time data

Traditional databases like oracle sql, had limitation due to bottleneck of disk I/O and SAP HANA has rectified this by a different approach of in Memory computing.

Hardware innovations like the multi core CPU with handling capacity of huge amount of RAM has lead to SAP HANA innovation.parallel processing is possible, 80 cores and 128 cores servers capable of handling more than 1TB of RAM is available making the future of  in memory computing

Available on suse linux and red hat linux platform.can handle OLTP,OLAP.

SAP BUSINESS SUITE – The Steroids for Businesses

SAP BUSINESS SUITE Powered by HANA– The Steroids for Businesses

SAP Business Suite is now powered by  real time technology: SAP HANA. This software brings together transactional and analytical data into a single in-memory-based solution which can deliver analysis in matter of seconds and having the power to process billions of records to provide you meaningful insights of this massive data in real time. You can now drive your entire business to create new business value with smarter business innovations, faster business processes, and simpler business interactions. Massive compression of data helps in keeping the cost low for the infrastructure budget. Also sate of the art front end application helps to manage and scale the SAP Business Suite Powered by SAP HANA easily without much hassle.

SAP Business Suite software powered by HANA helps businesses quickly optimize, execute, and align their business and IT strategies to maximize profits and enhance maximum utilization of resources thus driving more profits. Eg: Auction companies can quickly analyze the sales trend ,price trends, customer reviews and adjust their business processes accordingly to maximize profits and make real time optimization across the organization in a matter of seconds. Another example is a power distribution company can get real time insight on the power consumption and thereby adjust  the power generation and distribution efficiently which was nearly impossible without the real time Sap HANA. The suite gives you the unique ability to perform essential end-to-end business processes with modular applications that are designed to work with other SAP and non-SAP business solutions.

Along with  reporting and analytics functions for your entire organization , SAP Business Suite provides a robust technology environment for designing, composing, and adapting business processes that meet the specific needs of your industry. Core applications within SAP Business Suite support processes for finance, human resources, manufacturing, procurement, product development, marketing, sales, service, supply chain management, and IT management.

Note:This is a personal blog and I do not receive monetary compensation for any of my product/Tech reviews. All reviews represent my opinion . Please consult respective company for professional consultations.-Ramesh Umapathaiah