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

[RiccardoBrogi]

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

 







 

 

2 - On HANA Studio, expand the desired system.

 



 

 

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


 



 

 

 

4 - Select Import Catalog Objects from Current Client and then click on Browse...

 



 

 

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

 



 

 

6 - Click on NEXT.

 



 

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

 



 



 

 

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.


 



 

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

 



 

 

 

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

 

[VikasSingh2]

Useful - thanks a lot for sharing.

[ankur_sharma16]

Thanks for sharing, its really useful.

[christianojos_beltromagal]

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

[BenedictV]

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

Benedict

[Former Member]

works!

[KamalMehta]

Useful.

Thanks for sharing.

Regards

Kamal

[former_member216748]

Thank you.....

[Former Member]

Nice ..Keep Posting

[former_member185177]

Good Job...Nicely presented... 

[MGrob]

Thanks interesting

[Former Member]

Very useful! Thank you very much!

[floK]

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

[Srdjan]

Hi Ricardo,

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

Thanks,

srdjan

[former_member197071]

Thank you for sharing

[former_member312206]

Thank you Ricardo for sharing!

[former_member197071]

Link has stopped working 😞

[Former Member]

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

[bpawanchand]

Hi,

Seems like the download link is not working.

Thanks
Pavan

[RiccardoBrogi]

I have adjusted the link; please try again.

[RiccardoBrogi]

I have adjusted the link; please try again. 

[RiccardoBrogi]

I have adjusted the link; please try again. 

[pfefferf]

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

[Former Member]

Thanks ,Florian.

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

Regards,
Vipul

[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

[Former Member]

I meant www.github.com.

[Former Member]

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

[Former Member]

Help, I need the SFLIGHT.zip file!

[former_member38897]

Anyone knows where can I download it now?

[RiccardoBrogi]

Link adjusted

 

[RiccardoBrogi]

Link adjusted

[former_member38897]

Thanks for sharing!

 

[former_member210565]

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

[former_member210565]

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!!!

[termanico]

Thanks Riccardo - very helpful!

[Dan_vL]

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-compute...