HH

Download as pdf or txt
Download as pdf or txt
You are on page 1of 48

© 2019 SAP SE or an SAP affiliate company. All rights reserved.

PUBLIC
2019-11-27

Data Workbench

THE BEST RUN


Content

1 Data Workbench. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
1.1 Data Preparation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1.2 Quick Search. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
1.3 Import. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Import - Complete Business Object. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
Import - Individual Business Object. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Import Attachments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
ID Mapping. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
1.4 Export. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
1.5 Migration Templates. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Manage Migration Templates. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Migration Template Usage Across SAP Cloud for Customer Tenants. . . . . . . . . . . . . . . . . . . . . . 30
1.6 Monitor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31

2 Object Documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

3 List of Objects Available in Data Workbench. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .34

4 Frequently Asked Questions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38

5 Support Incidents. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39

6 Data Workbench APIs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40


6.1 Data Workbench Authentication API. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40
6.2 Data Workbench Template API. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
6.3 Data Workbench Import API. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
6.4 Monitor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

Data Workbench
2 PUBLIC Content
1 Data Workbench

Introduction

This document describes features available in Data Workbench, and takes you through the process of
importing data into and exporting your data from SAP Cloud for Customer.

You can use Data Workbench to import the following:

● Data from a legacy system into SAP Cloud for Customer. For example, you want to transfer all the existing
data from any Cloud CRM system to SAP Cloud for Customer.
● Operational data from third-party systems into SAP Cloud for Customer. For example, import accounts
and contacts from Microsoft Outlook to SAP Cloud for Customer
● Data that is manually maintained in a CSV file (data file) into SAP Cloud for Customer. For example, sales
lead data collected from a campaign and maintained in a data file.

 Note

Data Workbench is available only in SAP Fiori client version of SAP Cloud for Customer. It is not available on
mobile devices.

Target Audience for this Document

This document serves to enable the following users.

Data Workbench
Data Workbench PUBLIC 3
User Role and Tasks

Key User As an administrator, you are expected to understand the fol­


lowing:

● Your business requirement and knowing what data is to


be migrated into SAP Cloud for Customer.
● The sequence in which the objects and the nodes
should be imported. For information on each of the ob­
jects, see object documentation.
● The mapping of your fields with the fields in SAP Cloud
for Customer

Typical tasks include:

● Prepare your data to an accepted format.


● Creating templates for various objects and nodes.
● Import, export, and update data.

Business User Typical tasks include:

● Import complete business object


● Import data using a template
● Import attachments
● Export data
● Update data

Prerequisites

Fulfill all the requirements in this checklist before you use Data Workbench.

Data Workbench
4 PUBLIC Data Workbench
Type Task

Technical For each of the objects you want to import data, you have
data files for all the nodes in that object.

Here is an example of node dependency in Opportunity ob­

ject: Opportunity Opportunity Product Opportunity

Product Notes .

 Note
Ensure that you have separate data files for each of
these nodes.

These CSV files (data files) can be files downloaded from a


system or files you have maintained manually. To check if the
file is in an acceptable format, do the following:

1. Open the CSV file in Notepad.

2. Click File Save As


3. In the Save As dialog, choose Encoding as UTF-8. Keep
the file extension as .CSV.
4. Once the file is saved, check if the content is displayed
correctly.

 Note
For complete business object import, archive your CSV
files into a ZIP file.

Functional You understand the business requirement of the data to be


imported into SAP Cloud for Customer

For each object you want to import data into, you under­
stand the dependency within the object section of the re­
spective object document. For more information, see object
documentation.

Limitations

1. Data Workbench does not support communication with external systems.


2. Data Workbench Import does not support replace of existing records.
3. Any changes to branding such as themes or other customizations are not applied to Data Workbench user
interface.
4. Data Workbench does not support UI extensions

Data Workbench
Data Workbench PUBLIC 5
Configuration

To set up the following scoping questions in Data Workbench, navigate to Business Configuration
Implementation Projects Edit Project Scope Built-in Services and Support Business Configuration Data
Workbench .

Review the following questions.

Do you want to enable complete business object import?

Do you want to enable attachment import?

Do you want to enable ID mapping?

1.1 Data Preparation

Overview

The data that is either downloaded from a legacy system, a third-party system, or manually maintained in a
data file, should be cleansed before it can be successfully imported into SAP Cloud for Customer. For example,
you need to ensure that all the reference IDs are maintained based on the dependency, and also check if the
data is in acceptable formats.

Limitations

● In your data file, the following limitations apply:


○ Maximum number of records: 50,000
○ CSV size limit: 10 MB
● For attachment import, the following limitations apply:
○ Individual attachment size limit: 10 MB
○ Zip file size limit: 100 MB

 Note

For import of a large file (greater than 10 MB or more than 50,000 records), we recommend that you
split your data into multiple data files and then import. Also, to achieve high performance throughput,
we recommend you to import a maximum of two data files at a time.

● While preparing data files, follow CSV Specifications .

Data Workbench
6 PUBLIC Data Workbench
Instructions

● Use headers without spaces.


For example, for the column Opportunity Type, use header names OpportunityType or Opportunity_Type.
● For date fields, follow these instructions:
○ Use format yyyy-mm-dd. For example, 2015-11-25.
○ To import a timestamp field, use format 2015-11-25Thh:mm:ss

 Note

Enter UTC time.

● If you have a Boolean entry, ensure that the value is entered either as true or false in small case.

Accepted Values

○ true
○ True
○ TRUE

○ false
○ False
○ FALSE

 Note

Any blank boolean field is treated as undefined.

● Columns with numbers that are treated as text.


Data of a few columns that display numbers may need to be treated as text. For example, code list values
for ActivityGroupCode. Here, the value 0001 is the code, and 1 would not be an accepted code value.

ActivityGroupCode Description

0001 Customer visit

0002 Telephone Call

0003 Business email

0004 Workshop

0005 Customer Request

 Remember

It is recommended to use any notepad application to modify the CSV data file before importing in Data
Workbench tool. This would avoid any format changes to the CSV data file.

Data Workbench
Data Workbench PUBLIC 7
When using any excel application to modify the CSV data file, make sure to import the .csv file using
UTF-8 character encoding.

● Properties of type UUID (Edm.guid in OData Service) are not supported and therefore not a part of Import
template.

Instructions - Import Complete Business Object

When you are importing a complete business object, you must maintain unique external keys for all records.

For example, if the hierarchy of import is as seen here: Opportunity Opportunity Item Revenue Plan
Reporting , then ensure the following:

1. Each record in Opportunity data file has a unique external key. See here a sample:

