Skip to Content
Author's profile photo Former Member

SAP DataServices 4.2 Transports Re-Deployment Issues

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.



è  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:






Assigned Tags

      No comments
      Comments are closed.