Jump to

• Request
• Response

Create or Generate Compare Pairs using mapped objects

post

http://{host}:{port}/veridata/v1/services/configuration/cps/mappings/group/{groupId}

Required Role: Administrator, SuperUser, DetailMonitoringOperator, MonitoringOperator, CommandLineOperator

Create compare pairs.

Request

Path Parameters

• groupId(required): integer(int64)
  group ID.

Query Parameters

• includeColumnMapping: boolean
  Include column mapping details in payload.Default is false.
• preview: boolean
  If false compare pairs are persisted to the repository.Default value is true.

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Type: object

Show Source

• mappedObjectWithOptions: object mappedObjectWithOptions

{
    "type":"object",
    "properties":{
        "mappedObjectWithOptions":{
            "type":"object",
            "allOf":[
                {
                    "$ref":"#/components/schemas/MappedObjectWithOptions"
                }
            ]
        }
    },
    "example":{
        "mappedObjectWithOptions":[
            {
                "name":"EMPLOYEE=EMPLOYEE",
                "srcTable":{
                    "name":"EMPLOYEE",
                    "schema":"VERIDATA",
                    "catalog":"ORCL1",
                    "tablePartition":{
                        "name":"EMP_2025"
                    }
                },
                "tgtTable":{
                    "name":"EMPLOYEE",
                    "schema":"VERIDATA",
                    "catalog":"ORCL1",
                    "tablePartition":{
                        "name":"EMP_2025"
                    }
                },
                "profileId":1,
                "options":{
                    "autoPartitionInfo":{
                        "autoPartition":true,
                        "autoPartitionNumber":10
                    }
                },
                "rowPartition":[
                    {
                        "side":"SOURCE",
                        "name":"employee ID's greater than 100",
                        "whereClause":"ID > 100",
                        "type":"S",
                        "runtime":true
                    },
                    {
                        "side":"TARGET",
                        "name":"employee ID's greater than 100",
                        "whereClause":"ID > 100",
                        "type":"S",
                        "runtime":true
                    }
                ],
                "delta":{
                    "srcColumn":"UPDATED_DATE",
                    "tgtColumn":"UPDATED_DATE",
                    "srcDeltaQuery":"select MAX(UPDATED_DATE) from ORCL1.VERIDATA.EMPLOYEE",
                    "tgtDeltaQuery":"select MAX(UPDATED_DATE) from ORCL1.VERIDATA.EMPLOYEE",
                    "srcDeltaCols":[
                        "UPDATED_DATE, MODIFIED_TS"
                    ],
                    "tgtDeltaCols":[
                        "UPDATED_DATE, MODIFIED_TS"
                    ],
                    "columnMapping":[
                        {
                            "useSourceColsAsKeys":true,
                            "useTargetColsAsKeys":true,
                            "useAllColsAsKeys":true
                        }
                    ]
                }
            }
        ]
    }
}

Example:

{
    "mappedObjectWithOptions":[
        {
            "name":"EMPLOYEE=EMPLOYEE",
            "srcTable":{
                "name":"EMPLOYEE",
                "schema":"VERIDATA",
                "catalog":"ORCL1",
                "tablePartition":{
                    "name":"EMP_2025"
                }
            },
            "tgtTable":{
                "name":"EMPLOYEE",
                "schema":"VERIDATA",
                "catalog":"ORCL1",
                "tablePartition":{
                    "name":"EMP_2025"
                }
            },
            "profileId":1,
            "options":{
                "autoPartitionInfo":{
                    "autoPartition":true,
                    "autoPartitionNumber":10
                }
            },
            "rowPartition":[
                {
                    "side":"SOURCE",
                    "name":"employee ID's greater than 100",
                    "whereClause":"ID > 100",
                    "type":"S",
                    "runtime":true
                },
                {
                    "side":"TARGET",
                    "name":"employee ID's greater than 100",
                    "whereClause":"ID > 100",
                    "type":"S",
                    "runtime":true
                }
            ],
            "delta":{
                "srcColumn":"UPDATED_DATE",
                "tgtColumn":"UPDATED_DATE",
                "srcDeltaQuery":"select MAX(UPDATED_DATE) from ORCL1.VERIDATA.EMPLOYEE",
                "tgtDeltaQuery":"select MAX(UPDATED_DATE) from ORCL1.VERIDATA.EMPLOYEE",
                "srcDeltaCols":[
                    "UPDATED_DATE, MODIFIED_TS"
                ],
                "tgtDeltaCols":[
                    "UPDATED_DATE, MODIFIED_TS"
                ],
                "columnMapping":[
                    {
                        "useSourceColsAsKeys":true,
                        "useTargetColsAsKeys":true,
                        "useAllColsAsKeys":true
                    }
                ]
            }
        }
    ]
}

