Skip to Content
avatar image
Former Member

Replicate SAP ECC tables to AWS HANA box

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 06, 2012 at 05:53 AM

    Hi all,

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

    --Juergen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Jun 03, 2012 at 07:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Jun 05, 2012 at 08:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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 How to load CSV files into HANA

      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 How to create a SAP HANA Developer Edition in the cloud)
      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

  • avatar image
    Former Member
    Nov 27, 2012 at 08:00 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2012 at 09:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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?