Opportunity_Exter­
nal_Key Sales_Organisation Owner Account Expected_Value

2. Each record in Opportunity Item data file has a unique external key and also refers to the Opportunity
external key. See here a sample:

Opportu­ Negoti­
nity_Item_Exter­ Opportunity_Ex­ Product_Descrip­ Negoti­ ated_Value_Cur­
nal_Key ternal_Key Product tion ated_Value rency

3. Each record in Revenue Plan Reporting data file has a unique external key and refers to the external keys
of both Opportunity and Opportunity Item. See here a sample:

Revenue_Plan_Re­ Opportu­
porting_Exter­ nity_Item_Exter­ Opportunity_Exter­
nal_Key nal_Key nal_Key Employee_ID Distribution_Amount

4. These three data files are in one zip file.

 Note

Import of a sub object (for example: Revenue Plan Reporting) is not possible without the import of its
parent object (Opportunity Item).

Instructions - Import Individual Object

Before you begin, make sure you have the data file for the object (node) you want to import data to.

You can import using External Key or Internal ID.

1. Import with External Key


Ensure that each data file has a reference to all the parent objects in the hierarchy.
For example, if the hierarchy of import is as seen here: Opportunity Opportunity Item Revenue Plan
Reporting , then ensure the following:
1. Each record in Opportunity data file has a unique external key. See here a sample:

Data Workbench
8 PUBLIC Data Workbench
Opportunity_Exter­
nal_Key Sales_Organisation Owner Account Expected_Value

2. Each record in Opportunity Item data file has a unique external key and also refers to the Opportunity
external key. See here a sample:

Opportu­ Negoti­
nity_Item_Exter­ Opportunity_Ex­ Product_De­ Negoti­ ated_Value_Cur­
nal_Key ternal_Key Product scription ated_Value rency

3. Each record in Revenue Plan Reporting data file has a unique external key and refers to the external
keys of both Opportunity and Opportunity Item. See here a sample:

Revenue_Plan_Re­ Opportu­
porting_Exter­ nity_Item_Exter­ Opportunity_Exter­ Distribu­
nal_Key nal_Key nal_Key Employee_ID tion_Amount

2. Import with Internal ID.


During import, you can maintain a reference to the parent object in the sub objects by maintaining an
Internal ID. However, you can maintain references only up to one parent object with an internal ID. If you
want to import more than two levels in a hierarchy, you can import with external keys.
For example, if you are importing Opportunity Item, you can refer an internal ID of Opportunity. See here a
sample:

Opportunity ID Product

Instructions - Update
Before you begin an update, ensure you export the desired data and use the same data file for update.

1.2 Quick Search

You can run a search in this interactive table for Data Workbench keywords.

To request additional keywords to be added here, leave a comment in the Data Workbench Blog .

Data Workbench
Data Workbench PUBLIC 9
Context/When
Keywords Overview to Use

Import Com­ Imports all data To import data


plete Business into a business into a business
Object object. object and its
child items.

Example:

● Opportu­
nity
○ Op­
portu­
nity
Item
○ R
e
v
e
n
u
e
Pl
a
n
R
e
p
o
rt
in
g

Import Individ­ Imports data To import addi­


ual Business into a specific tional data or
Object business object add a child item
or a specific to a previously
child item. imported busi­
ness object.

Insert Data with new To import data


external keys is for the first
created. Any ex­ time.
isting data is re­
jected.

Data Workbench
10 PUBLIC Data Workbench
Context/When
Keywords Overview to Use

Upsert Data with new Use upsert


external keys is when it’s un­
created. Exist­ clear if previ­
ing data is up­ ously imported
dated. data exists.

Update Update existing To update previ­


data using ob­ ously imported
ject IDs. Use an data.
exported data
For update of
file to update.
Individual Ob­
ject, you can ex­
port existing
data into a data
file and use the
data file to up­
date.

Export Extract existing To extract exist­


data. ing data into a
data file, which
you can then
use to update.

Templates Create field To map fields


mapping and and code lists in
code list map­ your existing
ping for import. data file with
the fields in
SAP Cloud for
Customer,
which you can
then use to im­
port multiple
times.

1.3 Import
Once you have prepared the data, you can import it into SAP Cloud for Customer.

If you or another user in your organization is going to import data for the same object later, you can save the
mapping in a template. Mapping template can be created from Migration Templates workcenter view.

Templates store the mapping information between the columns of a data file and the corresponding fields of an
object (node) in SAP Cloud for Customer. Once you define the mapping in a template, the template can be

Data Workbench
Data Workbench PUBLIC 11
used by any SAP Cloud for Customer user to import data anytime. This ensures consistency in mapping across
all users.

 Note

Templates are typically created by a key user or by someone who has a business understanding of the fields
that needs to be mapped between systems.

Import - Complete Business Object [page 12]


Import your data to SAP Cloud for Customer, for a complete business object.

Import - Individual Business Object [page 14]


Import your data to SAP Cloud for Customer, one business object at a time.

Import Attachments [page 21]

ID Mapping [page 23]


This feature is useful if you have used SAP Migration Workbench to migrate your data to SAP Cloud for
Customer.

Data Simulation [page 25]

Initial Load [page 26]

1.3.1 Import - Complete Business Object

Import your data to SAP Cloud for Customer, for a complete business object.

Overview

You can import data of the following to SAP Cloud for Customer:

● Standard business object


● Custom business object

Procedure

1. Go to Data Workbench work center, and choose Import.


2. Select Complete Business Objects.
3. Select the object for which you want to import data.

 Tip

Only root nodes are listed.

4. Download a template. Choose between Comma Separated Values (.csv) and Excel Workbook (.xlsx).
See the following table on where to find the relevant templates.

Data Workbench
12 PUBLIC Data Workbench
What Where It’s Available

Comma-Separated Values (CSV) Excel Workbook

Templates In the folder Templates, you can see The template for each node is availa­
that templates for each node are ble as a worksheet in the excel work­
available as a separate CSV file. book.

Field Definitions In the folder FieldDefinition, you can Field definitions are available as a
see that field definitions for each node worksheet named Field_Definitions,
are available as a separate CSV file. usually the last worksheet in the work­
book.

Code Lists In the folder CodeList, you can see an­ In the folder CodeList, you can see a
other folder named after the node; workbook for each node.
this folder contains code list files.

5. Click Next.
6. Browse for the *.zip data file you want to upload.

 Note

○ The ZIP file size is limited to 10 MB.


○ Maintaining external key is mandatory for import of complete business object.

