SAP-HANA
SAP HANA Tutorial: Create Trigger
What is Trigger? A trigger is also a stored procedure that automatically executes when an event...
SLT is the an ETL tool that allows you to load and replicate data in real-time or schedule data from SAP source system or Non SAP System into SAP HANA Database.
SAP SLT server uses a trigger-based replication approach to pass data from source system to target system.
SLT server can be installed on the separate system or on SAP ECC System.
Benefit of SLT system is as below-
Architecture Overview of SAP SLT server with SAP / Non-SAP System is as below-
SAP SLT Replication Server transforms all metadata table definitions from the ABAP source system to SAP HANA.
For SAP source, the SLT connection has the following features -
A database user with the same authorization as user "SYSTEM" can create a connection between SAP SLT and SAP HANA Database.
SAP SLT Connection between SAP System and SAP HANA DATABASE
SAP SLT Server automatically create DB connection for SAP HANA database (when we create a new configuration via transaction LTR). There is no need to create it manually.
First we need to configure SAP SLT replication server for connection between SAP Source and SAP HANA database. T-code, LTR is used for creating a connection between SAP Source and SAP SLT.
Step 1) Login to SAP SLT server, and Call transaction "LTR" from SAP SLT replication server.
A Web-dynpro pop-up screen will appear for login to SAP SLT server.
A pop-up screen for Configuration will appear as below-
Click on "New" Button for the new configuration.
Step 2) In this step,
A Configuration Name "SLTECC" will be added and active.
After configuration SAP SLT server successfully, SAP SLT Server automatically create DB connection for SAP HANA database (when we create a new configuration via transaction LTR). There is no need to create it manually.
In next step, we import data to SAP HANA from SAP Source.
Once we have successfully configured SAP SLT server, a SCHEMA as configuration name above in SAP SLT is created in SAP HANA Database.
This Schema contains following objects-
All configuration is completed, now we load a table from SAP ECC (ERP Central Component).
Step 1) To load tables from SAP ECC to SAP HANA database, follow below steps-
Step 2) A screen for SLT Based Table Data Provisioning will be displayed. There are 5 options for data provisioning as below-
Load (Full Load) | This is a one-time event, which starts an initial load of data from source system. |
Replicate (Full Load + Delta Load) | It start initial load (if not done earlier), and also consider delta change. Database trigger and related logging table will be created for each table. |
Stop Replication | It stops the current replication process for a table. It removes database trigger and logging table completely. |
Suspend | It pause a running replication process of a table. The database trigger will not be deleted from the source system, and recording of changes will continue. Related Information is stored in the related logging table in the source system. |
Resume | Resume restarts the replication for a suspended table. After resume, the suspended replication process will resume. |
We use the first option from the table "Load option" for initial load of the table (LFBK) data from source to SAP HANA table.
Step-by-step is as below-
After data load, Status will be changed to "Executed". The table will be created in "SLTECC" schema with data.
Step 3) Check Data in the table (LFBK) by Data Preview from Schema "SLTECC" as below -.
Now we have successfully loaded data in table "LFBK". We will use this table future in Modelling.
SAP SLT Replication Server transforms all metadata table definitions from the non-ABAP source system to SAP HANA.
For Non-SAP source, the SLT connection has following features -
SAP SLT Connection between Non - SAP SLT Connection and SAP HANA System/DATABASE
SAP SLT can only do simplest transformations, so for complex transformations, we need another ETL tool such as SAP Data services.
What is Trigger? A trigger is also a stored procedure that automatically executes when an event...
What is Sequence? A sequence is a database object that automatically generates the incremented list of...
A procedure is a unit/module that perform a specific task. This procedure can be combined to form...
SAP HANA Operator can be used for calculation, value comparison or to assign value. SAP HANA...
What is Sap Hana Security? SAP HANA Security is protecting important data from unauthorized access...
What is SAP Data services? SAP Data services is an ETL tool which gives a single enterprises level...