Skip to Content
Author's profile photo Riccardo Brogi

HOWTO – Import SFLIGHT sample data into HANA from a local computer

As you discovered few seconds ago, HANA doesn’t come with any preloaded sample data.

So, before starting to play with your brand new system, you need to find and load some data.

 

Luckily SAP provides for free its flight data model (you can download it here) – it’s a good starting point since it contains a sufficient amount of data and a limited number of tables.

 

In the next steps I’m going to explain (or better I’m going to try) how you can import SFLIGHT into HANA System directly from your local machine.

 

 

1 – Unzip the SFLIGHT archive

 

/wp-content/uploads/2013/05/1_218107.png

/wp-content/uploads/2013/05/2_218135.png

/wp-content/uploads/2013/05/3_218136.png

 

 

2 – On HANA Studio, expand the desired system.

 

/wp-content/uploads/2013/05/4_218137.png

 

 

3 – Right click on the folder Catalog and then click on Import.

 

/wp-content/uploads/2013/05/5_218138.png

 

 

 

4 – Select Import Catalog Objects from Current Client and then click on Browse…

 

/wp-content/uploads/2013/05/6_218139.png

 

 

5 – Navigate to the folder where you previously extraceted the SFLIGHT archive; select the unzipped folder and click on OK.

 

/wp-content/uploads/2013/05/7_218140.png

 

 

6 – Click on NEXT.

 

/wp-content/uploads/2013/05/8_218141.png

 

7 – Select all (CTRL + A) the items showed on the left and click on Add.

 

/wp-content/uploads/2013/05/9_218142.png

 

/wp-content/uploads/2013/05/10_218143.png

 

 

8 – Click on Next.
9 – To import tables and the corresponding data, select Catalog and Data and then set a convenient Number of Parallel Threads; click on Finish.

 

/wp-content/uploads/2013/05/11_218144.png

 

10 – The procedure will run for few seconds but, at the end, refreshing (F5) the Navigator View, the SFLIGHT schema will “magically” appear.

 

/wp-content/uploads/2013/05/12_218145.png

 

 

 

Now you’re ready to start the exploration of SAP HANA. Have fun!

 

Assigned Tags

      35 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vikas Singh
      Vikas Singh

      Useful - thanks a lot for sharing.

      Author's profile photo Ankur Sharma
      Ankur Sharma

      Thanks for sharing, its really useful.

      Author's profile photo Christiano José Beltrão Magalhães
      Christiano José Beltrão Magalhães

      Very good....great for training !!! thank you !!!!

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Thanks Riccardo, that was real useful. I was using the eFashion data which is not much and creating my own data till now.

       

      Benedict

      Author's profile photo Former Member
      Former Member

      works!

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Useful.

      Thanks for sharing.

       

      Regards

      Kamal

      Author's profile photo Kris nh
      Kris nh

      Thank you.....

      Author's profile photo Former Member
      Former Member

      Nice ..Keep Posting

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good Job...Nicely presented... 

      Author's profile photo Martin Grob
      Martin Grob

      Thanks interesting

      Author's profile photo Former Member
      Former Member

      Very useful! Thank you very much!

      Author's profile photo Florian Keller
      Florian Keller

      Thank you..., worked on my Demo openSUSE HANA propper ;-)....

      Author's profile photo Srdjan Boskovic
      Srdjan Boskovic

      Hi Ricardo,

      which tool to use to create data exports like sflight data model, to export some other data from ABAP?

      Thanks,

      srdjan

      Author's profile photo Ankur Gokhale
      Ankur Gokhale

      Thank you for sharing

      Author's profile photo Rybo Chen
      Rybo Chen

      Thank you Ricardo for sharing!

      Author's profile photo Ankur Gokhale
      Ankur Gokhale

      Link has stopped working 🙁

      Author's profile photo Riccardo Brogi
      Riccardo Brogi
      Blog Post Author

      I have adjusted the link; please try again.

      Author's profile photo Former Member
      Former Member

      Link is not working Link.
      Anyone knows where can I download it now?
       

      Author's profile photo Riccardo Brogi
      Riccardo Brogi
      Blog Post Author

      I have adjusted the link; please try again. 

      Author's profile photo Pavan Chand Bhamidipati
      Pavan Chand Bhamidipati

      Hi,

      Seems like the download link is not working.

      Thanks
      Pavan

      Author's profile photo Riccardo Brogi
      Riccardo Brogi
      Blog Post Author

      I have adjusted the link; please try again. 

      Author's profile photo Florian Pfeffer
      Florian Pfeffer

      Can you please check the link again. The file sharing platform produces unsecure crap the most time.

      Author's profile photo Former Member
      Former Member

      Thanks ,Florian.

      You are right, link does not work anymore.Can anyone please share this file?

      Regards,
      Vipul

      Author's profile photo Former Member
      Former Member

      Hi Ricardo,

      Link is not working. It links to file sharing platform and if I download it from there, it has executable with malicious virus...Is it possible for you to upload and  share this file from Git.com? that will solve problem for ever.

      Regards,
      Vipul

      Author's profile photo Former Member
      Former Member

      I meant www.github.com....

      Author's profile photo Former Member
      Former Member

      No, it´s not working. Anyone knows where can I get sflight.zip?
       

      Author's profile photo Former Member
      Former Member

      Help, I need the SFLIGHT.zip file!

      Author's profile photo Riccardo Brogi
      Riccardo Brogi
      Blog Post Author

      Link adjusted

      Author's profile photo Nestor Rodriguez
      Nestor Rodriguez

      Anyone knows where can I download it now?

      Author's profile photo Riccardo Brogi
      Riccardo Brogi
      Blog Post Author

      Link adjusted

       

      Author's profile photo Nestor Rodriguez
      Nestor Rodriguez

      Thanks for sharing!

       

      Author's profile photo Mohamed Hani
      Mohamed Hani

      Hello Ricardo,

      I am trying to import above provide flight data to my HANA XS Advanced express edition instance which is hosted in google cloud. The import is always getting struck in "import catalog objects from C:\temp\sflights Database for HANA\index\SFLIGHT\SB\SBOOK\table.xml"

      Could you please help me on this.

      Thanks,

      Hani

      Author's profile photo Mohamed Hani
      Mohamed Hani

      Data imported. Left the import for half n hour and it got imported :). Apologies for the false alarm. Not deleting the comment as others too might face this delay :). Many thanks Ricardo for SFLIGHT data!!!

      Author's profile photo Thorsten Klingbeil
      Thorsten Klingbeil

      Thanks Riccardo - very helpful!

      Author's profile photo Daniel Van Leeuwen
      Daniel Van Leeuwen

      Thanks Riccardo.  Great blog.

      Here is a version of the zip that works with the Database Explorer in a .tar.gz.

      https://blogs.sap.com/2018/12/18/howto-import-sflight-sample-data-into-sap-hana-from-a-local-computer/