7. Click Upload, and then either select format validation for Sample Data or for All Data.
Format validation check reports any format errors in the review step before importing data in SAP Cloud
for Customer.
8. Review the summary of your selection.
9. Click Next.
10. Map code values maintained in data file with code values in the system. All the code list properties
applicable for the selected object are displayed.
○ Select a code list. This code list can have multiple values. For example, Salutation code list can have
Mr., Ms., Dr., and Prof.
○ Map the code list values maintained in the data file (external) to the code values in SAP Cloud for
Customer (internal).
○ For all the values in the data file for which no code list value is assigned in SAP Cloud for Customer, you
can assign a default code list value.
○ Repeat the steps for each code list.
○ Alternatively, you can save this code list mapping as a template for future use. You can also map code
lists using the template. Upload the files once you've updated the templates with your code lists.
11. Click Next.
12. Review and click Import.
The system displays a message on the status of the import. You can go to the Monitor view, and check the
status of your import.

 Note

Once data for the business object is successfully imported, the same business object can’t be
reimported. You can then update the business object using Import for Individual Objects.

Data Workbench
Data Workbench PUBLIC 13
Related Information

Data Simulation [page 25]


Initial Load [page 26]
Quick Search [page 9]

1.3.2 Import - Individual Business Object

Import your data to SAP Cloud for Customer, one business object at a time.

Related Information

Manage Migration Templates [page 28]


Export [page 27]
Data Simulation [page 25]
Initial Load [page 26]

1.3.2.1 Insert

You can use this feature to create data. If the external keys in your data file have already been used to import
data, this data is identified as existing data. During insert, any existing data is rejected.

Procedure

1. In Data Workbench, choose Import.


2. Select Individual Objects and then select Insert.
3. You can choose to import data with or without a template.

If You You Can Description

Select a template Download the template details into a This file can be used, for example, to
data file by clicking Download. check if you have maintained your
data in the right format.

Data Workbench
14 PUBLIC Data Workbench
If You You Can Description

Select a template Turn on Review Mapping before Im­ You can:


port ○ Review the field and code list
mapping maintained in the tem­
plate.
○ Update the mappings and your
changes into the template.

 Note
Only key users can review

Select an object Download the object details into a This file can be used, for example, to
CSV file by clicking Download CSV file check if you have maintained your
 Note data in the right format.

Restricted to key users.

4. Click Next.
5. For a selected custom object, if you would like to maintain an external ID in the imported data, a key user
can do either of the following:
○ Select the Business System ID of the external system
○ Create a template with the Business System ID for business users
This is only possible if you have connected the SAP Cloud for Customer system with an external system.

 Note

The Business System ID represents the system that contains the mapping between external and
internal key. If this mapping does not exist in the SAP Cloud for Customer system, then data is not
imported.

If you select a business system ID, then you must have a new column named ExternalKey in the CSV file
with the external ID of each of the records. If the external key does not exist for the imported data, then a
new ID mapping is generated .
6. Select a CSV file for which the data is to be imported for the corresponding object or template. The column
headings and data in this CSV file should be according to the object or template. The supported CSV
delimiters are Comma (,), Tab ( ), Colon (:), Pipe (|), Semi-Colon (;), and Caret (^).
7. Click Upload, and then either select format validation for “Sample Data” or for “All Data” and then click
Next. Format validation check reports any format errors in the review step before importing data in SAP
Cloud for Customer.
8. The next steps depend on your previous selection.

Data Workbench
Data Workbench PUBLIC 15
If you Had Action

Selected an object Using drag and drop feature, manually map the fields in
the CSV file to the appropriate fields in SAP Cloud for
Customer.

 Tip
To delete a mapping, click the mapping line, and press
Del key

Selected a template and turned ON Review Mapping be­ Review the Existing Mapping: Using drag and drop fea­
fore Import ture, update any mapping of the fields in the CSV file to
the appropriate fields in SAP Cloud for Customer.

Selected a template and turned ON Review Mapping be­ Maintain Code List Mapping: All the code lists applicable
fore Import for the mapped fields in the selected object will be dis­
played.
1. Select a code list. This code list can have multiple val­
ues. For example, Salutation code list can have Mr.,
Ms., Dr., and Prof.
2. Maintain the code list mapping between the code list
values in SAP Cloud for Customer (internal) and the
code values maintained in the CSV file (external).
3. For all the values in the CSV file for which there is no
code list value in SAP Cloud for Customer, you may
also maintain a default mapping.
4. Repeat the steps for each of the code lists.
5. You may also save this code list mapping as a tem­
plate for future use.
6. Code list mapping can also be maintained by down­
loading a template CSV file, maintain the mapping &
upload the updated template back.

Selected a template and turned OFF Review Mapping be­ Click Next, and review the summary.
fore Import

9. Review the summary.


10. Click Import.

Data Workbench
16 PUBLIC Data Workbench
1.3.2.2 Upsert

You can use this feature to create data and update existing data. If the external keys in your data file have
already been used to import data, this data is identified as existing data.

Procedure

1. In Data Workbench, choose Import.


2. Select Individual Objects and then select Upsert.
3. You can choose to import data with or without a template.

If You You Can Description

Select a template Download the template details into a This file can be used, for example, to
data file by clicking Download. check if you have maintained your
data in the right format.

Select a template Turn on Review Mapping before Im­ You can:


port ○ Review the field and code list
mapping maintained in the tem­
plate.
○ Update the mappings and your
changes into the template.

 Note
Only key users can review

Select an object Download the object details into a This file can be used, for example, to
CSV file by clicking Download CSV file check if you have maintained your
 Note data in the right format.

Restricted to key users.

4. Click Next.
5. For a selected custom object, if you would like to maintain an external ID in the imported data, a key user
can do either of the following:
○ Select the Business System ID of the external system
○ Create a template with the Business System ID for business users
This is only possible if you have connected the SAP Cloud for Customer system with an external system.

 Note

The Business System ID represents the system that contains the mapping between external and
internal key. If this mapping does not exist in the SAP Cloud for Customer system, then data is not
imported.

Data Workbench
Data Workbench PUBLIC 17
If you select a business system ID, then you must have a new column named ExternalKey in the CSV file
with the external ID of each of the records. If the external key does not exist for the imported data, then a
new ID mapping is generated.
6. Select a CSV file for which the data is to be imported for the corresponding object or template. The column
headings and data in this CSV file should be according to the object or template. The supported CSV
delimiters are Comma (,), Tab ( ), Colon (:), Pipe (|), Semi-Colon (;), and Caret (^).
7. Click Upload, and then either select format validation for “Sample Data” or for “All Data” and then click
Next. Format validation check reports any format errors in the review step before importing data in SAP
Cloud for Customer.
8. The next steps depend on your previous selection.

If you Had Action

Selected an object Using drag and drop feature, manually map the fields in
the CSV file to the appropriate fields in SAP Cloud for
Customer.

 Tip
To delete a mapping, click the mapping line, and press
Del key

Selected a template and turned ON Review Mapping be­ Review the Existing Mapping: Using drag and drop fea­
fore Import ture, update any mapping of the fields in the CSV file to
the appropriate fields in SAP Cloud for Customer.

Selected a template and turned ON Review Mapping be­ Maintain Code List Mapping: All the code lists applicable
fore Import for the mapped fields in the selected object is displayed.
1. Select a code list. This code list can have multiple val­
ues. For example, Salutation code list can have Mr.,
Ms., Dr., and Prof.
2. Maintain the code list mapping between the code list
values in SAP Cloud for Customer (internal) and the
code values maintained in the CSV file (external).
3. For all the values in the CSV file for which there is no
code list value in SAP Cloud for Customer, you may
also maintain a default mapping.
4. Repeat the steps for each of the code lists.
5. You may also save this code list mapping as a tem­
plate for future use.
6. Code list mapping can also be maintained by down­
loading a template CSV file, maintain the mapping &
upload the updated template back.

Selected a template and turned OFF Review Mapping be­ Click Next, and review the summary.
fore Import

9. Review the summary.


10. Click Import.

Data Workbench
18 PUBLIC Data Workbench
1.3.2.3 Update

Use this feature to update your existing data.

This feature offers two approaches. You can update your data using either of the following options:

● Update using Object IDs


● Update using Known IDs

Update Using Object IDs

Overview
To update using object IDs, use an exported data file. You can update data of the following from SAP Cloud for
Customer:

● Standard business object


● Custom business object

Prerequisites
You’ve completed the following:

● Exported data using Data Workbench into a data file


● Updated the data in the data file, and followed these guidelines:

 Note

● If you leave Object ID empty, a new record is created in SAP Cloud for Customer.
● During an update, don’t edit or remove ID fields in the CSV file.

Procedure
1. Go to Data Workbench work center, and choose Import.
2. Select Individual Objects and then select Update.
3. Select the object for which you want to update data.
4. Click Next. Select the data file you want to upload.
5. Click Upload, and then either select format validation for “Sample Data” or for “All Data” and then click
Next. Format validation check reports any format errors in the review step before importing data in SAP
Cloud for Customer.
6. Review the summary of your selection.
7. Click Import.The system displays a message on the status of the import. You can go to the Monitor view,
and check the status of your import.

 Note

○ To delete a record in SAP Cloud for Customer system, add a header ToBeDeleted at end of the
exported CSV data file, and mark the records to be deleted as True.
○ If any record is added in the exported CSV data file, for which ObjectID is empty, it’s created in SAP
Cloud for Customer system.

Data Workbench
Data Workbench PUBLIC 19
Update Using Known IDs

Overview
You can also update data using IDs seen in the user interface that are referred to as Known IDs.

Prerequisites
You’ve completed the following:

● Downloaded the template for the relevant object.


● Updated data in the template files, and followed these guidelines:

 Note

● Don’t leave ID field empty.


● During an update, don’t edit or remove ID fields in the CSV file.

Procedure
1. Go to Data Workbench work center, and choose Import.
2. Select Individual Object and then select Update.
3. Select Use Known IDs
4. Select the object for which you want to update data.
5. Click Next. Select the data file you want to upload.
6. Click Upload, and then either select format validation for “Sample Data” or for “All Data” and then click
Next. Format validation check reports any format errors in the review step before importing data in SAP
Cloud for Customer.
7. Review the summary of your selection.
8. Click Import.The system displays a message on the status of the import. You can go to the Monitor view,
and check the status of your import.

 Note

○ To delete a record in SAP Cloud for Customer system, add a header ToBeDeleted at end of the
exported CSV data file, and mark the records to be deleted as True.

Availability
This feature is available for the following objects.

Objects

Activity

Appointment

Appointment Notes

Campaign

Contract

Contract Item

Data Workbench
20 PUBLIC Data Workbench
Objects

Lead

Lead Products

Maintenance Plan

Opportunity

Organisational Unit

Phone Call

Phone Call Notes

Product

Product List

Product Quantity Characteristics

Sales Quote

Sales Quote Document Flow

Sales Quote Item Document Flow

Sales Quote Item Schedule lines

Sales Quote Items

Service Request

Service Request Item

Target Group

Task

Tasks Notes

Visit

Visit Notes

Related Information

Data Simulation [page 25]

1.3.3 Import Attachments

Overview

You can import attachments of business object into SAP Cloud for Customer.

Data Workbench
Data Workbench PUBLIC 21
Prerequisites

● You know the name of the object in SAP Cloud for Customer for which you are importing attachments
● You have consolidated all the attachments of an object in an archive file (for example, .ZIP, .RAR) format.
Each archive file should contain a manifest file along with the attachments. You can also download the
manifest file for a selected object. The data that should be entered are:
○ External key of the object (node) for which you are importing attachment
○ Internal ID of the object (node) for which you are importing attachment

 Note

If both External key and Internal ID are entered, the External key will be ignored during attachment
import.

○ Attachment Type code defined for an attachment type (Optional if Web Link is maintained)
○ Attachment Name of the attachment
○ File Path relative to the manifest.csv file or Web Link for the attachment

Example:If you are importing the attachments of a corporate account, and the attachments are all placed in
the root folder, then the manifest file looks like the following:

CorporateAc­ CorporateAc­ AttachmentType­


countExternalKey countInternalID Code AttachmentName FilePath WebLink

SAP_43091 1000940 10001 Report Rep_CA.doc https://


help.sap.com

SAP_43092 1001240 10001 Analysis_Chart Chart.png http://


help.sap.com

 Tip

Ensure that the name of the manifest file is always the following: manifest.csv. It is case sensitive.

Procedure

1. Logon to SAP Cloud for Customer.


2. Go to Data Workbench work center, and choose Import.
3. To import attachments of an object, choose Import Attachment.
4. Select the object to which you want to import attachments, and click Next
5. For a selected custom object, if you have connected the SAP Cloud for Customer system with an external
system, and would like to maintain the external ID of this object in the imported data, you can select the
Business System ID of that system.

Data Workbench
22 PUBLIC Data Workbench
 Note

If you select a Business System ID, then you must have a new column named ExternalKey in the CSV
file with the external ID of each of the records. If the external key does not exist for the imported data,
then a new ID mapping will be generated.

6. Browse for the archive file, click Upload, and click Next.

 Note

The ZIP file size is limited to 100MB and the individual attachment file size is limited to 10MB.

7. Review the data and click Import. The system displays a message on the status of the import. You can go to
the Monitor view, and check the status of your import.

The system displays a message on the status of the import. You can go to the Monitor view, and check the
status of your import.

Related Information

Data Simulation [page 25]

1.3.4 ID Mapping

This feature is useful if you have used SAP Migration Workbench to migrate your data to SAP Cloud for
Customer.

Overview

With ID mapping, you can use external keys for data imported with Migration Workbench. These external keys
can then be referenced in Data Workbench imports.

Enable ID Mapping

This feature is hidden by default. As an administrator, you can enable this feature in business configuration.

To scope this feature, navigate to Business Configuration Implementation Projects Edit Project Scope
Built-in Services and Support Business Configuration Data Workbench and answer the following question.

Do you want to enable ID mapping?

Data Workbench
Data Workbench PUBLIC 23
Prerequisite

You must have the value conversion file from Migration Workbench.

Data Preparation

1. Download the ID Mapping template.


2. Enter the IDs from Migration Workbench and assign external keys.

Procedure

1. From Data Workbench, go to Import.


2. Select ID Mapping.
3. Select the object for which you want to import data.

 Note

Only root nodes are listed.

4. Click Next.
5. Browse and select the data file (CSV) of the ID mapping template.
6. Click Upload.
7. Click Next.
8. Review and click Import.

1.3.4.1 Delete ID Mapping

Follow this procedure if you want to delete ID mapping.

Data Preparation

1. Filter the mappings which needs to be deleted from the data file which was prepared during ID Mapping.
2. Add another column in the CSV file with the header ToBeDeleted.
3. To all the records in this column, add True.

 Note

To delete ID mapping, all records in the data file must have the field ToBeDeleted marked as True.

Data Workbench
24 PUBLIC Data Workbench
Procedure

1. From Data Workbench, go to Import.


2. Select ID Mapping.
3. Select the object for which you want to import data.

 Note

Only root nodes are listed.

4. Click Next.
5. Browse and select the data file (CSV) of the ID mapping template.
6. Click Upload.
7. Click Next.
8. Review and click Import.

1.3.5 Data Simulation

Overview

Before importing data into SAP Cloud for Customer, you can import the data in simulation mode to get the
processing errors. Data imported in simulation mode will not be saved into SAP Cloud for Customer.

Procedure

1. Go to Data Workbench work center, and choose either Import or Import Attachment or Update from the
Import work center view.
2. Select the object/template for which you want to import data.
3. Click Next.
4. Browse for the CSV data file/ZIP file you want to upload.
5. Click Upload
6. Switch ON Simulation Mode, and then click Next.
7. Review the summary of your selection.
8. Click Simulate.

Data Workbench
Data Workbench PUBLIC 25
Result

The system displays a message on the status of the data simulation. You can go to the Monitor view, and check
the status of your data simulation. Any processing errors during simulation can be downloaded by clicking on
error count link.

 Note

In Simulation Mode, data is not created into SAP Cloud for Customer.

1.3.6 Initial Load

Overview

Data can be migrated into SAP Cloud for Customer in Initial Load mode so that applications react differently,
for example by relaxing checks/update number ranges etc. By default, the Initial Load switch is set to ON,
which sets the migration context during data import.

Procedure

1. Go to Data Workbench work center and choose either Individual Objects / Complete Business Objects from
the Import workcenter view.
2. Select the object/template for which you want to import data.
3. Click Next.
4. Browse for the CSV data file/ZIP file you want to upload.
5. Click Upload
6. Switch ON Initial Load (Set to ON by default), and then click Next.
7. Review the summary of your selection.
8. Click Import.

Result

The system displays a message on the status of the data import. You can go to the Monitor view, and check the
status of your data simulation. Any processing errors during import can be downloaded by clicking on error
count link.

Data Workbench
26 PUBLIC Data Workbench
1.4 Export

Overview

You can export data of the following from SAP Cloud for Customer:

● Standard business object


● Custom business object

Procedure

1. Go to Data Workbench work center, and choose Export.


2. Select the object for which you want to export data. For example, if you want to export all activities, select
Activities.
3. To specify a criteria and export a subset of data, choose Select Data. You can add multiple criteria on
various fields. For example, you may want to export only those accounts whose role is set as a prospect.
4. Click Next, and review the summary of your selection.
5. Click Export Data. The system displays a message indicating that the process has been initiated.
6. You can view the status of data export in the Monitor view. Once the status is set to Completed, click on
the .CSV file under File Name column, to view the exported data file.

 Note

If you export more than 50000 records, multiple files will be generated. Each file can contain a
maximum of 50000 records.

To download multiple files at once, click on Download All.

1.5 Migration Templates

Templates store the mapping information between the headers of a CSV file and the corresponding fields of an
object (node) in SAP Cloud for Customer. Once you define the mapping in a migration template, you can reuse
the templates to import data to ensure consistency in mapping across all users.

Manage Migration Templates [page 28]


Learn how to manage templates including how to create, update, copy, and delete them.

Migration Template Usage Across SAP Cloud for Customer Tenants [page 30]

Data Workbench
Data Workbench PUBLIC 27
1.5.1 Manage Migration Templates

Learn how to manage templates including how to create, update, copy, and delete them.

Overview

Templates store the mapping information between the headers of a CSV file and the corresponding fields of an
object (node) in SAP Cloud for Customer. Once you define the mapping in a template, the template can be
used by any SAP Cloud for Customer user to import data anytime. This ensures consistency in mapping across
all users.

Create Template

Procedure

1. Go to Data Workbench work center, and choose Migration Templates.


2. Select Create button.
3. Select an Object.
4. Click Next.
5. Select Business System ID (Optional).
6. Browse & Upload a CSV (Comma Delimited) File.
7. Click Next.
8. Maintain the data mapping and click Next.
9. Maintain code list mapping, if any code list property is mapped in data mapping step.
10. Select a template name & select Create.
11. The template is available in list of templates.

Update Template

Procedure

1. Go to Data Workbench work center, and choose Migration Templates.


2. Select hyperlink on the template name for which template to be updated.
3. Select Business System ID (Optional).
4. Browse & Upload a CSV(Comma Delimited) File.
5. Click Next.
6. Maintain the data mapping and click Next.
7. Maintain code list mapping, if any code list property is mapped in data mapping step.

Data Workbench
28 PUBLIC Data Workbench
8. Select Update.
The updated template is now available in list of templates.

Copy Template

Procedure

1. Go to Data Workbench work center, and choose Migration Templates.


2. Select the template to be copied.
3. Select More to open a menu option and select Copy.
4. Enter template name and select Copy.
The copied template is available in list of templates.

Delete Template

Procedure

1. Go to Data Workbench work center, and choose Migration Templates.


2. Select the template to be deleted.
3. Select More to open a menu option and select Delete.
4. Confirm the deletion.
The deleted template will be removed from list of templates.

Template usage across SAP Cloud for Customer tenants

Overview

In order to use a template across SAP Cloud for Customer tenants, the template should first be downloaded
from the source tenant in the client file system & the same file can then be uploaded in target tenants for reuse.

Procedure

1. Go to Data Workbench work center in the source tenant, and choose Migration Templates.
2. Select the template to be downloaded.
3. Select More to open a menu option and select Download.
4. Save the .dwbtmpl file in client file system.

Data Workbench
Data Workbench PUBLIC 29
 Note

If the file is tampered, it will be unusable.

5. Go to Data Workbench work center in the target tenant, and choose Migration Templates.
6. Select More to open a menu option and select Upload.
7. Browse the .dwbtmpl file from client file system and enter template name.
8. Select Upload.
The uploaded template will be available in list of templates in the target tenant.

1.5.2 Migration Template Usage Across SAP Cloud for


Customer Tenants

In order to use a template across SAP Cloud for Customer tenants, the template should first be downloaded
from the source tenant in the client file system and the same file can then be uploaded in target tenants for
reuse.

Procedure

1. Go to Data Workbench work center in the source tenant, and choose Migration Templates.
2. Select the template to be downloaded
3. Select More button to open a menu option and select Download .
4. Save the .dwbtmpl file in client file system.

 Note

The file will be unusable if it is tampered.

5. Now, go to Data Workbench work center in the target tenant, and choose Migration Templates.
6. Select the More button to open a menu option and select Upload.
7. Browse the .dwbtmpl file from client file system and enter a name for the template.
8. Select Upload.

 Note

You will find the uploaded template in the list of templates in the target tenant

Data Workbench
30 PUBLIC Data Workbench
1.6 Monitor

Overview

Monitor allows you to view the status of the import and export tasks. You can also download error and warning
files for each task.

Task Stages

Once an import or export task is triggered, it goes through multiple stages.

In Queue: As soon as a task is triggered, it is in this status.

In Process: Once the task has begun processing, the status moves to In Process.

 Note

Only one import and one export tasks is in process at any point. Tasks triggered after, will be in queue.

Data Processed: All records are processed. The tool starts to generate error and warning files, if any, and the
next task moves to In Process.

Finished: Error and warning files are generated and the task moves to Finished. Errors or warning generated, if
any, are now available for download.

Interrupted: The task status Interrupted indicates an internal error. In such instances, create an SAP incident.

Errors and Warning: This status indicates errors or warnings in the records. You can view the number of errors
and warnings and also download them for more information. These records may have a business error. For
example, the mandatory property for the service could be missing or an internal error could have occurred
while processing the record. Similarly, there could be a warning from the business object.

Elapsed Time: Indicates the time taken to finish the task. You can add this property to the Monitor view by
personalizing the view and add additonal fields.

Stop Pending: This status indicates that a stop request is triggered for a task. The task will be stopped after the
current record is processed.

Stopped: This status indicates that a task has moved from Stop Pending and has now successfully stopped.
More information on the stopped task such as successfully processed and unprocessed records is available in
the data file in Monitor.

Data Workbench
Data Workbench PUBLIC 31
Task Deletion

Tasks in status finished or interrupted can be deleted. You can select a single task to delete or select tasks
triggered in a date range and delete them.

Filter Tasks

Use filter to view the following:

● My Tasks: All tasks which you have triggered.


● All Tasks: All tasks triggered in your tenant.
● Successful: All tasks which have finished without errors.
● Failed: All tasks which have finished with errors.

Use the advanced filter to filter based on Task Name, File Name, Status, Created By.

Data Workbench
32 PUBLIC Data Workbench
2 Object Documentation

Download the latest version of object documentation from here:Data Workbench Object Documentation

Data Workbench
Object Documentation PUBLIC 33
3 List of Objects Available in Data
Workbench

List of Objects supported in Data Workbench

Data Workbench Object Name OData Service Name in Data Workbench

Account, Individual Customer customer

Account Hierarchy accounthierarchy

Account Sales Data customer

Activity memoactivity

Activity Planner activityplanprocessing

Appointment, Email, Phone Call, Tasks, Visit activity

Business Attribute marketingattribute

Business Partner Relationship businesspartnerrelationship

Business Role Replication Request businessrolereplicationrequest

Buying Center buyingcenter

Campaign campaign

Channel Partner Registration Request partnerapplication

Chat Activity chatactivity

Competitor competitor

Competitor Product competitorproduct

Contact contact

Contract contract

Deal Questionnaire pcmmigration

Deal Registration pcmmigration

Data Workbench
34 PUBLIC List of Objects Available in Data Workbench
Data Workbench Object Name OData Service Name in Data Workbench

Employee employeeanduser

Installation Point installationpoint

Installed Base installedbase

Invoice leaninvoice

Job Definition jobdefinition

Lead lead

Maintenance Plan maintenanceplan

Marketing Permission marketingpermission

Measurement Document measurementreading

Measurement Point measurementpoint

Opportunity opportunity

Organisational Unit organisationalunit

Partner partner

Partner Contact partnercontact

Payment payment

Price List salespricelist

Price Specification prices

Product product

Product Categories productcategoryhierarchy

Product List productbusinesspartnerrelation

Promotion promotion

Registered Product registeredproduct

Routing Rule routingrule

Sales Order salesorder

Sales Point Of Delivery salespointofdelivery

Sales Quote salesquote

Sales Territory salesterritory

Data Workbench
List of Objects Available in Data Workbench PUBLIC 35
Data Workbench Object Name OData Service Name in Data Workbench

Service Agent serviceagent

Skill Hierarchy skills

Social Media Activity socialmediaactivity

Social Media User Profile socialmediauserprofile

Survey surveydesign

Survey surveyresponse

Target Group targetgroup

Ticket ticket

Time Entry timeentry

Time Report timereport

Vehicle vehicle

List of Deprecated Objects

Deprecated Data Workbench Object Name Deprecated Service Name

Responses campaignmigration

 Note

● Deprecated objects will be removed in the future releases. Use the new object for data migration.
● It is not recommended to add extension fields for deprecated objects.

Data Workbench
36 PUBLIC List of Objects Available in Data Workbench
3.1 List of Deprecated Objects exhaustive list (do not
include in ToC)

List of Deprecated Objects exhaustive list (do not include in ToC)

Deprecated Data Work­ New Data Workbench Ob­


