Wednesday, 29 January 2014

Export and Import feature in HANA Studio

This document will help you to understand the various options available under Export and Import in HANA Studio. This is based on current design and may subject to change in future releases of HANA Studio.
Here it goes...
Why do we have Export and Import?
                When the user creates Information Models, Tables, Landscapes and if he wants to move them to different systems (new or existing), instead of recreating everything there in the target, he can simply export them and import it into a target system to reduce the effort of the user. This is similar to transport of objects in BW terms. And also this supports importing of Meta data from other systems as well.
Where to access this?
               Export and Import can be accessed from Quick Launch->Content or through the File menu or through the right click context menu option of tables
1.jpg
 
What are the options available in Export & Import?
Export:
2.jpg
Under SAP HANA Content:
Delivery Unit: A single Unit which can be mapped to multiple packages and can be exported as single entity. So that all the packages assigned to Delivery Unit can be treated as single unit. The user can use this option to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to local Client location. This is kind of “Transport Request” in BW terms.
Developer Mode: This option can be used to export individual objects (Views) to a location in the local system. This can be used only in rare cases.
SAP Support Mode: This can be used to export the objects along with the data for SAP support purposes. This can be used when requested. For Eg, user creates a view which throws up error and he couldn’t able to resolve. In that case he can use this option to export the view along with data and share it with SAP for debugging purpose.
Under SAP HANA Studio:
Landscape: To export the landscape from one system to other (There is already a document talks about this in detail, hence I am not covering here).The link for the document is SAP HANA: importing and exporting Landscapes in HANA STUDIO
Tables: This option can be used to export tables along with its content
 
Import:
3.jpg
Under SAP HANA Content:
Delivery Unit: Exported Delivery Unit can be imported either from HANA Server or from local Client location
Developer Mode: To import the already exported views from the local Client location
Mass Import of Metadata: This option will be used to import the meta data (table definition) from SAP ERP source systems using SAP Load Controller in to HANA, if the user uses Sybase Replication Server for Data Provisioning
Selective Import of Meta Data: This is similar to above but in this case, SAP BO Data Services will be used for Data Provisioning
Under SAP HANA Studio:
Landscape: To import the exported landscape in the target system
Tables: To import the exported tables into target system
 
How to make use of these options?
Export:
Delivery Unit:
Delivery Unit should have been created by user prior to the usage of it. Creation of Delivery Unit can be done through Quick Launch->Setup->Delivery Units…
4.jpg
Once the Delivery Unit is created and the packages assigned to it,
Go to Quick Launch->Content->Export->Delivery Unit->Select the Delivery Unit. The user can see the list of packages assigned to it.
5.jpg
He can export the Delivery Unit either to HANA Server location or to local Client location by selecting through the radio button
6.jpg
The user can restrict the export through “Filter by time” which means Views which are modified within the specified time interval will be exported
Select the Delivery Unit and Export Location and then Click Next->Finish. This will export the selected Delivery Unit to the specified location
Developer Mode:
Go to Quick Launch->Content->Export->Developer Mode->Next
Select the Views to be exported, the user can select individual Views or group of Views and Packages and select the local Client location for export and Finish
7.jpg
SAP Support Mode:
Go to Quick Launch->Content->Export->SAP Support Mode->Next
8.jpg
Select the View that need to be debugged by SAP Support. This will export the View along with the table data it refers to. This will be directly exported to HANA Server “backup” location
Landscape: It’s already discussed in other Document as I mentioned earlier
Tables:
This is already discussed @ http://scn.sap.com/docs/DOC-26312
Import:
Delivery Unit:
Go to Quick Launch->Content->Import->Delivery Unit->Next and select the Delivery Unit (from HANA Server or from Local Client)
9.jpg
Here, the user can select “Overwrite inactive versions” which means that if there are any inactive version of objects (from previous import) exist those will be overwritten. If the user  select “Activate objects”, then after the import, all the imported objects will be activated by default, the user no need to trigger the activation manually for the imported views.
Developer Mode:
Go to Quick Launch->Content->Import->Developer Mode->Next
10.jpg
Browse for the Local Client location where the views are exported and select the views to be imported, the user can select individual Views or group of Views and Packages and Click Finish
The user can select “Overwrite Existing Objects” to overwrite already imported objects, if any.
Mass Import of Metadata:
Go to Quick Launch->Content->Import->Mass Import of Metadata ->Next and select the target system
Configure the System for Mass Import and click Finish
11.jpg
Selective Import of Metadata:
Go to Quick Launch->Content->Import->Selective Import of Metadata ->Next and select the target system
Select the Source Connection of type “SAP Applications”. Remember that the DataStore should have been created already of type SAP Applications->Click Next
12.jpg
Now select the tables (User can also search for table here) and the target schema to import the Meta data and click Next
Validate if needed and click Finish
13.jpg
Import of Landscape and Tables are in a similar way. Hence not discussing about them here.
You "may" expect a provision to import the data directly from flat file(excel or csv), through this import option into HANA, in the future releases of HANA Studio.

Hope this document helps to understand the Import and Export feature of HANA Studio.

