Skip to Content

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!

 

To report this post you need to login first.

31 Comments

You must be Logged on to comment or reply to a post.

  1. Vipul Trivedi

    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

    (0) 

Leave a Reply