REST API for GoldenGate Veridata

Retrieve Connections

get

http://{host}:{port}/veridata/v1/services/configuration/connections

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

Returns a list of connections.

Request

Query Parameters

dbType:

Database type.
description: string

Connection description.
managed: boolean

Specifies whether the connection is associated with managed Agent.
name: string

The Connection's name.
properties: boolean

When set to true, will fetch connection properties.

Default Value: false
settings: boolean

When set to true, will fetch connection settings.

Default Value: false
ssl: string

SSL enabled Connections.

Default Value: all

Allowed Values: [ "true", "false", "all" ]

There's no request body for this operation.

Response

Supported Media Types

application/json

200 Response

Connections retrieved successfully.

Root Schema : schema

Type: array

Show Source

Array of: object items

{
    "type":"array",
    "items":{
        "allOf":[
            {
                "$ref":"#/components/schemas/BaseConnection"
            }
        ],
        "properties":{
            "dbType":{
                "$ref":"#/components/schemas/DatabaseType"
            },
            "managed":{
                "type":"boolean",
                "nullable":true,
                "description":"Specifies whether the connection is associated with managed Agent."
            },
            "properties":{
                "type":"array",
                "items":{
                    "$ref":"#/components/schemas/ConnectionProperty"
                }
            },
            "settings":{
                "type":"array",
                "items":{
                    "$ref":"#/components/schemas/RetrieveConnectionSettings"
                }
            }
        }
    },
    "example":[
        {
            "createdOn":"2025-01-02T10:45:52.080Z",
            "host":"100.00.00.00",
            "id":1083,
            "name":"Oracle-Source-Connection",
            "port":7851,
            "dbType":"oracle",
            "managed":false,
            "properties":[
                {
                    "datatype":"ARRAY",
                    "datatypeNumber":2004,
                    "defaultFormat":{
                        "defaultFormatType":"ggComparisonFormatBlob",
                        "formatName":"blob",
                        "order":0
                    },
                    "formatName":"blob"
                }
            ],
            "settings":[
                {
                    "default":true,
                    "defaultValue":true,
                    "name":"useSourceTargetAsKeys",
                    "type":"BOOLEAN",
                    "value":true
                },
                {
                    "default":true,
                    "min":0,
                    "max":100000,
                    "defaultValue":3600,
                    "name":"agentTimeout",
                    "type":"INTEGER",
                    "value":3600
                },
                {
                    "default":true,
                    "min":0,
                    "max":100000,
                    "defaultValue":1000,
                    "name":"fetchSize",
                    "type":"INTEGER",
                    "value":1000
                }
            ],
            "updatedOn":"2025-01-02T10:45:52Z"
        },
        {
            "createdOn":"2025-01-02T10:45:52.080Z",
            "host":"100.00.00.00",
            "id":1084,
            "name":"Oracle-Target-Connection",
            "port":7852,
            "dbType":"oracle",
            "managed":true,
            "properties":[
                {
                    "datatype":"ARRAY",
                    "datatypeNumber":2004,
                    "defaultFormat":{
                        "defaultFormatType":"ggComparisonFormatBlob",
                        "formatName":"blob",
                        "order":0
                    },
                    "formatName":"blob"
                }
            ],
            "settings":[
                {
                    "default":true,
                    "defaultValue":true,
                    "name":"useSourceTargetAsKeys",
                    "type":"BOOLEAN",
                    "value":true
                },
                {
                    "default":true,
                    "min":0,
                    "max":100000,
                    "defaultValue":3600,
                    "name":"agentTimeout",
                    "type":"INTEGER",
                    "value":3600
                },
                {
                    "default":true,
                    "min":0,
                    "max":100000,
                    "defaultValue":1000,
                    "name":"fetchSize",
                    "type":"INTEGER",
                    "value":1000
                }
            ],
            "updatedOn":"2025-01-02T10:45:52Z"
        }
    ]
}

Example:

[
    {
        "createdOn":"2025-01-02T10:45:52.080Z",
        "host":"100.00.00.00",
        "id":1083,
        "name":"Oracle-Source-Connection",
        "port":7851,
        "dbType":"oracle",
        "managed":false,
        "properties":[
            {
                "datatype":"ARRAY",
                "datatypeNumber":2004,
                "defaultFormat":{
                    "defaultFormatType":"ggComparisonFormatBlob",
                    "formatName":"blob",
                    "order":0
                },
                "formatName":"blob"
            }
        ],
        "settings":[
            {
                "default":true,
                "defaultValue":true,
                "name":"useSourceTargetAsKeys",
                "type":"BOOLEAN",
                "value":true
            },
            {
                "default":true,
                "min":0,
                "max":100000,
                "defaultValue":3600,
                "name":"agentTimeout",
                "type":"INTEGER",
                "value":3600
            },
            {
                "default":true,
                "min":0,
                "max":100000,
                "defaultValue":1000,
                "name":"fetchSize",
                "type":"INTEGER",
                "value":1000
            }
        ],
        "updatedOn":"2025-01-02T10:45:52Z"
    },
    {
        "createdOn":"2025-01-02T10:45:52.080Z",
        "host":"100.00.00.00",
        "id":1084,
        "name":"Oracle-Target-Connection",
        "port":7852,
        "dbType":"oracle",
        "managed":true,
        "properties":[
            {
                "datatype":"ARRAY",
                "datatypeNumber":2004,
                "defaultFormat":{
                    "defaultFormatType":"ggComparisonFormatBlob",
                    "formatName":"blob",
                    "order":0
                },
                "formatName":"blob"
            }
        ],
        "settings":[
            {
                "default":true,
                "defaultValue":true,
                "name":"useSourceTargetAsKeys",
                "type":"BOOLEAN",
                "value":true
            },
            {
                "default":true,
                "min":0,
                "max":100000,
                "defaultValue":3600,
                "name":"agentTimeout",
                "type":"INTEGER",
                "value":3600
            },
            {
                "default":true,
                "min":0,
                "max":100000,
                "defaultValue":1000,
                "name":"fetchSize",
                "type":"INTEGER",
                "value":1000
            }
        ],
        "updatedOn":"2025-01-02T10:45:52Z"
    }
]

Nested Schema : items

Type: object

Show Source

dbType: string

Allowed Values: [ "NOTSPECIFIED", "ORACLE", "TANDEMNSK", "SQLSERVER", "SYBASE", "DB2", "TERADATA", "INFORMIX", "HIVE", "MYSQL", "POSTGRESQL", "MARIADB", "SINGLESTORE", "DATABRICKS", "SNOWFLAKE", "MONGODB", "JCT", "AJD", "COSMOS", "ATLAS", "docDB" ]

Database Type.
managed: boolean

Specifies whether the connection is associated with managed Agent.
properties: array properties
settings: array settings

{
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseConnection"
        }
    ],
    "properties":{
        "dbType":{
            "$ref":"#/components/schemas/DatabaseType"
        },
        "managed":{
            "type":"boolean",
            "nullable":true,
            "description":"Specifies whether the connection is associated with managed Agent."
        },
        "properties":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/ConnectionProperty"
            }
        },
        "settings":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RetrieveConnectionSettings"
            }
        }
    }
}

Match All

Show Source

object BaseConnection

{
    "allOf":[
        {
            "$ref":"#/components/schemas/BaseConnection"
        }
    ],
    "properties":{
        "dbType":{
            "$ref":"#/components/schemas/DatabaseType"
        },
        "managed":{
            "type":"boolean",
            "nullable":true,
            "description":"Specifies whether the connection is associated with managed Agent."
        },
        "properties":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/ConnectionProperty"
            }
        },
        "settings":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/RetrieveConnectionSettings"
            }
        }
    }
}

Nested Schema : properties

Type: array

Show Source

Array of: object ConnectionProperty

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

Nested Schema : settings

Type: array

Show Source

Array of: object RetrieveConnectionSettings

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

Nested Schema : BaseConnection

Type: object

Show Source

createdOn: string (date-time)

Pattern: YYYY-MM-DDTHH:mm:ss.sssZ

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

Connection Description.
host: string

Veridata Agent Host.
id: integer (int64)

Connection Id.
name: string

Connection Name.
port: integer (int32)

Veridata Agent Port.
updatedOn: string (date-time)

Pattern: YYYY-MM-DDTHH:mm:ss.sssZ

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

