Skip to Content
Author's profile photo Karthik S J

A look into the new Data Workbench application

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.

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Simon van der Worp
      Simon 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

      Author's profile photo Priyal Choubey
      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

       

       

      Author's profile photo Alupoaei Petronela
      Alupoaei Petronela

      hi,

      it is not working.

      I tried to delete a business partner , first I received the error that the business partner cannot  be deleted because is active then I changed the status from active to obsolete and tried again. this time the message was that the BP cannot be deleted because is obsolete, then I changed the status to blocked , try again, didn’t worked because of the status. any idea ?

      KR,

      Author's profile photo Heiko Samlowski
      Heiko Samlowski

      Business Partners can not be deleted at all, except for the case that their status is "In Preparation"! But as soon as they are in any other status you can't change back to this.

      Author's profile photo Alupoaei Petronela
      Alupoaei Petronela

       

      Thank you !

       

      Author's profile photo Dhruvin Mehta
      Dhruvin Mehta

      Hi,

      Thanks for the nice blog, while doing migration of Marketin attributes we selected Insert , so will it replaces the old data saved by employees or will it INSERT the new marketing attributes info?

      Regards,

      Dhruvin

      Author's profile photo Tore Dente
      Tore Dente

      Hi!

      Is it possible to extend the Monitoring?

      I just see the files of the last 2 months but I need all im- and exports.

       

      Thanks in advance

       

      Tore