Overview

Data migration is a key activity when adopting a cloud software. We recognize that there can be multiple sources where the data is residing but ultimately whatever the source is, the data migration tool within the application needs to be easy, intuitive and have high performance. This is why we re-designed the entire data migration experience to bring in Data Workbench, a tool that was built from the ground up and is a highly scalable and efficient data migration tool purpose built for SAP Hybris Cloud for Customer.

Use-Cases

Data Workbench can be used for any data import activity from SAP on-premise/Cloud or 3rd party on-premise/Cloud applications. Data can be imported using a CSV format. To make it easier for the consumer, Data Workbench offers pre-defined templates to eliminate mapping effort or you have the flexibility to choose any CSV format and manually map it to the C4C application fields.

/wp-content/uploads/2016/07/dw1_1003115.png

Key Capabilities

1.       Simple and Secure

Data Workbench offers a simple user interface for business administrators to securely connect to the application for data migration.  Using Data workbench you have access to the complete range of CRUD (create, read, update, delete) operations that have been organized around Import, Export & Monitor on the user interface.  The tool is also available for use in the latest Responsive User interface technology of Cloud for Customer.

/wp-content/uploads/2016/07/dw2_1003116.png

2.       Comprehensive Coverage

Data migration can be implemented for most of the underlying standard business objects from core master data to transactions in SAP Hybris Cloud for Customer platform.  In addition to standard business objects the tool also supports attachments and custom business objects that were created using the  Key User Tool (KUT) or platform development infrastructure (PDI) and extension fields that were created using KUT..

/wp-content/uploads/2016/07/dw3_1003117.png

3.       Intuitive and Intelligent Mapping

Data workbenchuses the best-in-class data mapper capability offered from the SAP HANA Cloud Platform to map and execute data transformations from the CSV source to the Cloud for Customer application destination.  The data mapper is intelligent, visual and can auto-suggest fields if they have the same semantic and syntax.

/wp-content/uploads/2016/07/dw4_1003118.png

4.       Efficient and flexible

Templates are offered to improve efficiency on repetitive data loading activities. For example, if the data records are refreshed every month, you can save your mapping work as a template for future use and don’t need to start from scratch. Templates are also a great way to standardize the fields that are imported across your organization. For example each region can use the same template to ensure data consistency. Data workbench also offers flexibility in defining their own templates and code list mapping.

/wp-content/uploads/2016/07/dw5_1003119.png

5.       High performance, scalable and simulation driven architecture

It is recommended to import a maximum of 50,000 records for each run. This is suggested for optimal performance throughput and also in order to fix validation issues that may arise during import.  This is where the simulation capability comes in and is a great option that allows administrators to view the records in preview mode before they have been physically imported into the SAP HANA database. During the simulation mode, the user can manually adjust errors if they do arise during import.

/wp-content/uploads/2016/07/dw6_1003120.png

For more detailed information on data workbench, please refer to the guide published on SAP Service Marketplace.

To report this post you need to login first.

2 Comments

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

  1. S. van der Worp

    Hi Karthik,

    Great blog!! I do have one question; in which way I can delete records using the Data Workbench.

    I created a custom object via the custom object builder but I also want to be able to delete records from this custom object.

    KR,

    Simon

    (0) 
    1. Priyal Choubey

      Hi Simon,

       

      Below are the steps to delete the records:-

      1. Export the data which needs to be deleted.
      2. Open the exported file with csv editor and add a column “ToBeDeleted” at the end maintain value as true. 
      3. Then update the data using “Update” work center view.

      Detailed steps are available at below link.

      https://uacp2.hana.ondemand.com/viewer/62f53489488a4b7ba86dcaa622c83a58/1705/en-US/9361c8a265c3487cac53efb81136fdef.html

      Regards

      Priyal

       

       

      (0) 

Leave a Reply