SAP DataServices 4.2 Transports Re-Deployment Issues

[Former Member]

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:

• Right click in the data store tab
• Data store name: Provide meaningful name
• Data Store Type:  Select SAP Application from the drop down
• Database Server Name:  Enter provided server name
• User Name:
• Password:

In the Advance section,

• Data transfer method: Select Shared directory( in my case)
• Note: Select RFC, if RFC connection is established.
• Working Directory on SAP Server:  Provide the working directory path.
• Application path to shared directory: Path on your local Directory.

Creating a Data store to connect to HANA system: 

• Data store name: Provide meaningful name
• Data Store Type:  Select ‘Database’ from the drop down
• Database Type:  SAP HANA
• Database Version: HANA1.X
• Select the check box ‘Use data store name (DSN)’
• Data source Name:
• User Name:
• Password:

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