Nested Schema : mappedObjectWithOptions

Type: object

Match All

Show Source

• object allOf MappedObjectWithOptions

{
    "type":"object",
    "allOf":[
        {
            "$ref":"#/components/schemas/MappedObjectWithOptions"
        }
    ]
}

Nested Schema : MappedObjectWithOptions

Type: object

Show Source

• options: object MappedObjectOptions
• profileId: integer (int64)
  Default Value: 1

  Profile ID.

{
    "type":"object",
    "allOf":[
        {
            "$ref":"#/components/schemas/MappedObjectRequest"
        }
    ],
    "properties":{
        "profileId":{
            "type":"integer",
            "format":"int64",
            "default":1,
            "description":"Profile ID."
        },
        "options":{
            "$ref":"#/components/schemas/MappedObjectOptions"
        }
    }
}

Match All

Show Source

• object MappedObjectRequest

{
    "type":"object",
    "allOf":[
        {
            "$ref":"#/components/schemas/MappedObjectRequest"
        }
    ],
    "properties":{
        "profileId":{
            "type":"integer",
            "format":"int64",
            "default":1,
            "description":"Profile ID."
        },
        "options":{
            "$ref":"#/components/schemas/MappedObjectOptions"
        }
    }
}

Nested Schema : MappedObjectRequest

Type: object

Show Source

• delta: object DeltaProcessing
  Defines Delta Setting. For NSK this will be an empty object.
• name: string
  Mapping name . Default is source table name = target table name.
• srcTable(required): srcTable
  Represents a table in compare pair with table and row partitions info, if any.
• tgtTable(required): tgtTable
  Represents a table in compare pair with table and row partitions info, if any.

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string",
            "description":"Mapping name . Default is source table name = target table name."
        },
        "srcTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/ReqTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "tgtTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/ReqTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "delta":{
            "$ref":"#/components/schemas/DeltaProcessing"
        }
    },
    "required":[
        "srcTable",
        "tgtTable"
    ]
}

Nested Schema : DeltaProcessing

Type: object

Defines Delta Setting. For NSK this will be an empty object.

Show Source

• srcColumn: string
  Delta Source column.
• srcDeltaCols: array srcDeltaCols
  List of Source Delta columns.
• srcDeltaQuery: string
  Source Delta query.
• tgtColumn: string
  Delta Target column.
• tgtDeltaCols: array tgtDeltaCols
  List of Target Delta columns.
• tgtDeltaQuery: string
  Target Delta query.

{
    "type":"object",
    "properties":{
        "srcColumn":{
            "type":"string",
            "description":"Delta Source column."
        },
        "tgtColumn":{
            "type":"string",
            "description":"Delta Target column."
        },
        "srcDeltaQuery":{
            "type":"string",
            "description":"Source Delta query."
        },
        "tgtDeltaQuery":{
            "type":"string",
            "description":"Target Delta query."
        },
        "srcDeltaCols":{
            "type":"array",
            "description":"List of Source Delta columns.",
            "items":{
                "type":"string"
            }
        },
        "tgtDeltaCols":{
            "type":"array",
            "description":"List of Target Delta columns.",
            "items":{
                "type":"string"
            }
        }
    },
    "description":"Defines Delta Setting. For NSK this will be an empty object."
}

Nested Schema : srcTable

Represents a table in compare pair with table and row partitions info, if any.

Match All

Represents a table in compare pair with table and row partitions info, if any.

Represents a table in compare pair with table and row partitions info, if any.

Show Source

• object ReqTable
  Defines a table in request body.
• object srcTable-allOf[1]

{
    "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
    "allOf":[
        {
            "$ref":"#/components/schemas/ReqTable"
        },
        {
            "type":"object"
        }
    ]
}

Nested Schema : tgtTable

Represents a table in compare pair with table and row partitions info, if any.

