SAP Landscape Transformation (SLT) is becoming a popular choice to transfer and transform data between SAP and non-SAP sources. The idea behind is to have an utility that allows us to transfer data in real time between different sources with the possibility of transform it during the process. For example, we can transfer data from an Oracle database which it is use by non-SAP application to a SAP ERP system. The following image describes the architecture and the process:
Before creating the connection we have to consider several topics so we won’t have any problems during the whole process:
Remember to restart the SAP System after copying the library files!
After the preparation steps we have to perform the following tasks in order to create the connection on LTR or LTRC transactions:
The steps are quite easy, I’m not full covering them but here you have some of them:
Almost all the configuration properties are self-explained, an important property is the number of jobs for the Data Transfer and the Initial Load. You should be really careful with this values since the more jobs we use the more resources the SLT connection will consume.
After we create our connection we can configure and monitor it using the transactions I wrote before. On the LTRC transaction just click on the connection and a new screen will be opened. For configuring the whole process we can check the Processing Steps tab, just follow all the steps over there:
If you want to check if the connection is working correctly just go to the Administration Data to see if it is active and running. We can monitor the load statistics on the tab that has the same name where we can find the number of records processed:
If we have any problem with the connection we can use the following tools:
A lot of companies are using ELT tools nowadays so we Basis people have a lot of work on that side. Some of them are not my favorite tools for some reasons I will explain in the future but I have to say they are quite useful when transferring and transforming huge amounts of data. I don’t know if you already worked with this tools but if it not you better start studying and using them! As you may know Basis people are usually the ones expected to provide solutions to issues on the SAP landscape.
I hope you all survived the log4j Apocalypse and Christmas, hopefully you had a great…
I know it is being a while since I posted the last time. So far…
UPDATE 11/25/2020 Adobe released a new patch that solves the issue a few days ago:…
Good news for you fanatics of SAP GUI! SAP will release SAP GUI 7.70 in…
Quick update since I don't have a lot of time lately. During my 2019 job…
It's been a while since the last time I wrote an entry in my blog.…