Data provisioning from source ABAP ECC system to SAP HANA system using SAP Solution Manager.
Requirement : We want to perform data provisioning from our source ABAP system to SAP HANA System.
Scenario: We have following scenario :
Source System : ABAP - K68
SLT Server : ABAP - B30 , it is a Solution Manager system.
Target System : SAP HANA (hostname : hanahost)
1. Install DMIS add-on on SLT server and Source system.
We need to install DMIS add-on on the source and SLT server. We have installed following component using SAINT on ABAP stack. More information about SLT Add-on can be found on SAP Note# 1465272.
Even though SAP Note says we need to install both DMIS and SHC_CONT add-on , but it was not mandatory to install SHC_CONT add-on in our scenario , But we still went ahead and installed SHC_CONT on our Solman System (SLT Server). We did not installed SHC_CONT on Source ABAP system(K68).
2. Create RFC connection to Source SAP system from SLT Server.
We need to create RFC connection in SLT Server system(B30) to fetch data from Source ABAP system.We created K68CLNT100 in B30. Make sure the user specified in B30 has required SLT specific privileges in source ABAP system. For more information refer SAP Note 1972009.
SAP guide suggest to use LTR transaction to setup SLT on SLT Server(Solman System) , but we were getting following "Service Cannot be reached" error.
We tried all available solutions , like activating all SLT specific services , but no luck.
There is another transaction LTRC, which can also be used to perform SLT configuration as LTR. LTRC is ABAP based transaction.
For our scenario LTRC will work similar to LTR transaction.
Step 1: Execute LTRC and press create button(shown below).
Step 2: Provide a name for the configuration.
Please note : A schema with the same name will be created in HANA system, in our case we should see a schema name as "Test".
Step 3: Fill in the source system RFC detail as shown below.
Step 4: Fill in the HANA connection details(shown below).
Step 5: Specify the number of jobs for data replication . For more information on the SLT sizing and number of jobs refer SAP Note 1972009.
Step 6 : Review and press Create.
Now it will create a SLT configuration for you.
Please note : Only one configuration per source and target system combination can be crated on SLT server.
Now we will go to HANA system to check the status and specify the tables that we want to replicate.
Connect to HANA studio and verify the schema presence. We should see a schema in HANA with the name of "Test" and by default it will have SAP ABAP data dictionary tables created.
Now we will configure the tables that we went to fetch from Source system , for that go to "SAP HANA Modeler" prospective and from Quick view click "Data Provisioning".
This will launch Data Provisioning UI in HANA studio and by default you will see three ABAP data dictionary related tables (DD*) in replication status.
Now press the "Replicate" button and we will select a sample table(TBTCO , AGR*) to replicate.
Once we select the table , it will start replicating.
SAP Note 1465272 - SAP Landscape Transformation Software - Central note
SAP Note 1972009 - How to create an SLT Configuration Step-by-Step