How To replicate Data from SAP Source System To HANA Database In this blog In order to replicate data from SAP source system to HANA database, two major steps are involved, they are: 1. Create schema in SLT using the transaction code LTR 2. Replicate the tables of source system …
Read More »Introduction To SAP Landscape Transformation (SLT)
Hi Friends, New to Real Time Replication? with this blog I would like to share basic information on SAP Landscape Transformation Replication Server i.e SLT running on the Netweaver platform . SLT is the SAP first ETL tool that allows you to load and replicate data in real-time or schedule data …
Read More »How To replicate Data from SAP Source System To HANA Database
How To replicate Data from SAP Source System To HANA Database In this blog In order to replicate data from SAP source system to HANA database, two major steps are involved, they are: 1. Create schema in SLT using the transaction code LTR 2. Replicate the tables of source system …
Read More »Introduction To SAP Landscape Transformation (SLT)
Hi Friends, New to Real Time Replication? with this blog I would like to share basic information on SAP Landscape Transformation Replication Server i.e SLT running on the Netweaver platform . SLT is the SAP first ETL tool that allows you to load and replicate data in real-time or schedule data …
Read More »Load missing documents using SLT
Hi All, I am an ABAP consultant with over 9 years of SAP ABAP experience. I am currently working as an SAP ABAP and SAP SLT consultant since 1.5 years on a Central Finance Implementation project. Recently, I came across a scenario where some of the documents were accidentally deleted …
Read More »HANA SLT(SAP Landscape Transformation) Replication Errors and Resolution Steps
Hi All In this blog we are going to discuss SLT replication errors and resolution steps. Basic Concepts and System Landscape Options: The SAP Landscape Transformation (SAP LT) Replication Server is the SAP technology that allows you to load and replicate data in real-time from ABAP source systems and non- …
Read More »HANA SLT(SAP Landscape Transformation) Archiving Settings When Source Table Being Archived
Hi All In this blog we are going to discuss how to prevent archive deletes from being replicated to a target system. Archiving Data in Source Systems: The trigger-based replication also considers the deletion in source tables by archive activities (since it is not possible to distinguish on the database …
Read More »SAP LT Replication Server DMIS2011 SP13 released
Highlights: New filter options for the replication process of transparent and pool tables Simplified data type mapping for target data types Enhanced features and usability improvements for INDX-like table replication New data provisioning options ‘Start Recording’ and ‘Start Replication Without Initial Load’ Case-sensitive tables and special data types supported for …
Read More »End of Mainstream Maintenence of SAP LT Replication Server extended to 31th December 2025
To provide SLT customers with additional investment planning security, the end of mainstream maintenance for the SAP LT Replication Server 2.0 (DMIS2011) has been moved from end of 2020 to end of 2025. Please also see updated Product Availability Matrix for SLT. Albrecht Weiss Product Management SAP LT Replication Server
Read More »Init Load is in schedule for long time in SAP SLT – A work around to this issue
Document applies to: Component Release SP-Level Support Package Short Description of the component DMIS 2011_1_731 11 SAPK-11611INDMIS DMIS 2011_1 Issue: While replicating Tables sometimes it happens that the Tables go on schedule status for long time but neither load / replication takes place. As per below screenshot four tables …
Read More »New roadmap released for SAP LT Replication Server
Please see the updated roadmap edition 2017/Q2 for the SAP Landscape Transformation Replication server. Best Regards, Albrecht Weiss Product Management SLT Replication Server
Read More »SLT – Transformation – How to add new fields to existing source table and populate them to Target table based on transfer behavior
This case scenario cover requirements to add new fields & populate them via SLT to target structure .In this case we will populate the new fields with time-stamp for transfer behavior I (insert) & U (update). Execute T-Code LTRS: Select your MT-ID (Mass Transfer ID) Right click on table setting …
Read More »SLT – Table Enhancement & Cluster Data Extraction
What is SLT? SLT stands for SAP Landscape Transformation Replication Server (SLT) running on the NetWeaver Platform. SLT is the ideal solution for all HANA customers who need real-time (and non-real-time) data replication sourcing from SAP ERP or non-SAP systems into HANA Requirement STXL table is available in ECC system. …
Read More »SLT (SAP Landscape Transformation) – Masking Fields in Table
What is SLT? SLT stands for SAP Landscape Transformation Replication Server (SLT) running on the NetWeaver Platform. SLT is the ideal solution for all HANA customers who need real-time (and non-real-time) data replication sourcing from SAP ERP or non-SAP systems into HANA. Requirement PA2001 table need to be replicated in …
Read More »SAP HANA – SLT Configuration
SLT will work on based on the trigger based concept SAP LT is trigger based and Real time replication method. SLT stands for SAP Landscape Transformation Replication Server (SLT) running on the Net Weaver Platform. SLT is the ideal solution for all HANA customers who need real-time (and non-real-time) data …
Read More »Adjust SLT connection to HANA MCD
After convert HANA to MCD (MultiTenant) some tasks must to be executed in SLT to connect with MCD Database. In addition to Note 2101084 please check the SAP Note relevant for your DMIS version from the list below and ensure all corrections are applied to both source and SLT server …
Read More »SLT – Replicate view from Non-ABAP source
You want to replicate view in Oracle to HANA , while the view include two tables in different tablespace. Preparation: Table in oracle: Table 1: SLT_DEMO , SLT_DEMO is in tablespace TEST Table 2 : SLT_DEMO1 , SLT_DEMO1 is in tablespace SLTORA VIEW : VIEW_TEST Go to SE16 -> Table …
Read More »SLT Scenario for SAP Business Warehouse – Setting of PSA
In this blog, we will have a look on how to create the SLT configuration for BW PSA scenario. Prerequisite: DMIS add-on on BW system. RFC connection work between SLT system and BW system Landscape: Steps : 1. Go to transaction LTRC , create configuration, input configuration name, and descritption …
Read More »To check the SLT generated objects and other issues I have faced
Hi All, I was planning trying to write a Technical blog which couldn’t happen in these many years but finally got chance today. As this is my first blog on technical details please let me know if there are any missing screenshots or mistakes. The blog contains the navigation and …
Read More »How to replicate data from an Oracle table which has a long field
When using SLT to replicate data from Oracle DB to HANA, you might see SQL error 932 occurred on a specific table and the initial load was failed.The reason is that you have defined a long field in the table, e.g. VARCHAR(2000).Following is an example of the problem and the …
Read More »Special considerations for ABAP sources/targets on HANA
Hi, I want to share with you some special considerations and settings that has to be defined for specific tables if you replicate from an ABAP source or into an ABAP target that is using HANA as a database. I copied the note text: 2319897 – SLT – Replicating data …
Read More »Transfer Delta Data with SLT to Hadoop
Dear All, a lot of customers approached us asking if they can transfer their delta data with SLT to Hadoop. See here how the setup can look like to transfer data with SLT to SAP HANA and from SAP HANA further on to Hadoop and what the benefits are if …
Read More »SAP LT Replication Server – Master Job execution with Batch user
Dear All, With this blog I would like to share the learning I had with the SLT configuration where in the replication master job was getting executed with the dialog user, if the dialog user is locked or deactivated the replication jobs were not restarted after 24 hrs. Error Msg …
Read More »SAP LT Replication server – Conflicting Objects(Number range issue)
Dear All, With this blog I would like to share the learning I had with the SLT configuration with Single source and multiple controller systems SLT Replication Server Version details: SLT NW 731 SP5 – DMIS 2011_731 SP5 on Oracle Database HANA Revision: 74.04 SAP LT Replication …
Read More »SAP LT Replication server – Allow Multiple Usage (Option impact for Replication configuration)
Dear All, With this blog I would like to share the learning which i had when i wanted to use the same source system for replication from different clients using the same controller SLT system. SLT Replication Server Version details: SLT NW 731 SP5 – DMIS 2011_731 SP5 on …
Read More »Learning from SLT to Oracle Implementation
SLT as we know is one of demanding middleware technlogies today which can be very useful, though normally roadmap for SLT is HANA but in our case it was decided to use Oracle as target system and SAP ECC as the source. From SLT SP009 – it started supporting Oracle …
Read More »How to consume your real-time data with the sidecar senario (SAP LT Replication Server)
Our production system is ECC 6.0 and we are not planning to upgrade and migrate our system to HANA in a short period of time. On the other hand we want to use Hana live analitics and consume our real-time data with Lumira. For this requirement we decided to go …
Read More »SAP LT Replication Prerequisites for HANA Live Components
Recently i got the chance to work very closely with SAP Basis for installing the SAP HANA Live Components of various applications i.e. SAP ECC, CRM , TM , EM , APO, EWM and also HANA Live Browser as well etc. Initially i was not sure and was not aware …
Read More »SAP TechEd 2015
Dear All, SAP TechEd 2015 is over – thanks a lot to those who joined our sessions or stepped by at our pod in the show floor. Our sessions were nearly sold out, but they were also recorded. You can find a replay on the TechEd homepage: DMM164: SAP Landscape …
Read More »SAP LT Replication Server – Performance Optimization Guide based on DMIS 2011 SP09
Hi, as already announced at TechED this year, here is the new Performance Optimization Guide for SLT: https://support.sap.com/content/dam/library/SAP%20Support%20Portal/support-programs-services/solution-manager/integrated-tools/landscape-transformation-software/SAP%20Activate/SLT%20Performance%20Guide.pdf Feel free to post here any feedback. Best, Tobias
Read More »