Skip to Content

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:

ECC_conn.jpg

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:

HANA_conn.jpg

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.

Conn_flow.png

è

AAAfter successful execution of the job, record count can be seen in the monitor log as shown below.

Dataload.png

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.

/wp-content/uploads/2014/06/note_484270.jpg

è  Basis team implemented the above note.

è  After implementing the above note, got the below issue when executed the job

RFC.jpg

è  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

To report this post you need to login first.