Match All

Represents a table in compare pair with table and row partitions info, if any.

Represents a table in compare pair with table and row partitions info, if any.

Show Source

• object ReqTable
  Defines a table in request body.
• object tgtTable-allOf[1]

{
    "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
    "allOf":[
        {
            "$ref":"#/components/schemas/ReqTable"
        },
        {
            "type":"object"
        }
    ]
}

Nested Schema : srcDeltaCols

Type: array

List of Source Delta columns.

Show Source

• Array of: string

{
    "type":"array",
    "description":"List of Source Delta columns.",
    "items":{
        "type":"string"
    }
}

Nested Schema : tgtDeltaCols

Type: array

List of Target Delta columns.

Show Source

• Array of: string

{
    "type":"array",
    "description":"List of Target Delta columns.",
    "items":{
        "type":"string"
    }
}

Nested Schema : ReqTable

Type: object

Defines a table in request body.

Show Source

• catalog: string
• filePattern: string
  Valid for NSK Enscribe database.
• name: string
• schema: string
• tablePartition: object tablePartition

{
    "type":"object",
    "description":"Defines a table in request body.",
    "properties":{
        "name":{
            "type":"string"
        },
        "schema":{
            "type":"string"
        },
        "catalog":{
            "type":"string"
        },
        "filePattern":{
            "type":"string",
            "description":"Valid for NSK Enscribe database."
        },
        "tablePartition":{
            "type":"object",
            "allOf":[
                {
                    "$ref":"#/components/schemas/TablePartition"
                }
            ]
        }
    }
}

Nested Schema : srcTable-allOf[1]

Type: object

Nested Schema : tablePartition

Type: object

Match All

Show Source

• object TablePartition

{
    "type":"object",
    "allOf":[
        {
            "$ref":"#/components/schemas/TablePartition"
        }
    ]
}

Nested Schema : TablePartition

Type: object

Show Source

• name: string

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string"
        }
    }
}

Nested Schema : tgtTable-allOf[1]

Type: object

Back to Top

Response

Supported Media Types

• application/json

200 Response

Compare Pairs created successfully.

Body ()

Root Schema : schema

Type: array

Show Source

• Array of: object ComparePairInDetails

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/ComparePairInDetails"
    }
}

Nested Schema : ComparePairInDetails

Type: object

Show Source

• srcEnscribeInfo: array srcEnscribeInfo
• tgtEnscribeInfo: array tgtEnscribeInfo

{
    "allOf":[
        {
            "$ref":"#/components/schemas/ComparePairInDetailsView"
        },
        {
            "$ref":"#/components/schemas/Group_base"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "srcEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        },
        "tgtEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        }
    }
}

Match All

Show Source

• object allOf ComparePairInDetailsView
• object Group_base
• object ComparePairInDetails-allOf[2]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/ComparePairInDetailsView"
        },
        {
            "$ref":"#/components/schemas/Group_base"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "srcEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        },
        "tgtEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        }
    }
}

Nested Schema : srcEnscribeInfo

Type: array

Show Source

• Array of: object EnscribeAttribute

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/EnscribeAttribute"
    }
}

Nested Schema : tgtEnscribeInfo

Type: array

Show Source

• Array of: object EnscribeAttribute

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/EnscribeAttribute"
    }
}

Nested Schema : ComparePairInDetailsView

Type: object

Show Source

• columnMappings: array columnMappings
• columnsSystemMapped: boolean
  Default Value: true

  Is the key columns system mapped.
• delta: delta
• deltaProcessingEnabled: boolean
  Default Value: false

  Delta processing is enabled for this compare pair.
• enabled: boolean
  Default Value: true

  Compare Pair is enabled in the group to run.
• keyColumnsSystemMapped: boolean
  Default Value: true

  Is the key columns system mapped.
• profile: profile
  Profile Object.
• setting: object ComparePairSetting
  Mapping of a column in a table.
• srcIndexName: string
• srcRowPartitions: array srcRowPartitions
• srcTable: srcTable
  Represents a table in compare pair with table and row partitions info, if any.
• tgtIndexName: string
• tgtRowPartitions: array tgtRowPartitions
• tgtTable: tgtTable
  Represents a table in compare pair with table and row partitions info, if any.
• validationStatus: string
  Allowed Values: [ "NeverValidated", "Validated" ]

  enum for compare pair validation status.
