Data Load from SAP ECC to SAP HANA
This a workaround to connect the SAP system as source and SAP HANA as target, establish connections using data services data stores
and identify the issues that incurs during the process.
Creating a Data store to connect to ECC system:
In the Advance section,
Creating a Data store to connect to HANA system:
After successful creating of both the data stores, import the respective source and target tables
è Create a Job followed data store. Drag the source table, use query transform, map required fields to the output schema, connect to the target table, validate and execute.
è
AAAfter successful execution of the job, record count can be seen in the monitor log as shown below.
ISSUES:
è Make sure to have read and write access to the working directory from BODS System.
Working directory: E:\usr\sap\XYZ\ABCDEF\work
è If in case of any issues, follow up with the basis team.
è Make sure both BODS and ECC are in same domain. The users can be added from one system to another system if they are in same system.
è For the current version BODS 4.2, Had an issue with the transport files. For the same, found a note -1916294.
è Basis team implemented the above note.
è After implementing the above note, got the below issue when executed the job
è For the above issue, basis team granted permission to the functional module \BODS\RFC_ABAP_INSTALL_AND_RUN
èMake sure that the account has the following authorizations:
*S_DEVELOP
*S_BTCH_JOB
*S_RFC
*S_TABU_DIS
*S_TCODE
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |