Skip to content

SDI command line interface (CLI)

Overview

You can execute mapping tasks using the SDI command line interface (SdiCli.exe).
In a default installation, SdiCli.exe is located on C:\Program Files\RiCCT\SimpleDataIntegrator.

Command line syntax

The basic command line syntax is:

When using a mapping name:

SdiCli <MappingName>

When using a mapping ID:

SdiCli <MappingID>

Execute example：


C:\Program Files\RiCCT\SimpleDataIntegrator>SdiCli.exe "HR_TO_SALES_EMP"
Start
Mapping :HR_TO_SALES_EMP
Mapping ID :MBE5B7F93B8E84B70B4D3AFDF229E1A35
Mapping Name :HR_TO_SALES_EMP
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: Operation Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: MappingTask Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: OpenConnection Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: OpenConnection Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: PreprocessorOfExtract Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: PreprocessorOfExtract Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: Extract Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: Extract Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: CommitTransaction Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: CommitTransaction Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: PrepareStagingTable Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: PrepareStagingTable Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: LoadIntoStagingTable Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: LoadIntoStagingTable Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: OpenConnection Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: OpenConnection Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: DeleteTargetTableBeforeUpdate Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: DeleteTargetTableBeforeUpdate Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: DataUpdate_Append Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: DataUpdate_Append Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: CommitTransaction Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: CommitTransaction Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: MappingTask Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: DropStagingTable Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: DropStagingTable Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: CloseConnection Started
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: CloseConnection Succeeded
OperationId:MBE5B7F93B8E84B70B4D3AFDF229E1A35_20220503125135.238 Operation: Operation Succeeded
End

Return value

Return value Description
0 Indicates that the CLI has completed successfully.
1 Indicates that the mapping execution failed.
2 Indicates that the target mapping does not exist.

Appendix

How to find Mapping ID

  1. Click the detail icon in mapping list on the home form.

2.Confirm the Mapping ID on the detail form

Back to top