• validationTime: string (date-time)

{
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseObject_2"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "profile":{
            "description":"Profile Object.",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BaseObject_3"
                },
                {
                    "type":"object"
                }
            ]
        },
        "srcTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "tgtTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "columnMappings":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/ColumnMapping"
            }
        },
        "setting":{
            "$ref":"#/components/schemas/ComparePairSetting"
        },
        "srcRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "tgtRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "delta":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/DeltaProcessing"
                }
            ]
        },
        "keyColumnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "columnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "srcIndexName":{
            "type":"string"
        },
        "tgtIndexName":{
            "type":"string"
        },
        "enabled":{
            "type":"boolean",
            "description":"Compare Pair is enabled in the group to run.",
            "default":true
        },
        "deltaProcessingEnabled":{
            "type":"boolean",
            "description":"Delta processing is enabled for this compare pair.",
            "default":false
        },
        "validationTime":{
            "type":"string",
            "format":"date-time"
        },
        "validationStatus":{
            "$ref":"#/components/schemas/ComparePairValidationStatus"
        }
    }
}

Match All

Show Source

• object BaseObject_2
• object ComparePairInDetailsView-allOf[1]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseObject_2"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "profile":{
            "description":"Profile Object.",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BaseObject_3"
                },
                {
                    "type":"object"
                }
            ]
        },
        "srcTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "tgtTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "columnMappings":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/ColumnMapping"
            }
        },
        "setting":{
            "$ref":"#/components/schemas/ComparePairSetting"
        },
        "srcRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "tgtRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "delta":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/DeltaProcessing"
                }
            ]
        },
        "keyColumnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "columnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "srcIndexName":{
            "type":"string"
        },
        "tgtIndexName":{
            "type":"string"
        },
        "enabled":{
            "type":"boolean",
            "description":"Compare Pair is enabled in the group to run.",
            "default":true
        },
        "deltaProcessingEnabled":{
            "type":"boolean",
            "description":"Delta processing is enabled for this compare pair.",
            "default":false
        },
        "validationTime":{
            "type":"string",
            "format":"date-time"
        },
        "validationStatus":{
            "$ref":"#/components/schemas/ComparePairValidationStatus"
        }
    }
}

Nested Schema : BaseObject_2

Type: object

Show Source

• createdOn: string (date-time)
  Pattern: YYYY-MM-DDTHH:mm:ss.sssZ

  Example: 2024-02-03T10:15:30Z
• id: integer (int64)
  Object Id.
• name: string
  Object Name.
• updatedOn: string (date-time)
  Pattern: YYYY-MM-DDTHH:mm:ss.sssZ

  Example: 2024-02-03T10:15:30Z

{
    "type":"object",
    "properties":{
        "id":{
            "type":"integer",
            "description":"Object Id.",
            "format":"int64"
        },
        "name":{
            "type":"string",
            "description":"Object Name."
        },
        "createdOn":{
            "type":"string",
            "format":"date-time",
            "pattern":"YYYY-MM-DDTHH:mm:ss.sssZ",
            "example":"2024-02-03T10:15:30Z"
        },
        "updatedOn":{
            "type":"string",
            "format":"date-time",
            "pattern":"YYYY-MM-DDTHH:mm:ss.sssZ",
            "example":"2024-02-03T10:15:30Z"
        }
    }
}

Nested Schema : ComparePairInDetailsView-allOf[1]

Type: object

Nested Schema : Group_base

Type: object

Show Source

• group: group
  Group Object.

{
    "properties":{
        "group":{
            "description":"Group Object.",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BaseObject_3"
                },
                {
                    "type":"object"
                }
            ]
        }
    }
}

Nested Schema : ComparePairInDetails-allOf[2]

Type: object

Nested Schema : EnscribeAttribute

Type: object

Show Source

• default: boolean
• defaultValue: string
• enscribeName: string
  Allowed Values: [ "AltKey", "Dictionary", "Record", "ExpandDDLRedefs", "ExpandDDLResolveDupAppend", "ExpandDDLResolveDupPrepend", "ExpandDDLExpandGroupArrays", "ExpandDDLFixLongNames", "ExpandDDLMaxColNameLen", "ExpandDDLSeparator", "ExpandDDLZeroFill" ]
