setCosConn stored procedure

Input parameters

object_store_type

The type of this required parameter is VARCHAR(20). Object storage types that are currently supported by Data Virtualization include 'AWS3', 'IBMCOS', and 'CEPH'.

endpoint_URL

The type of this required parameter is VARCHAR(32672). Specifies the endpoint URL of the object storage. For example, 's3.eu-central-1.amazonaws.com'.

bucket

The type of this optional parameter is VARCHAR(32672). Specifies a bucket name for the endpoint. If this parameter is omitted, it indicates a global connection. You can specify one global connection per Data Virtualization instance.

access_key

The type of this required parameter is VARCHAR(32672). Specifies the access key for the object storage.

secret_key

The type of this required parameter is VARCHAR(32672). Specifies the secret key for the object storage.

SSL_certificate

The type of this optional parameter is VARCHAR(32672). This parameter is not supported.

additional_properties_for_common_connectivity

The type of this optional parameter is VARCHAR(32672).

additional_options

The type of this optional parameter is VARCHAR(32672). Specifies a comma-delimited list of extra parameters in the following format: '<key1>=<value1>, <key2>=<value2>, ...'. Supported options include EDITCID (change properties for a given CID) and CCID (provide a common connectivity ID).

Output parameters

connection_ID

The type of this parameter is VARCHAR(20). Represents the generated connection ID for Data Virtualization.

diagnostics

The type of this parameter is VARCHAR(32672). Represents diagnostic output if a failure occurs.

Example

call DVSYS.setcosconn('AWS3', 's3.eu-central-1.amazonaws.com', 'myNewBucket', '<ACCESS_KEY>', '<SECRET_KEY>', null, null, null, ?, ?)

  Value of output parameters
  --------------------------
  Parameter Name  : CONNECTIONID
  Parameter Value : AWS310001

  Parameter Name  : DIAGS
  Parameter Value : -

  Return Status = 0