bench Object Name Deprecated Service Name ject Name New Service Name

Account Contact Relation­ c4cdataworkbench Account/Account Contact customer


ship (Deprecated) Relationship

Account Sales Data (Depre­ c4cdataworkbench Account Sales Data customer


cated)

Contract (Deprecated) c4cdataworkbench Contract contract

Sales Order (Deprecated) salesorderprocessing Sales Order salesorder

Ticket (Deprecated) c4cdataworkbench Ticket ticket

 Note

● Deprecated objects will be removed in the future releases. Use the new object for data migration.
● It is not recommended to add extension fields for deprecated objects.

Data Workbench
List of Objects Available in Data Workbench PUBLIC 37
4 Frequently Asked Questions

For a list of the latest FAQs, see FAQs – Data Workbench.

Data Workbench
38 PUBLIC Frequently Asked Questions
5 Support Incidents

In case you receive an error and are unable to resolve it based on the information provided in this document,
please raise an incident in SAP Cloud for Customer, under the component LOD-CRM-INT-DWB.

Data Workbench
Support Incidents PUBLIC 39
6 Data Workbench APIs

SAP Data Workbench offers REST APIs, which you can use to import high volume of data into SAP Cloud for
Customer. Read on to know more.

The following APIs are offered:

● Authentication API
● Template API
● Import API

6.1 Data Workbench Authentication API

Use this API to authenticate a user in SAP Cloud for Customer.

The authentication API returns the URL of the Import API and a token for authentication.

Authentication: The API uses Basic Authentication (username and password).

Authorization: You must be a key user and have the Data Workbench work center view assigned.

Request URL: <tenant_host_name >/sap/c4c/dwb/singleusetoken/

HTTP Method: GET

Request Query Parameters: Not Applicable

Request Header Parameters: Not Applicable

Request Payload: Not Applicable

Response:

Status Code Response Description

200 "<HostName>":"<<tenant_host_nam The user is authenticated and author­


e>>", "<Token>":"<<token>>"} ized to use the API.

403 The user is either doesn’t have the Data


Workbench Monitor work center view
assigned or is a business user.

 Note

This single-use token is valid for 30 seconds.

Data Workbench
40 PUBLIC Data Workbench APIs
6.2 Data Workbench Template API

Use this API to download the template file that prepares data for import using the Data Workbench Import API.

Authentication: The API uses the token received from the Authentication API.

Authorization: You must be a key user and have the Data Workbench work center view assigned. Also, you
must also have the work center view of the relevant object assigned.

Request URL: <tenant_host_name>/api/v1/template?


token=<token>&serviceName=<service_name>&entityName=<rootEntityName>&isCustom=false
&type=1&operation=1

HTTP Method: GET

Request Query Parameters:

Parameter Name Description Sample Value

tenant_host_name Value for this parameter is provided by https://


the Data Workbench Authentication myXXXXXX.crm.ondemand.com
API.

token Value for this parameter is provided by BJam3J7e3ngfDUOuuGzEyk6F62


the Data Workbench Authentication 3gY5b3wy83hQ
API.

service_name The OData service for which the meta­ customer


data is needed.

 Note
Available standard services can be
seen here: Services Available in
Data Workbench

entityName The EntityType name of the entity for CorporateAccount

which the metadata must be down­


loaded.

 Note
Entity type of standard services can
be seen here: SAP Cloud for
Customer OData 2.0 Reference

isCustom Indicates if the OData service is a cus­ false

tom or a standard service.

Valid values: true/false

Data Workbench
Data Workbench APIs PUBLIC 41
Parameter Name Description Sample Value

type Indicates type of import for which the 1


metadata file is needed.

Valid Values
Code Value

1 Complete Busi­
ness Object

2 Individual Busi­
ness Object

operation Indicates type of operation for which 1


the metadata file is needed.

Valid Values
Code Value

1 Insert

2 Upsert

Request Header Parameters: Not Applicable

Request Payload: Not Applicable

Response:

Status Code Response Description

200 The template zip file is downloaded. Not Applicable

401 Unauthorized The token is invalid.

400 Error. Verify service name, entity OData service details provided are in­
nameisCustom, and retry. correct.

Error. Verify 'type' and 'operation' and The operation isn’t support by the ob­
retry. ject.

404 Service Unavailable Check the URL and the HTTP method.
If unresolved, create an SAP incident.

6.3 Data Workbench Import API

Use this API to import the data into SAP Cloud for Customer.

This API creates a migration project, a collection of import tasks, in Data Workbench.

Authentication: The API uses the token received from the Authentication API.

Data Workbench
42 PUBLIC Data Workbench APIs
Authorization: You must be a key user and have the Data Workbench work center view assigned. Also, you
must also have the work center view of the relevant object assigned.

Request URL: <tenant_host_name>/api/v1/import?token=<token>

HTTP Method: POST

Request Query Parameters:

Parameter Name Description Sample Value

token Value for this parameter is provided by BJam3J7e3ngfDUOuuGzEyk6F62


the Data Workbench Authentication 3gY5b3wy83hQ
API.

Request Header Parameters:

● content:application/xml
● Content-Type:application/xml

Request Payload:

Property Name Description Sample Value

projectName The name of the migration project. It Lead_Migration_01


represents the collection of tasks sub­
mitted by the API.

taskType Use this code to state the type of task; 1


for example, Complete Business Object
Import. Valid Values:

Code Value

1 Complete Busi­
ness Object Im­
port

2 Individual Busi­
ness Object

operation Use this code to state the operation to 1

be performed on the data such as in­


sert/upsert.

Valid Values
Code Value

1 Insert

2 Upsert

ignoreBlankValues A boolean value to identify if the blank true

columns from the file should be ignored


or considered during import.

Valid Values: true/false

Data Workbench
Data Workbench APIs PUBLIC 43
Property Name Description Sample Value

simulation A boolean value to identify whether the false

task is in simulation mode. In simula­


tion mode, data is not saved.

Valid Values: true/false

initialLoad A boolean value to identify whether the true


migration mode is on or off for the task.

Valid Values: true/false

serviceName The OData service that must be used customer

for the import. See Services Available in


Data Workbench.

customService A boolean value to identify whether the false


OData service to be used is a custom or
standard service.

Valid Values: true/false

rootEntitySetName Applicable for import of Complete CorporateAccountCollection


Business Object: Name of the root en­
tity set () to which the data is to be up­
loaded.

 Note
Entity type of standard services can
be seen here: SAP Cloud for
Customer OData 2.0 Reference

entitySetName Applicable for import of Individual


Business Object.

Name of the entity set to which the data


is to be uploaded.

 Note
