- Release notes
- Before you begin
- Getting started
- Integrations
- Managing access
- Working with process apps
- Creating apps
- Loading data
- Uploading data
- Retrieving the SQL Server database parameters
- Setting up a SQL Server account for data upload using an extractor
- Loading data using Theobald Xtract Universal
- DataBridgeAgent
- System requirements
- Configuring DataBridgeAgent
- Configuring CData Sync
- Using DataBridgeAgent with SAP Connector for Purchase-to-Pay Discovery Accelerator
- Using DataBridgeAgent Wwith SAP Connector for Order-to-Cash Discovery Accelerator
- Customizing process apps
- Data transformations
- TemplateOne app template
- Purchase to Pay app template
- Order to Cash app template
- Basic troubleshooting guide
Using DataBridgeAgent Wwith SAP Connector for Order-to-Cash Discovery Accelerator
DataBridgeAgent is only needed if you are migrating from an on-premises stand-alone Process Mining version.
.mvp connector. Otherwise, use CData Sync, Theobald Xtract Universal for SAP, or files to upload data.
Datarun.json file for using DataBridgeAgent with SAP Connector for Order-to-Cash Discovery Accelerator.
Below is an overview of the generic settings.
|
Setting |
Value |
|---|---|
|
azureURL |
"sas url" The SAS URL of the Azure blob storage to which the extracted data needs to be uploaded. Note: The
azureURL is not used when loading data for use in Process Mining on-premises (Automation Suite). Make sure this field is left blank.
|
| endOfUploadApiUrl | The API that is called to start data processing in Process Mining, once all data has been uploaded.
Note:
The
endOfUploadApiUrl is not used when loading data for use in Process Mining on-premises (Automation Suite). Make sure this field is left blank.
|
|
connectorWorkspace |
"SAP_Connector_for_Order-to-Cash_Discovery_Accelerator" |
|
connectorModuleCode |
"SAP_Connector_for_Order-to-Cash_Discovery_Accelerator" |
|
Use credential store |
true | false |
SAP Settings
Below is an overview of the parameters that can be used for SAP datasources.
|
Setting |
Value |
|---|---|
|
SAP Host |
The hostname or IP address of the SAP application server. "yourserver.domain:1234" |
|
SAP Systemnumber |
The two-digit number between 00 and 99 that identifies the designated instance. "00" |
|
SAP Username |
Username of the account that is being used to log in to the SAP instance. "username" |
|
SAP Password |
Password of the account that is being used to log in to the SAP instance, or the password identifier from the credential store. (If the credential store is used, the Use credential store generic setting should be set to true.) "password" | "PasswordIdentifier" |
|
SAP Client |
The client that is being used. (000-999). "000" |
|
Exchange rate type |
The exchange rate type which is used for currency conversion (KURST). "M" |
|
Language |
The language that is being used for descriptions extracted from the data (E = English). "E" |
.csv files always make sure that all the required Input data of the SAP Order-to-Cash Connector is available.
Always make sure that:
- a separate
.csvfile is available for each table. - the file names of the
.csvfiles are the same as the names of the input tables of the connector. - all the fields specified in the Fields used in Process Mining column of a table are present in the
.csvfile. - the fields in the
.csvfiles have the same names as the field names specified in the Fields used in Process Mining column.
VBAK.csv or VBAK1.csv or VBAK.CSV. The other settings can be defined in the CSV parameters of the DataBridgeAgent.
CSV parameters
Below is an overview of the parameters that can be used for CSV datasources.
|
SAP Setting |
Description |
|---|---|
|
CSV Data path |
Data path in the Server Data that points to the place where the
.csv files are stored. For example, O2C/ if all files can be found in the folder named O2C.
|
|
CSV Suffix |
A regular expression containing the files extension of the file to read in. May contain a suffix up to 2 digits that are added to the name of the table. |
|
CSV Delimeter |
The delimiter character that is used to separate the fields. |
|
CSV Quotation character |
The quote character that is used to identify fields that are wrapped in quotes. |
|
CSV Has header |
Indicate whether the first line of the
.CSV file is a header line.
|
