cancel
Showing results for 
Search instead for 
Did you mean: 

Replicate SAP ECC tables to AWS HANA box

Former Member
0 Kudos

Dear Juergen,

It would be really great if you could replicated the ECC tables into AWS HANA offering using some sandbox or IDES solution at your end.

As you are aware, most of us who subscribe to this are senior architects who would not like to waste valuable time on creating tables and uploading data.

Could you help us in this regard or take it forward somehow.

//BR,

Srikanth

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi, it is a great idea to make some high profile standard SAP tables available.

HINT --> When you import the data, just remember to check the lengths of the data in the columns with varchar definitions. The initial varchar length is calculated from the data cached in the import wizard, and may not be representative of the longest length.

Looking forward to it

David

Former Member
0 Kudos

I need a cloud environment with SAP ECC on it that I can connect to using the SAP .NET Connector (I am a Microsoft developer). I see there is an AWS option for SAP Hana and it led me to this post.

Is this thread for people looking for a cloud based SAP Hana instance that has ECC preloaded onto it with sample data? Or do the posters here already own ECC. I am looking for a sandbox in which to play in that has ECC preloaded with some sample data but I do not own any SAP licenses and I'm not a customer.

Am i asking for the impossible?

Former Member
0 Kudos

I have same issue as below:

SAP DBTech JDBC: [2048]: column store error: table import failed:

  [30138] No such schema in the import path. Try 'IMPORT ALL...'

to import objects from all schemas.;object=SFLIGHT:*en

Anyone meet same issue ? How can I fix it?

Former Member
0 Kudos

I have solved the issue, Just upgrade your hana studio client to the latest version.

Former Member
0 Kudos

I have solved the issue, Just upgrade your hana studio client to the latest version.

Former Member
0 Kudos

Hi all,

message understood. We will make some ECC tables available for download shortly.

--Juergen

Former Member
0 Kudos

Hi,

I have created an image instance yesterday but I could not see any ECC tables? When do you think it will happen.

Thanks

Sree

Former Member
0 Kudos

Hi Juergen,

I now managed to get the sflight.zip from http://help.sap.com/hana/hana_dev_en.pdf and trying to import it. However it fails saying " SAP DBTech JDBC: [2048] (at 39): column store error: table import failed:  [30138] No such schema in the import path. Try 'IMPORT ALL...' to import objects from all schemas.;index=SFLIGHT:*en".

I tried granting permission 777 to hdbadm user, but in vain.

Help appreciated.

//BR,

Srikanth

Former Member
0 Kudos

Hi Srikanth,

Here's how you load the sflight tables into your AWS instance. For further background, please see the HANA SQL Reference Guide and also

  1. Upload the sflight.zip to your HANA AWS box. From Linux/Mac, you can simply use sftp: sftp -oIdentityFile=<your_key_pair>.pem -oUser=root <your_elastic_ip>
    From Windows, you need an sftp client, such as psftp (find it on the puTTY download pages) or the client you prefer.
  2. logon to your image via SSH (see Part 5 of the )
  3. create a root folder for files you want to load, e.g. /sap/data (mkdir /sap/data)
  4. inside /sap/data (or whatever you used), create a sub-directory sflight (mkdir /sap/data/sflight)
  5. put the sflight.zip into the sflight directory (mv sflight.zip /sap/data/sflight)
  6. unzip the file (unzip sflight.zip)
  7. check if a sub-directory index has be created (ls)
  8. so save space on your image, delete the zip file (rm sflight.zip)
  9. go to HANA Studio
  10. Choose File -> Import... from the main menu
  11. On the popup, choose SAP HANA Studio -> Tables and click Next >
  12. as location, enter the path to the sflight directory, e.g. /sap/data/sflight, and click Next >
    it needs to be the directory that contains the sub-directory index
  13. in the left text box, replace the pre-selected text with SFLIGHT.* and click Add
  14. Verify that * (SFLIGHT) is shown in the right panel and click Next >
  15. Enter a reasonable number as parallel threads. The number of virtual cores on your image is a good number. Don't worry too much about it, the SFLIGHT example is fairly small and should load in just a few seconds. Click Finish
  16. Refresh the Catalog node in the Navigator View and check if a new schema SFLIGHT has been created
  17. Have fun working through the tutorial...

hth

--Juergen

Former Member
0 Kudos

Hi Srikanth,

We can make a couple of ECC tables available for import and even pre-load there in a later version of the image.

@all - what do others think? Would pre-loaded ECC data be helpful?

--Juergen

Former Member
0 Kudos

Hi Juergen,

Appreciate your positive reply.

That would be really excellent. Especially when we have business cases that can best fit HANA, we need some proactive work on these tables to showcase the power of HANA to our business users, which motivates them to invest further in HANA.

Its not a big deal technically, you could replicate some IDES data from core R/3 tables like, VBAK, VBAP, EKKO, EKPO, EKKN, MARA, MARC, LIKP, LIPS, MKPF and MSEG.

//Srikanth

Former Member
0 Kudos

Hi,

I agree. This will save a lot of time for us and we can concentrate on important things rathar than just creating tables and inserting data into it.

** Surendra kumar

Former Member
0 Kudos

Dear Juergen

It will be wonderful to have the above mentioned SAP tables replicated and made available for the AWS HANA to make the best use of the HANA server availability.

**Sundar Dittakavi