Entity type of standard services can
be seen here: SAP Cloud for
Customer OData 2.0 Reference

sequence You can provide the numeric value to 1


define the sequence of execution of
tasks in a project. This field is a manda­
tory one.

lastTask A boolean value to indicate whether the true

current task is the last of the project. If


yes, the Data Workbench will start proc­
essing.

Valid Values: true/false

Data Workbench
44 PUBLIC Data Workbench APIs
Property Name Description Sample Value

errorThreshold This numeric value defines the percent­ 30


age of error after which the execution of
other tasks in the sequence is stopped
for the project, the tasks in sequence is
also stopped.

dataFile This field contains the binary form of


the zip file that must be uploaded for
the import.

fileName Applicable for import of Individual


Business Object.

Enter the file name in this field. If no


name is given, the tool generates it in
the following format:

<EntityName_sequence>

Response:

Status Code Response Description

200 {"taskName":"<taskName>"} This is the name of the import task. It is


seen under the project in Monitor.

401 Unauthorized The token is invalid.

400 Error. Verify service name, entity OData service details provided are in­
nameisCustom, and retry. correct.

Error. Verify 'type' and 'operation' and The operation isn’t support by the ob­
retry. ject.

500 Task limit reached. Retry after some Maximum of 10 tasks can be submitted.
time. Retry after some time.

Internal error; create an SAP incident. Some unknown exception has occur­
red. Create an SAP incident.

404 Service Unavailable Check the URL and the HTTP method.
If unresolved, create an SAP incident.

6.4 Monitor

Check the status of your migration project with Monitor.

To check status, go to Data Workbench Monitor .

Data Workbench
Data Workbench APIs PUBLIC 45
 Note

You can add Project Name using Adapt.

When you create a project and click the project name in Monitor, the system opens a model dialogue box with
the list of all the tasks that belong to the project.

You can also monitor the submitted task using the following OData endpoint:

https://<Your_C4C_Tenant>/sap/c4c/odata/v1/dwbmonitor/ScenarioCollection?
$filter=ScenarioName%20eq%20%27<Task_Name>%27

 Note

Use your SAP Cloud for Customer tenant credentials to sign in to the endpoint.

Life Cycle of Migration project:

● When you submit a task to the API with the required details, the system creates a migration project entry
with the Project Name as provided.
● When the project is created, its status is Inactive. All the tasks are created with the In Queue status.
● After the system receives lastTask marked as true, the first task in the sequence is processed, and the
project is set to In Process. Note that the first task is processed as soon as the Data Workbench is
available.
● When all the tasks of the project are completed, the project is set to Finished.
● If the system crosses the error threshold for one of the tasks, the next task in the sequence is not picked
for processing, and the project is set to Pending. In such a case, follow these steps:
1. Correct the errors and upload the corrected data via the Data Workbench UI.
2. Resume the project by selecting the project and clicking the Resume button from the action menu.
The project is set to In Process and the system picks up the next task in sequence for processing.
● You can stop the project from the action menu. This means that the task in process is stopped, and other
tasks are not picked up for processing.
● You can stop a task of the project by selecting the task and clicking Stop. After the task stops, the next task
in sequence is processed.
● When you delete an inactive process from the action menu, all the related tasks are also deleted.

 Note

● The API must be called sequentially. Parallel calling of the API may result in unpredictable behavior.
● At a time, only one task is to be executed.
● A maximum of 10 tasks can be submitted via the API across the projects. The next task is accepted
only when the previous task is finished.

Data Workbench
46 PUBLIC Data Workbench APIs
Important Disclaimers and Legal Information

Hyperlinks
Some links are classified by an icon and/or a mouseover text. These links provide additional information.
About the icons:

● Links with the icon : You are entering a Web site that is not hosted by SAP. By using such links, you agree (unless expressly stated otherwise in your
agreements with SAP) to this:

● The content of the linked-to site is not SAP documentation. You may not infer any product claims against SAP based on this information.
● SAP does not agree or disagree with the content on the linked-to site, nor does SAP warrant the availability and correctness. SAP shall not be liable for any
damages caused by the use of such content unless damages have been caused by SAP's gross negligence or willful misconduct.

● Links with the icon : You are leaving the documentation for that particular SAP product or service and are entering a SAP-hosted Web site. By using such
links, you agree that (unless expressly stated otherwise in your agreements with SAP) you may not infer any product claims against SAP based on this
information.

Beta and Other Experimental Features


Experimental features are not part of the officially delivered scope that SAP guarantees for future releases. This means that experimental features may be changed by
SAP at any time for any reason without notice. Experimental features are not for productive use. You may not demonstrate, test, examine, evaluate or otherwise use
the experimental features in a live operating environment or with data that has not been sufficiently backed up.
The purpose of experimental features is to get feedback early on, allowing customers and partners to influence the future product accordingly. By providing your
feedback (e.g. in the SAP Community), you accept that intellectual property rights of the contributions or derivative works shall remain the exclusive property of SAP.

Example Code
Any software coding and/or code snippets are examples. They are not for productive use. The example code is only intended to better explain and visualize the syntax
and phrasing rules. SAP does not warrant the correctness and completeness of the example code. SAP shall not be liable for errors or damages caused by the use of
example code unless damages have been caused by SAP's gross negligence or willful misconduct.

Gender-Related Language
We try not to use gender-specific word forms and formulations. As appropriate for context and readability, SAP may use masculine word forms to refer to all genders.

Videos Hosted on External Platforms


Some videos may point to third-party video hosting platforms. SAP cannot guarantee the future availability of videos stored on these platforms. Furthermore, any
advertisements or other content hosted on these platforms (for example, suggested videos or by navigating to other videos hosted on the same site), are not within
the control or responsibility of SAP.

Data Workbench
Important Disclaimers and Legal Information PUBLIC 47
www.sap.com/contactsap

© 2019 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form


or for any purpose without the express permission of SAP SE or an SAP
affiliate company. The information contained herein may be changed
without prior notice.

Some software products marketed by SAP SE and its distributors


contain proprietary software components of other software vendors.
National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for


informational purposes only, without representation or warranty of any
kind, and SAP or its affiliated companies shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP or
SAP affiliate company products and services are those that are set forth
in the express warranty statements accompanying such products and
services, if any. Nothing herein should be construed as constituting an
additional warranty.

SAP and other SAP products and services mentioned herein as well as
their respective logos are trademarks or registered trademarks of SAP
SE (or an SAP affiliate company) in Germany and other countries. All
other product and service names mentioned are the trademarks of their
respective companies.

Please see https://www.sap.com/about/legal/trademark.html for


additional trademark information and notices.

THE BEST RUN

You might also like