• max: integer
  It is displayed when type is INTEGER.
• min: integer
  It is displayed when type is INTEGER.
• options: string
  It is displayed when type is ENUM.
• type: string
  Allowed Values: [ "BOOLEAN", "ENUM", "INTEGER", "STRING" ]
• value: string

{
    "type":"object",
    "properties":{
        "enscribeName":{
            "$ref":"#/components/schemas/EnscribeAttributeEnum"
        },
        "defaultValue":{
            "type":"string"
        },
        "default":{
            "type":"boolean"
        },
        "value":{
            "type":"string"
        },
        "type":{
            "type":"string",
            "enum":[
                "BOOLEAN",
                "ENUM",
                "INTEGER",
                "STRING"
            ]
        },
        "options":{
            "type":"string",
            "description":"It is displayed when type is ENUM."
        },
        "min":{
            "type":"integer",
            "description":"It is displayed when type is INTEGER."
        },
        "max":{
            "type":"integer",
            "description":"It is displayed when type is INTEGER."
        }
    }
}

Nested Schema : group

Group Object.

Match All

Group Object.

Group Object.

Show Source

• object BaseObject_3
• object group-allOf[1]

{
    "description":"Group Object.",
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseObject_3"
        },
        {
            "type":"object"
        }
    ]
}

Nested Schema : BaseObject_3

Type: object

Show Source

• id: integer (int64)
  Object Id.
• name: string
  Object Name.

{
    "type":"object",
    "properties":{
        "id":{
            "type":"integer",
            "description":"Object Id.",
            "format":"int64"
        },
        "name":{
            "type":"string",
            "description":"Object Name."
        }
    }
}

Nested Schema : group-allOf[1]

Type: object

201 Response

Compare Pairs created successfully.

Body ()

Root Schema : schema

Type: array

Show Source

• Array of: object ComparePairInDetails

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/ComparePairInDetails"
    }
}

Nested Schema : ComparePairInDetails

Type: object

Show Source

• srcEnscribeInfo: array srcEnscribeInfo
• tgtEnscribeInfo: array tgtEnscribeInfo

{
    "allOf":[
        {
            "$ref":"#/components/schemas/ComparePairInDetailsView"
        },
        {
            "$ref":"#/components/schemas/Group_base"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "srcEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        },
        "tgtEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        }
    }
}

Match All

Show Source

• object allOf ComparePairInDetailsView
• object Group_base
• object ComparePairInDetails-allOf[2]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/ComparePairInDetailsView"
        },
        {
            "$ref":"#/components/schemas/Group_base"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "srcEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        },
        "tgtEnscribeInfo":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/EnscribeAttribute"
            }
        }
    }
}

Nested Schema : srcEnscribeInfo

Type: array

Show Source

• Array of: object EnscribeAttribute

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/EnscribeAttribute"
    }
}

Nested Schema : tgtEnscribeInfo

Type: array

Show Source

• Array of: object EnscribeAttribute

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/EnscribeAttribute"
    }
}

Nested Schema : ComparePairInDetailsView

Type: object

Show Source

• columnMappings: array columnMappings
• columnsSystemMapped: boolean
  Default Value: true

  Is the key columns system mapped.
• delta: delta
• deltaProcessingEnabled: boolean
  Default Value: false

  Delta processing is enabled for this compare pair.
• enabled: boolean
  Default Value: true

  Compare Pair is enabled in the group to run.
• keyColumnsSystemMapped: boolean
  Default Value: true

  Is the key columns system mapped.
• profile: profile
  Profile Object.
• setting: object ComparePairSetting
  Mapping of a column in a table.
• srcIndexName: string
• srcRowPartitions: array srcRowPartitions
• srcTable: srcTable
  Represents a table in compare pair with table and row partitions info, if any.
• tgtIndexName: string
• tgtRowPartitions: array tgtRowPartitions
• tgtTable: tgtTable
  Represents a table in compare pair with table and row partitions info, if any.
• validationStatus: string
  Allowed Values: [ "NeverValidated", "Validated" ]

  enum for compare pair validation status.
• validationTime: string (date-time)

