SAP HANA is an in-memory platform that serves as a relational database that application developers can use to find business solutions. Its primary purpose is to store or retrieve data needed by applications in real-time.
SAP’s Landscape Transformation feature, or SLT, allows this real-time retrieval by loading the data to the HANA system from SAP and other sources. SLT allows you to schedule data replication tasks, move data during the replication process, and monitor various tables. Our guide will take you through SLT’s architecture and provide instructions on the proper setup for SAP HANA SLT configuration.
Understanding some core features of SLT and its architecture may help you with the SAP HANA SLT configuration process. The SAP HANA architecture within the SLT framework forms a connection between SLT and the SAP HANA system. SLT also forms a connection between any non-SAP system and the HANA database. We will cover both of these relationships.
Architecture Between SLT and the Source System
The Landscape Transformation feature includes a data replication server. This server compiles all the metadata from various tables in the source system and transforms that data into a format that SAP HANA can read and use. If you are using SAP as your source system, you can install the SLT framework in the source itself. However, you can also choose to install SLT as its own system You must install it as its own system if the source is non-SAP. The replication server will create a log in the source whenever you replicate a table in the system.
SLT has two primary connections between SAP Source and any non-SAP systems. The SAP Source connection is RFC, and the non-SAP connection is DB. Any non-SAP system will use the DB connection. Running SAP HANA SLT configuration protocols inside the Source eliminates the need for any RFC connections. SLT will create a DB connection for SAP HANA automatically when you configure a new transaction, so you won’t have to create a manual connection.
Configuring SAP SLT Server for the SAP Source System
Now that you understand a bit about SLT’s overall architecture and its relationship to SAP, we can move on to the SAP HANA SLT configuration process. This section will provide you with a step-by-step guide to configuring the SLT server for use with the Source system.
- Use the LTR transaction code to access the SLT server.
- On the next screen, click the ‘New’ button. LTR will create a new schema.
- Provide configuration details for the new schema.
- Enter the name of your new schema.
- The source system should be ‘SAP System.’
- Input the RFC connection for the system.
- Enter your username, password, instance number, and hostname into the appropriate boxes.
- Make sure the replication process is set to a real-time value.
- Double-check the information you have entered and click on ‘OK’ to complete the new schema.
More Resources for the SAP HANA Enthusiasts:
How to Import SAP Source Data to SAP HANA with SLT
The next step in the SAP HANA SLT configuration process is to replicate source tables and copy them into the SAP HANA database. We will outline this segment in the steps below. Note that some steps may include multiple tasks you need to complete before continuing.
Part 1: Loading tables into the SAP HANA Database from ECC
- Navigate to the Quick View tab and use it to move to ‘Data Provisioning.’
- Click on ‘SAP HANA System.’
- Click ‘Finish.’
Part 2: Begin Data Replication
Now that you have loaded the tables, you’re ready to begin the process of replicating the data. There are five options that you may wish to use.
You can choose this option if you wish to load all data from the source system into HANA. Activating this option creates a single-use event that begins the replication process.
Choose this option if you need to add historical data markers to real-time copies. Note that this will also start the initial data load from the source to HANA if you did not do it earlier. This process will create a log for each table that is being loaded.
You can use this option to pause the table replication process. However, this option will not delete the trigger from the source and recording will continue. Information is still moved to a logging table.
This option stops the replication of a table and removes the trigger from the source.
You can restart the replication of a suspended table using this option.
How to Connect a non-SAP System to SAP HANA with SLT
Part of the SAP HANA SLT configuration may involve connecting a non-SAP system to SAP HANA. This process is outlined in the following steps:
- Input your credentials to log on to your SLT system.
- Check the icon to add a ‘Database Connection.’
- Choose the type of database you wish to add.
- Enter the required data into the appropriate fields.
- Click the ‘Test’ icon to test your new connection.
- If the test is successful, save your work.
- You can now create a schema using the process outlined in the previous section.
The SAP HANA SLT configuration process may seem daunting at first, but you can achieve it if you understand the basics of the architecture and the steps you need to take to replicate data within SAP and non-SAP systems. Please share your experiences on SLT with us in the section below.