Shulou(Shulou.com)06/01 Report--

This article will explain in detail what the SLT in SAP HANA is like, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

In enterprises with SAP system as the main ERP, database data synchronization between different systems is an important work. For this requirement, in addition to developing ABAP interfaces, there are also efficient tools available. SLT is one of them.

SLT is SAP's first ETL (Extract-Transform-Load) tool, which allows real-time loading and copying of data, or scheduling data from source and non-source systems to SAP HANA databases.

SAP SLT server uses trigger-based replication to transfer data from source system to target system.

The SLT server can be installed on a separate system or on a SAP ECC system. The benefits of SLT systems are as follows:

Allow real-time or scheduled data replication.

In the process of copying data in real time, the data can be migrated in SAP HANA format.

SLT can handle cluster table and pool table.

Automatic conversion of non-Unicode and Unicode is supported during load / copy.

It is fully integrated with SAP HANA Studio.

SLT has table setting and conversion capabilities.

It can be monitored by SAP HANA Solution Manager.

The full name of SLT is SAP Landscape Transformation

The architecture of SAP SLT servers for non-SAP systems is summarized as follows:

SLT connection architecture between SAP system and SAP HANA

SAP SLT Replication Server converts all metadata table definitions from the ABAP source system to the SAP HANA metadata table definition. For SAP sources, SLT connections have the following functions:

When copying a table, SAP SLT Replication Server creates a log table on the source system.

The read engine is created in the SAP source system.

The connection between SAP SLT and SAP source system is based on RFC connection.

The connection between SAP SLT and SAP HANA is based on the DB connection.

Database users with the same permissions as SYSTEM can create a connection between SAP SLT and SAP HANA databases.

Figure SAP SLT connects SAP system to SAP HANA database

Configure the SLT server in the SAP source system

First, we need to configure SAP SLT Replication Server to connect to the SAP source server and the SAP HANA database. The transaction code LTR is used to create a connection between the SAP source server and the SAP SLT. Step 1) Log in to the SAP SLT server and invoke the transaction "LTR" from the SAP SLT replication server.

The system will pop up a web Dynpro window to log in to the SAP SLT server.

Enter the user name and password and log in.

The following pop-up window appears for configuration:

Click the New button to create a new configuration.

Step 2) in this step:

Enter a configuration name and description.

Select SAP system as the source system.

Enter the RFC connection (destination) of the SAP system.

Enter username / password / hostname and instance number.

Enter the details of the job options.

Data transfer task number

Calculate the task number

Select the replication option for real-time.

Once all the options have been maintained, click 'OK' to create a new SCHEMA for SLT.

A new configuration named "SLTECC" has now been added and activated:

After successfully configuring the SAP SLT server, the SAP SLT server automatically creates a database connection for the SAP HANA database (when a new configuration is created through a transactional LTR). You don't need to create it manually. Next, we import data from the SAP source into SAP HANA. Exe.

Import data from SAP source to SAP HANA through SLT

Once we have successfully configured the SAP SLT server, the SAP HANA database creates a SCHEMA. Exe with the same name as the configuration in SAP SLT. The SCHEMA contains the following objects:

1 Schema-SLTECC.1 User-SLTECC.1 Privileges8 Tables:DD02L (SAP Tables Name) DD02T (SAP Table Texts) RS_LOG_FILESRS_MESSAGERS_ORDERRS_ORDER_TEXTRS_SCHEMA_MAPRS_STATUS.4 Role-SLTECC_DATA_PROVSLTECC_DATA_POWER_USERSLTECC_DATA_USER_ADMINSLTECC_DATA_SELECT2 ProceduresRS_GRANT_ACCESSRS_REVOKE_ACCESS

After all the configuration is complete, we now load a table from SAP ECC (the central component of ERP). Step 1) to load tables from SAP ECC into the SAP HANA database, follow these steps:

From Quick View to Data provisioning.

Select SAP HANA system

Click the finish button

The program will display a SLT-based Table Data Provisioning screen. There are five options for data provisioning:

Provision option

Description

Load (Full Load) this is an one-time event that starts the initial data loading from the source system.

Replicate (Full Load + Delta Load) starts an initial load (if it has not been done before) and also transfers incremental data. Database triggers and log tables are created for each table.

Stop Replication stops the replication process for the current table. Completely remove triggers and log tables.

Suspend pauses the table replication process in progress. Database triggers will not be removed from the source system and logs will continue to be recorded. The relevant information is stored in the log table of the source system.

Resume restarts paused table replication. We use the first option in the load options list to initially load table (LFBK) data from the source system into the SAP HANA database.

The steps are as follows:

Select source and destination system details according to SAP SLT configuration.

Click the load button and select the table (LFBK) that we need to load / copy in SAP HANA.

Table (LFBK) will be added to the data load management section, its Action is "Load" and its status is "Scheduled".

After the data is loaded, the state changes to executed. The table and data will be created in the SLTECC schema.

Step 3) check the data in the table (LFBK) through the Data Preview in schema "SLTECC":

Log in to the SAP HANA database using SAP HANA Studio and select the SAP HANA system HDB (HANAUSER).

Select the table (LFBK) under the table node.

Right-click the table (LFBK) and select to open Open data preview.

The data loaded by SLT processing will be displayed on the Data Preview screen.

Now we have successfully loaded the data into the table "LFBK". We can use this table in future modeling.

SLT connection between non-SAP system and SAP HANA

SAP SLT Replication Server converts all metadata table definitions from a non-ABAP source system to a SAP HANA metadata table definition. For non-SAP sources, SLT connections have the following functions:

When you copy a table, the SAP SLT replication server creates a log table on the source system.

The read engine is created in the SAP SLT replication server.

The connection between SAP SLT and source system / SAP HANA is based on a database connection.

Figure SAP SLT connects non-SAP systems and SAP HANA databases

SAP SLT can only perform the simplest transformations. For complex transformations, we need other ETL tools, such as SAP Data Services (SAP DS).

About how the SLT in SAP HANA is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.