{
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseObject_2"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "profile":{
            "description":"Profile Object.",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BaseObject_3"
                },
                {
                    "type":"object"
                }
            ]
        },
        "srcTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "tgtTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "columnMappings":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/ColumnMapping"
            }
        },
        "setting":{
            "$ref":"#/components/schemas/ComparePairSetting"
        },
        "srcRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "tgtRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "delta":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/DeltaProcessing"
                }
            ]
        },
        "keyColumnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "columnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "srcIndexName":{
            "type":"string"
        },
        "tgtIndexName":{
            "type":"string"
        },
        "enabled":{
            "type":"boolean",
            "description":"Compare Pair is enabled in the group to run.",
            "default":true
        },
        "deltaProcessingEnabled":{
            "type":"boolean",
            "description":"Delta processing is enabled for this compare pair.",
            "default":false
        },
        "validationTime":{
            "type":"string",
            "format":"date-time"
        },
        "validationStatus":{
            "$ref":"#/components/schemas/ComparePairValidationStatus"
        }
    }
}

Match All

Show Source

• object BaseObject_2
• object ComparePairInDetailsView-allOf[1]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseObject_2"
        },
        {
            "type":"object"
        }
    ],
    "properties":{
        "profile":{
            "description":"Profile Object.",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BaseObject_3"
                },
                {
                    "type":"object"
                }
            ]
        },
        "srcTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "tgtTable":{
            "description":"Represents a table in compare pair with table and row partitions info, if any.\n",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BasicTable"
                },
                {
                    "type":"object"
                }
            ]
        },
        "columnMappings":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/ColumnMapping"
            }
        },
        "setting":{
            "$ref":"#/components/schemas/ComparePairSetting"
        },
        "srcRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "tgtRowPartitions":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RowPartition"
            }
        },
        "delta":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/DeltaProcessing"
                }
            ]
        },
        "keyColumnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "columnsSystemMapped":{
            "type":"boolean",
            "description":"Is the key columns system mapped.",
            "default":true
        },
        "srcIndexName":{
            "type":"string"
        },
        "tgtIndexName":{
            "type":"string"
        },
        "enabled":{
            "type":"boolean",
            "description":"Compare Pair is enabled in the group to run.",
            "default":true
        },
        "deltaProcessingEnabled":{
            "type":"boolean",
            "description":"Delta processing is enabled for this compare pair.",
            "default":false
        },
        "validationTime":{
            "type":"string",
            "format":"date-time"
        },
        "validationStatus":{
            "$ref":"#/components/schemas/ComparePairValidationStatus"
        }
    }
}

Nested Schema : BaseObject_2

Type: object

Show Source

• createdOn: string (date-time)
  Pattern: YYYY-MM-DDTHH:mm:ss.sssZ

  Example: 2024-02-03T10:15:30Z
• id: integer (int64)
  Object Id.
• name: string
  Object Name.
• updatedOn: string (date-time)
  Pattern: YYYY-MM-DDTHH:mm:ss.sssZ

  Example: 2024-02-03T10:15:30Z

{
    "type":"object",
    "properties":{
        "id":{
            "type":"integer",
            "description":"Object Id.",
            "format":"int64"
        },
        "name":{
            "type":"string",
            "description":"Object Name."
        },
        "createdOn":{
            "type":"string",
            "format":"date-time",
            "pattern":"YYYY-MM-DDTHH:mm:ss.sssZ",
            "example":"2024-02-03T10:15:30Z"
        },
        "updatedOn":{
            "type":"string",
            "format":"date-time",
            "pattern":"YYYY-MM-DDTHH:mm:ss.sssZ",
            "example":"2024-02-03T10:15:30Z"
        }
    }
}

Nested Schema : ComparePairInDetailsView-allOf[1]

Type: object

Nested Schema : Group_base

Type: object

Show Source

• group: group
  Group Object.

{
    "properties":{
        "group":{
            "description":"Group Object.",
            "allOf":[
                {
                    "$ref":"#/components/schemas/BaseObject_3"
                },
                {
                    "type":"object"
                }
            ]
        }
    }
}

Nested Schema : ComparePairInDetails-allOf[2]

Type: object

Nested Schema : EnscribeAttribute

Type: object

Show Source

• default: boolean
• defaultValue: string
• enscribeName: string
  Allowed Values: [ "AltKey", "Dictionary", "Record", "ExpandDDLRedefs", "ExpandDDLResolveDupAppend", "ExpandDDLResolveDupPrepend", "ExpandDDLExpandGroupArrays", "ExpandDDLFixLongNames", "ExpandDDLMaxColNameLen", "ExpandDDLSeparator", "ExpandDDLZeroFill" ]