31 comments:

  1. Thank you so much for this useful article.
    Also you can check the following sites for sap basis info.
    www.sapbasisinfo.com

    ReplyDelete
  2. sap hana online training| sap hana training| call us+ ...
    www.21cssindia.com/courses/sap-hana-online-training-58.html
    Sap Hana Training in Hyderabad , Sap Hana Online Training in Hyderabad , Sap hana in visakhapatnam, Sap Hana online training in visakhapatnam, Sap ...

    ReplyDelete
  3. Thanks for Information SAP Basis is the ERP application

    (enterprise resource planning) software manufactured by

    SAP AG that targets business software requirements of

    midsize and large organizations in all industries and

    sectors. SAP Basis also provides a layer of abstraction

    between the business applications and the operating

    system and database.SAP BASIS Online Training

    ReplyDelete
  4. Thanks for the tech support blog,very nice news . I have read complete blog and get more information from your blog...

    ReplyDelete
  5. Hi....!
    Content is genune and useful for every new learners and we Hyderabadsys Online Training offering SAP BASIS Online Training.

    ReplyDelete
  6. Thanks for sharing this blog. This is so informative blog
    Learned a lot of new things from your post
    SAP Basis training institutes in Noida

    ReplyDelete
  7. Useful Information, your blog is sharing unique information....
    Thanks for sharing!!!
    SAP HANA Export & Import

    ReplyDelete
  8. I appreciate this piece of useful information. We are Help of Tradeskill you can learn how to start your export business, We provide you a facility to learn Export Import Business Online For more information visit our site: Import Export Classes Online

    ReplyDelete
  9. I appreciate this piece of useful information. We are provide Export Import Course Online Training Certificate |how to start export business For more information visit our site: Import Export Online Training

    ReplyDelete
  10. I appreciate this piece of useful information. We are Provides Online Course for Export Import Business, With our online training Certification Program you will learn how to Start Export Import Business For more information visit our site: Export Import Certificate Course Online

    ReplyDelete
  11. I appreciate this piece of useful information. We are Provides Online Course for Export Import Business, With our online training Certification Program you will learn how to Start Export Import Business For more information visit our site: Export Import Certificate Course Online

    ReplyDelete
  12. I appreciate this piece of useful information. We are Provides Online Course for Export
    Import Business, With our online training Certification Program you will learn how to Start Export Import Business For more information visit our site: Import Export Course Online

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. Hello Dear,
    Thank you so much for this useful article sharing with me. I like this article because it articles the most important information. This is similar to the transport of objects in BW terms. And also this supports importing Metadata from other systems as well. Also, you check the following sites for Server Hosting basic info. then you can grow your business because USA VPS Server gives you amazing services with the latest technology then you can choose USA VPS services and grow your business.

    ReplyDelete
  15. I am too glad to read this kind of very nice info article. Thanks for sharing this with us. I like this information about export and import. It's a very helpful blog. This is similar to the transport of objects in BW terms. And also this supports importing of Meta data from other systems as well. If you want to online import and export. Then can choose now UK VPS Hosting plans. UK VPS Hosting is better for online marketing & website. for more info contact Onlive Server

    ReplyDelete
  16. online exim
    EVERYTHING ABOUT EXPORT IMPORT. We are Providing All Topic Videos; We are Providing Online Training; We are Providing Offline Training.
    to get more - <a href="https://onlineexim.com/"https://onlineexim.com/

    ReplyDelete
  17. 360 Degree Image Editing Service Are you looking at the ghost mannequin effect service? We provide the invisible man9 November 2021 at 02:04

    online exim
    EVERYTHING ABOUT EXPORT IMPORT. We are Providing All Topic Videos; We are Providing Online Training; We are Providing Offline Training. -<ahref="https://onlineexim.com/https://onlineexim.com/l</a

    ReplyDelete
  18. 360 Degree Image Editing Service Are you looking at the ghost mannequin effect service? We provide the invisible man14 November 2021 at 23:04

    import export training online
    Export Import Practical Training - Special 5-day Sunday batch. This is India's best practical training course specially design for who want to start or Learn export import business. - <a href="https://www.onlineexim.com/export-importracticaltraining.php/www.onlineexim.com/export-import-practical-training.phpl</a

    ReplyDelete
  19. 360 Degree Image Editing Service Are you looking at the ghost mannequin effect service? We provide the invisible man14 November 2021 at 23:25

    import export consultancy services
    OnlineExim.com is an established and reputed Import Export Consultant and Import-Export Service provider across the globe. We are providing IEC, RCMC, Digital Signature and other additional services. - <a href="https://www.onlineexim.com/export-importracticaltraining.php/www.onlineexim.com/export-import-practical-training.phpl</a

    ReplyDelete
  20. export import training<a href="https://www.onlineexim.com/export-import-practical-training.php/https://www.onlineexim.com/export-import-practical-training.php</a

    ReplyDelete
  21. Sap Basis: Export And Import Feature In Hana Studio >>>>> Download Now

    >>>>> Download Full

    Sap Basis: Export And Import Feature In Hana Studio >>>>> Download LINK

    >>>>> Download Now

    Sap Basis: Export And Import Feature In Hana Studio >>>>> Download Full

    >>>>> Download LINK uz

    ReplyDelete
  22. Thank you for sharing this blog. I find it incredibly useful, and I'll be sure to recommend it to my friends. I am associated with Yeshasvi Exporters Private Limited, a prominent export company based in India.

    Discover India’s Best Leading Exporters, your Trusted Partner for Seamless International Trade. As the Most Trusted Leading Exporters in India, we excel as Emerging Indian Exporters. With unparalleled quality and reliability, we stand as India’s Best Leading and Most Trusted Exporters. Choose us, your Top Indian Exporters, for a world-class exporting experience.

    ReplyDelete