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.
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.
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..
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.
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.
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.
For more detailed information on data workbench, please refer to the guide published on SAP Service Marketplace.
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
Hi Simon,
Below are the steps to delete the records:-
Detailed steps are available at below link.
https://uacp2.hana.ondemand.com/viewer/62f53489488a4b7ba86dcaa622c83a58/1705/en-US/9361c8a265c3487cac53efb81136fdef.html
Regards
Priyal
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,
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.
Thank you !
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
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