{
    "type":"object",
    "properties":{
        "id":{
            "type":"integer",
            "description":"Connection Id.",
            "format":"int64"
        },
        "name":{
            "type":"string",
            "description":"Connection Name."
        },
        "description":{
            "type":"string",
            "description":"Connection Description."
        },
        "host":{
            "type":"string",
            "description":"Veridata Agent Host."
        },
        "port":{
            "type":"integer",
            "description":"Veridata Agent Port.",
            "format":"int32"
        },
        "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"
        }
    },
    "example":{
        "createdOn":"2025-04-02T11:20:51.269Z",
        "description":"Connection to source Oracle Database",
        "host":"100.00.00.00",
        "id":1090,
        "name":"Oracle-Connection-Source",
        "port":7800
    }
}

Example:

{
    "createdOn":"2025-04-02T11:20:51.269Z",
    "description":"Connection to source Oracle Database",
    "host":"100.00.00.00",
    "id":1090,
    "name":"Oracle-Connection-Source",
    "port":7800
}

Nested Schema : ConnectionProperty

Type: object

Show Source

compareFormat: string

Allowed Values: [ "string", "string_en", "binary", "timestamp", "timestamp_tz", "date", "time", "datetime", "smalldatetime", "clob", "blob", "Float", "dec_float", "interval", "number", "binary_timestamp", "string_nfc", "clob_nfc", "sybtime", "bit", "Double" ]

Compare Format.
dataType: string
isDefault: boolean

Default Value: true

Defines if default property is used or not.
precision: integer (int32)
scale: integer (int32)
timezone: string

{
    "type":"object",
    "properties":{
        "dataType":{
            "type":"string"
        },
        "compareFormat":{
            "$ref":"#/components/schemas/CompareFormat"
        },
        "precision":{
            "type":"integer",
            "format":"int32"
        },
        "scale":{
            "type":"integer",
            "format":"int32"
        },
        "timezone":{
            "type":"string"
        },
        "isDefault":{
            "type":"boolean",
            "description":"Defines if default property is used or not.",
            "default":true
        }
    }
}

Nested Schema : RetrieveConnectionSettings

Type: object

Show Source

default: boolean
defaultValue: object defaultValue
max: integer
min: integer
name: string
type: string

Allowed Values: [ "BOOLEAN", "ENUM", "INTEGER", "STRING" ]
value: object value

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string"
        },
        "default":{
            "type":"boolean"
        },
        "defaultValue":{
            "type":"object"
        },
        "value":{
            "type":"object"
        },
        "type":{
            "type":"string",
            "enum":[
                "BOOLEAN",
                "ENUM",
                "INTEGER",
                "STRING"
            ]
        },
        "min":{
            "type":"integer"
        },
        "max":{
            "type":"integer"
        }
    },
    "example":[
        {
            "default":true,
            "defaultValue":true,
            "name":"useSourceTargetAsKeys",
            "type":"BOOLEAN",
            "value":"true"
        },
        {
            "default":true,
            "defaultValue":true,
            "name":"useAllColsAsKeys",
            "type":"BOOLEAN",
            "value":"true"
        },
        {
            "default":true,
            "defaultValue":1000,
            "name":"fetchSize",
            "type":"INTEGER",
            "value":"1000"
        },
        {
            "default":true,
            "min":0,
            "max":10000000,
            "defaultValue":3600,
            "name":"agentTimeout",
            "type":"INTEGER",
            "value":"3600"
        }
    ]
}

Example:

[
    {
        "default":true,
        "defaultValue":true,
        "name":"useSourceTargetAsKeys",
        "type":"BOOLEAN",
        "value":"true"
    },
    {
        "default":true,
        "defaultValue":true,
        "name":"useAllColsAsKeys",
        "type":"BOOLEAN",
        "value":"true"
    },
    {
        "default":true,
        "defaultValue":1000,
        "name":"fetchSize",
        "type":"INTEGER",
        "value":"1000"
    },
    {
        "default":true,
        "min":0,
        "max":10000000,
        "defaultValue":3600,
        "name":"agentTimeout",
        "type":"INTEGER",
        "value":"3600"
    }
]

Nested Schema : defaultValue

Type: object

Nested Schema : value

Type: object

400 Response

Bad Request.

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.

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.

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.

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"
}