Skip to Content

Pushing data from ECC to a HANA Schema without using BODS

Oct 10, 2017 at 11:43 AM


avatar image

Hi Experts,

I have a requirement and the process is as below. The idea of creating a file and pushing it to the new schema is to remove the BODS connection ( a customer reqmnt.). Previously this conversion and the push to schema as done by BODS directly. The steps planned is as noted below.

1. A HANA BI report would dump a CSV file in FTP folder (instead of pushing to BODS)

2. This CSV in FTP folder is to be fetched, data transformation and conversion are done, in ECC using ABAP and the data is to be passed to a Schema in HANA.

3. For this, the data from csv file of FTP folder is covnerted and pushed to a custom table, which is to be used update the schema in HANA.

So query here is on the method to achieve the data insertion process in Schema from ECC system, - if the schema can directly be updated from custom table in ECC and custom table cleared each time OR if the data can soemhow be passed from custom table (which i am sure, can be accessed in HANA too) and the schema updated.

COuld you please drop in your suggestion on how this can be achieved, if

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kris Stono Oct 10, 2017 at 02:20 PM


Do you have an SLT in place at all? If not, then maybe you can do this manually/ABAP.

Quite hard to answer without knowing the system landscape, but in theory, you could create a new schema directly in HANA and then create a DB connection to the schema from within ECC (DBCON). Then use this connection within your ABAP to write to the HANA table in your HANA Schema. You will probably need to store the 'schema.table' parameter somewhere.

Just a theory and I am sure there are probably good reasons as to why you don't want to do this :-)



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hey Kris,

No, We dont SLT in place. Hence we are working on an alternative approach.