• max: integer
  It is displayed when type is INTEGER.
• min: integer
  It is displayed when type is INTEGER.
• options: string
  It is displayed when type is ENUM.
• type: string
  Allowed Values: [ "BOOLEAN", "ENUM", "INTEGER", "STRING" ]
• value: string

{
    "type":"object",
    "properties":{
        "enscribeName":{
            "$ref":"#/components/schemas/EnscribeAttributeEnum"
        },
        "defaultValue":{
            "type":"string"
        },
        "default":{
            "type":"boolean"
        },
        "value":{
            "type":"string"
        },
        "type":{
            "type":"string",
            "enum":[
                "BOOLEAN",
                "ENUM",
                "INTEGER",
                "STRING"
            ]
        },
        "options":{
            "type":"string",
            "description":"It is displayed when type is ENUM."
        },
        "min":{
            "type":"integer",
            "description":"It is displayed when type is INTEGER."
        },
        "max":{
            "type":"integer",
            "description":"It is displayed when type is INTEGER."
        }
    }
}

Nested Schema : group

Group Object.

Match All

Group Object.

Group Object.

Show Source

• object BaseObject_3
• object group-allOf[1]

{
    "description":"Group Object.",
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseObject_3"
        },
        {
            "type":"object"
        }
    ]
}

Nested Schema : BaseObject_3

Type: object

Show Source

• id: integer (int64)
  Object Id.
• name: string
  Object Name.

{
    "type":"object",
    "properties":{
        "id":{
            "type":"integer",
            "description":"Object Id.",
            "format":"int64"
        },
        "name":{
            "type":"string",
            "description":"Object Name."
        }
    }
}

Nested Schema : group-allOf[1]

Type: object

400 Response

Bad Request.

Body ()

Root Schema : Error

Type: object

Show Source

• errCode: string
  Veridata Error Code.
• errMsg: string
  Veridata Error Message.

{
    "type":"object",
    "properties":{
        "errCode":{
            "type":"string",
            "description":"Veridata Error Code."
        },
        "errMsg":{
            "type":"string",
            "description":"Veridata Error Message."
        }
    },
    "example":{
        "errCode":"OGGV-00001",
        "errMsg":"Error message"
    }
}

Example:

{
    "errCode":"OGGV-00001",
    "errMsg":"Error message"
}

401 Response

Unauthorized.

Body ()

Root Schema : Error

Type: object

Show Source

• errCode: string
  Veridata Error Code.
• errMsg: string
  Veridata Error Message.

{
    "type":"object",
    "properties":{
        "errCode":{
            "type":"string",
            "description":"Veridata Error Code."
        },
        "errMsg":{
            "type":"string",
            "description":"Veridata Error Message."
        }
    },
    "example":{
        "errCode":"OGGV-00001",
        "errMsg":"Error message"
    }
}

Example:

{
    "errCode":"OGGV-00001",
    "errMsg":"Error message"
}

404 Response

Not Found.

Body ()

Root Schema : Error

Type: object

Show Source

• errCode: string
  Veridata Error Code.
• errMsg: string
  Veridata Error Message.

{
    "type":"object",
    "properties":{
        "errCode":{
            "type":"string",
            "description":"Veridata Error Code."
        },
        "errMsg":{
            "type":"string",
            "description":"Veridata Error Message."
        }
    },
    "example":{
        "errCode":"OGGV-00001",
        "errMsg":"Error message"
    }
}

Example:

{
    "errCode":"OGGV-00001",
    "errMsg":"Error message"
}

500 Response

Server Error.

Body ()

Root Schema : Error

Type: object

Show Source

• errCode: string
  Veridata Error Code.
• errMsg: string
  Veridata Error Message.

{
    "type":"object",
    "properties":{
        "errCode":{
            "type":"string",
            "description":"Veridata Error Code."
        },
        "errMsg":{
            "type":"string",
            "description":"Veridata Error Message."
        }
    },
    "example":{
        "errCode":"OGGV-00001",
        "errMsg":"Error message"
    }
}

Example:

{
    "errCode":"OGGV-00001",
    "errMsg":"Error message"
}

Back to Top