Monday, 24 December 2018

Implementing SLT configuration (for sidecar) in SAP HANA

In this blog I am going to discuss about one of the data provisioning technique in SAP HANA and how to implement it.

There are primary three types of data provisioning techniques in that can be implemented with SAP HANA Database. these are given below –

1. SAP Landscape Transformation (SLT)
2.SAP Business Objects Data Services (BODS)
3.SAP HANA Direct Extractor Connection (DXC)

Today we will discuss about the SLT techniques i.e. The SAP Landscape Transformation. SAP Landscape Transformation Replication Server is the SAP technology that allows us to load and replicate data in real-time from SAP source systems and non-SAP source systems to an SAP HANA environment.

SLT is used for all sap HANA customers who need real-time or scheduled data replication, sourcing from sap and non-sap sources. iSLT uses trigger-based technology to transfer the data from any source to sap HANA in real-time. and SLT server can be installed on the separate system or on sap ECC system.

# Benefit of SLT system –


◈ Allows real-time or schedule time data replication.
◈ During replicating data in real-time, we can migrate data in sap HANA format.
◈ SLT handles cluster and pool tables.
◈ This is fully integrated with sap hana studio.
◈ SLT have table setting and transformation capabilities.
◈ SLT have monitoring capabilities with sap hana solution manager.

#Basic Architecture :


SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

#Steps to implement SLT on SAP HANA :


Click start  -> Click SAP Logon :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click on the ECC system :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

We need to Provide user name Password  then need to click enter :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Then Provide T_code as SM59  and click enter-

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click new:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Provide RFC Destination name:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click on the search button :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click connection to ABAP system:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

We need to provide provide Description:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click Logon Security -> Provide Language as ‘EN’ user ID and password.

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click Technical Settings -> Provide Target Host ‘SAPSLT’ Instance no ‘20’ :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Now test the RFC connection and click yes:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Now we can see that See Connection test RFC_18 is saved:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click on below icon -> Click on Create Session. Then provide T_code as LTRC  and click Enter :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Click Create icon shown bellow:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Provide Configuration name and then click next :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Provide RFC_Destination  name.Allow multiple users and read from Single Client. Then click next :

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Provide administration name and  Password .Host name and Instance.Then click next.

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Specify transfer Settings: Enter Number of Data transfer Jobs.Enter Number of Initial Load Jobs and enter Number of Calculation Jobs –

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Then click next and create. You can see that DD02L, DD02T and DD08L tables are created by system.

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Then log into SAP HANA Studio and go to modeler perspective then  reset the perspective.Click Data Provisioning:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Select Source System and Target  Schema:

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

You can now see tables are replicated from ECC.

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Now we can check inside the ECCHANA_18 and see that the tables are replicated inside the system.

SAP HANA Certification, SAP HANA Guides, SAP HANA Learning, SAP HANA Tutorial and Material

Now the SLT configuration and replication process has been completed . In the next blog I will discuss about the SLT implementation in the main car.