Chilkat Online Tools

CreateEndpoint SQL Server Example

AWS Database Migration Service

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(max)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @rest int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Rest', @rest OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    DECLARE @authAws int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.AuthAws', @authAws OUT

    EXEC sp_OASetProperty @authAws, 'AccessKey', 'AWS_ACCESS_KEY'
    EXEC sp_OASetProperty @authAws, 'SecretKey', 'AWS_SECRET_KEY'

    -- Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
    EXEC sp_OASetProperty @authAws, 'Region', 'us-west-2'
    EXEC sp_OASetProperty @authAws, 'ServiceName', 'dms'
    -- SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
    EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws

    -- URL: https://dms.us-west-2.amazonaws.com/
    -- Use the same region as specified above.
    EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'dms.us-west-2.amazonaws.com', 443, 1, 1
    IF @success <> 1
      BEGIN

        EXEC sp_OAGetProperty @rest, 'ConnectFailReason', @iTmp0 OUT
        PRINT 'ConnectFailReason: ' + @iTmp0
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @authAws
        RETURN
      END

    -- The following code creates the JSON request body.
    -- The JSON created by this code is shown below.

    -- Use this online tool to generate code from sample JSON:
    -- Generate Code to Create JSON

    DECLARE @json int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT

    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'CertificateArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DmsTransferSettings.BucketName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DmsTransferSettings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'DocDbSettings.DocsToInvestigate', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'DocDbSettings.ExtractDocId', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.KmsKeyId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.NestingLevel', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'DocDbSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DocDbSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'DynamoDbSettings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ElasticsearchSettings.EndpointUri', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'ElasticsearchSettings.ErrorRetryDuration', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'ElasticsearchSettings.FullLoadErrorPercentage', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ElasticsearchSettings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'EndpointIdentifier', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'EndpointType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'EngineName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ExternalTableDefinition', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ExtraConnectionAttributes', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.AfterConnectScript', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'GcpMySQLSettings.CleanSourceMetadataOnMismatch', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'GcpMySQLSettings.EventsPollInterval', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'GcpMySQLSettings.MaxFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'GcpMySQLSettings.ParallelLoadThreads', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'GcpMySQLSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.ServerTimezone', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.TargetDbType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'GcpMySQLSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.CurrentLsn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'IBMDb2Settings.MaxKBytesPerRead', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'IBMDb2Settings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'IBMDb2Settings.SetDataCaptureChanges', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'IBMDb2Settings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.Broker', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.IncludeControlDetails', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.IncludeNullAndEmpty', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.IncludePartitionValue', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.IncludeTableAlterOperations', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.IncludeTransactionDetails', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.MessageFormat', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.MessageMaxBytes', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.NoHexPrefix', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KafkaSettings.PartitionIncludeSchemaTable', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SaslPassword', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SaslUsername', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SecurityProtocol', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SslCaCertificateArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SslClientCertificateArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SslClientKeyArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.SslClientKeyPassword', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KafkaSettings.Topic', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.IncludeControlDetails', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.IncludeNullAndEmpty', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.IncludePartitionValue', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.IncludeTableAlterOperations', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.IncludeTransactionDetails', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KinesisSettings.MessageFormat', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.NoHexPrefix', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'KinesisSettings.PartitionIncludeSchemaTable', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KinesisSettings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KinesisSettings.StreamArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'KmsKeyId', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MicrosoftSQLServerSettings.BcpPacketSize', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.ControlTablesFileGroup', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MicrosoftSQLServerSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MicrosoftSQLServerSettings.ReadBackupOnly', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.SafeguardPolicy', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MicrosoftSQLServerSettings.UseBcpFullLoad', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MicrosoftSQLServerSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MicrosoftSQLServerSettings.UseThirdPartyBackupDevice', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.AuthMechanism', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.AuthSource', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.AuthType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.DocsToInvestigate', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.ExtractDocId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.KmsKeyId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.NestingLevel', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MongoDbSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MongoDbSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.AfterConnectScript', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MySQLSettings.CleanSourceMetadataOnMismatch', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MySQLSettings.EventsPollInterval', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MySQLSettings.MaxFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MySQLSettings.ParallelLoadThreads', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MySQLSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.ServerTimezone', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.TargetDbType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'MySQLSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'NeptuneSettings.ErrorRetryDuration', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'NeptuneSettings.IamAuthEnabled', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'NeptuneSettings.MaxFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'NeptuneSettings.MaxRetryCount', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'NeptuneSettings.S3BucketFolder', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'NeptuneSettings.S3BucketName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'NeptuneSettings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.AccessAlternateDirectly', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.AdditionalArchivedLogDestId', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.AddSupplementalLogging', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.AllowSelectNestedTables', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ArchivedLogDestId', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ArchivedLogsOnly', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.AsmPassword', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.AsmServer', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.AsmUser', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.CharLengthSemantics', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.DirectPathNoLog', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.DirectPathParallelLoad', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.EnableHomogenousTablespace', 123
ERROR: Undefined variable(number)
ERROR: No et type for expression.
ERROR: No expression type in SQL
ERROR: xExpr = 
<vac v="number"/>

    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ExtraArchivedLogDestIds[0]',ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)

    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.FailTasksOnLobTruncation', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.NumberDatatypeScale', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.OraclePathPrefix', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ParallelAsmReadThreads', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ReadAheadBlocks', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ReadTableSpaceName', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.ReplacePathPrefix', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.RetryInterval', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SecretsManagerOracleAsmAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SecretsManagerOracleAsmSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SecurityDbEncryption', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SecurityDbEncryptionName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.SpatialDataOptionToGeoJsonFunctionName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.StandbyDelayTime', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.UseAlternateFolderForOnline', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.UseBFile', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.UseDirectPathFullLoad', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'OracleSettings.UseLogminerReader', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.UsePathPrefix', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'OracleSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.AfterConnectScript', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.CaptureDdls', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.DdlArtifactsSchema', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.ExecuteTimeout', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.FailTasksOnLobTruncation', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.HeartbeatEnable', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.HeartbeatFrequency', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.HeartbeatSchema', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.MaxFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.PluginName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'PostgreSQLSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.SlotName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'PostgreSQLSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedisSettings.AuthPassword', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedisSettings.AuthType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedisSettings.AuthUserName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedisSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedisSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedisSettings.SslCaCertificateArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedisSettings.SslSecurityProtocol', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.AcceptAnyDate', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.AfterConnectScript', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.BucketFolder', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.BucketName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.CaseSensitiveNames', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.CompUpdate', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.ConnectionTimeout', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.DateFormat', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.EmptyAsNull', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.EncryptionMode', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.ExplicitIds', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.FileTransferUploadStreams', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.LoadTimeout', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.MaxFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.RemoveQuotes', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.ReplaceChars', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.ReplaceInvalidChars', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.ServerSideEncryptionKmsKeyId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.TimeFormat', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.TrimBlanks', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.TruncateColumns', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'RedshiftSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'RedshiftSettings.WriteBufferSize', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ResourceIdentifier', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.AddColumnName', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.BucketFolder', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.BucketName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CannedAclForObjects', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.CdcInsertsAndUpdates', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.CdcInsertsOnly', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.CdcMaxBatchInterval', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.CdcMinFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CdcPath', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CompressionType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CsvDelimiter', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CsvNoSupValue', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CsvNullValue', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.CsvRowDelimiter', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.DataFormat', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.DataPageSize', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.DatePartitionDelimiter', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.DatePartitionEnabled', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.DatePartitionSequence', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.DatePartitionTimezone', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.DictPageSizeLimit', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.EnableStatistics', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.EncodingType', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.EncryptionMode', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.ExternalTableDefinition', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.IgnoreHeaderRows', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.IncludeOpForFullLoad', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.MaxFileSize', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.ParquetTimestampInMillisecond', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.ParquetVersion', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.PreserveTransactions', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.Rfc4180', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.RowGroupLength', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.ServerSideEncryptionKmsKeyId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'S3Settings.TimestampColumnName', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.UseCsvNoSupValue', 123
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'S3Settings.UseTaskStartTimeForFullLoadTimestamp', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ServiceAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SslMode', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SybaseSettings.DatabaseName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SybaseSettings.Password', 'string'
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'SybaseSettings.Port', 123
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SybaseSettings.SecretsManagerAccessRoleArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SybaseSettings.SecretsManagerSecretId', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SybaseSettings.ServerName', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'SybaseSettings.Username', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Tags[0].Key', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Tags[0].ResourceArn', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Tags[0].Value', 'string'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Username', 'string'

    -- The JSON request body created by the above code:

    -- {
    --   "CertificateArn": "string",
    --   "DatabaseName": "string",
    --   "DmsTransferSettings": {
    --     "BucketName": "string",
    --     "ServiceAccessRoleArn": "string"
    --   },
    --   "DocDbSettings": {
    --     "DatabaseName": "string",
    --     "DocsToInvestigate": number,
    --     "ExtractDocId": boolean,
    --     "KmsKeyId": "string",
    --     "NestingLevel": "string",
    --     "Password": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "Username": "string"
    --   },
    --   "DynamoDbSettings": {
    --     "ServiceAccessRoleArn": "string"
    --   },
    --   "ElasticsearchSettings": {
    --     "EndpointUri": "string",
    --     "ErrorRetryDuration": number,
    --     "FullLoadErrorPercentage": number,
    --     "ServiceAccessRoleArn": "string"
    --   },
    --   "EndpointIdentifier": "string",
    --   "EndpointType": "string",
    --   "EngineName": "string",
    --   "ExternalTableDefinition": "string",
    --   "ExtraConnectionAttributes": "string",
    --   "GcpMySQLSettings": {
    --     "AfterConnectScript": "string",
    --     "CleanSourceMetadataOnMismatch": boolean,
    --     "DatabaseName": "string",
    --     "EventsPollInterval": number,
    --     "MaxFileSize": number,
    --     "ParallelLoadThreads": number,
    --     "Password": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "ServerTimezone": "string",
    --     "TargetDbType": "string",
    --     "Username": "string"
    --   },
    --   "IBMDb2Settings": {
    --     "CurrentLsn": "string",
    --     "DatabaseName": "string",
    --     "MaxKBytesPerRead": number,
    --     "Password": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "SetDataCaptureChanges": boolean,
    --     "Username": "string"
    --   },
    --   "KafkaSettings": {
    --     "Broker": "string",
    --     "IncludeControlDetails": boolean,
    --     "IncludeNullAndEmpty": boolean,
    --     "IncludePartitionValue": boolean,
    --     "IncludeTableAlterOperations": boolean,
    --     "IncludeTransactionDetails": boolean,
    --     "MessageFormat": "string",
    --     "MessageMaxBytes": number,
    --     "NoHexPrefix": boolean,
    --     "PartitionIncludeSchemaTable": boolean,
    --     "SaslPassword": "string",
    --     "SaslUsername": "string",
    --     "SecurityProtocol": "string",
    --     "SslCaCertificateArn": "string",
    --     "SslClientCertificateArn": "string",
    --     "SslClientKeyArn": "string",
    --     "SslClientKeyPassword": "string",
    --     "Topic": "string"
    --   },
    --   "KinesisSettings": {
    --     "IncludeControlDetails": boolean,
    --     "IncludeNullAndEmpty": boolean,
    --     "IncludePartitionValue": boolean,
    --     "IncludeTableAlterOperations": boolean,
    --     "IncludeTransactionDetails": boolean,
    --     "MessageFormat": "string",
    --     "NoHexPrefix": boolean,
    --     "PartitionIncludeSchemaTable": boolean,
    --     "ServiceAccessRoleArn": "string",
    --     "StreamArn": "string"
    --   },
    --   "KmsKeyId": "string",
    --   "MicrosoftSQLServerSettings": {
    --     "BcpPacketSize": number,
    --     "ControlTablesFileGroup": "string",
    --     "DatabaseName": "string",
    --     "Password": "string",
    --     "Port": number,
    --     "QuerySingleAlwaysOnNode": boolean,
    --     "ReadBackupOnly": boolean,
    --     "SafeguardPolicy": "string",
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "UseBcpFullLoad": boolean,
    --     "Username": "string",
    --     "UseThirdPartyBackupDevice": boolean
    --   },
    --   "MongoDbSettings": {
    --     "AuthMechanism": "string",
    --     "AuthSource": "string",
    --     "AuthType": "string",
    --     "DatabaseName": "string",
    --     "DocsToInvestigate": "string",
    --     "ExtractDocId": "string",
    --     "KmsKeyId": "string",
    --     "NestingLevel": "string",
    --     "Password": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "Username": "string"
    --   },
    --   "MySQLSettings": {
    --     "AfterConnectScript": "string",
    --     "CleanSourceMetadataOnMismatch": boolean,
    --     "DatabaseName": "string",
    --     "EventsPollInterval": number,
    --     "MaxFileSize": number,
    --     "ParallelLoadThreads": number,
    --     "Password": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "ServerTimezone": "string",
    --     "TargetDbType": "string",
    --     "Username": "string"
    --   },
    --   "NeptuneSettings": {
    --     "ErrorRetryDuration": number,
    --     "IamAuthEnabled": boolean,
    --     "MaxFileSize": number,
    --     "MaxRetryCount": number,
    --     "S3BucketFolder": "string",
    --     "S3BucketName": "string",
    --     "ServiceAccessRoleArn": "string"
    --   },
    --   "OracleSettings": {
    --     "AccessAlternateDirectly": boolean,
    --     "AdditionalArchivedLogDestId": number,
    --     "AddSupplementalLogging": boolean,
    --     "AllowSelectNestedTables": boolean,
    --     "ArchivedLogDestId": number,
    --     "ArchivedLogsOnly": boolean,
    --     "AsmPassword": "string",
    --     "AsmServer": "string",
    --     "AsmUser": "string",
    --     "CharLengthSemantics": "string",
    --     "DatabaseName": "string",
    --     "DirectPathNoLog": boolean,
    --     "DirectPathParallelLoad": boolean,
    --     "EnableHomogenousTablespace": boolean,
    --     "ExtraArchivedLogDestIds": [
    --       number
    --     ],
    --     "FailTasksOnLobTruncation": boolean,
    --     "NumberDatatypeScale": number,
    --     "OraclePathPrefix": "string",
    --     "ParallelAsmReadThreads": number,
    --     "Password": "string",
    --     "Port": number,
    --     "ReadAheadBlocks": number,
    --     "ReadTableSpaceName": boolean,
    --     "ReplacePathPrefix": boolean,
    --     "RetryInterval": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerOracleAsmAccessRoleArn": "string",
    --     "SecretsManagerOracleAsmSecretId": "string",
    --     "SecretsManagerSecretId": "string",
    --     "SecurityDbEncryption": "string",
    --     "SecurityDbEncryptionName": "string",
    --     "ServerName": "string",
    --     "SpatialDataOptionToGeoJsonFunctionName": "string",
    --     "StandbyDelayTime": number,
    --     "UseAlternateFolderForOnline": boolean,
    --     "UseBFile": boolean,
    --     "UseDirectPathFullLoad": boolean,
    --     "UseLogminerReader": boolean,
    --     "UsePathPrefix": "string",
    --     "Username": "string"
    --   },
    --   "Password": "string",
    --   "Port": number,
    --   "PostgreSQLSettings": {
    --     "AfterConnectScript": "string",
    --     "CaptureDdls": boolean,
    --     "DatabaseName": "string",
    --     "DdlArtifactsSchema": "string",
    --     "ExecuteTimeout": number,
    --     "FailTasksOnLobTruncation": boolean,
    --     "HeartbeatEnable": boolean,
    --     "HeartbeatFrequency": number,
    --     "HeartbeatSchema": "string",
    --     "MaxFileSize": number,
    --     "Password": "string",
    --     "PluginName": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "SlotName": "string",
    --     "Username": "string"
    --   },
    --   "RedisSettings": {
    --     "AuthPassword": "string",
    --     "AuthType": "string",
    --     "AuthUserName": "string",
    --     "Port": number,
    --     "ServerName": "string",
    --     "SslCaCertificateArn": "string",
    --     "SslSecurityProtocol": "string"
    --   },
    --   "RedshiftSettings": {
    --     "AcceptAnyDate": boolean,
    --     "AfterConnectScript": "string",
    --     "BucketFolder": "string",
    --     "BucketName": "string",
    --     "CaseSensitiveNames": boolean,
    --     "CompUpdate": boolean,
    --     "ConnectionTimeout": number,
    --     "DatabaseName": "string",
    --     "DateFormat": "string",
    --     "EmptyAsNull": boolean,
    --     "EncryptionMode": "string",
    --     "ExplicitIds": boolean,
    --     "FileTransferUploadStreams": number,
    --     "LoadTimeout": number,
    --     "MaxFileSize": number,
    --     "Password": "string",
    --     "Port": number,
    --     "RemoveQuotes": boolean,
    --     "ReplaceChars": "string",
    --     "ReplaceInvalidChars": "string",
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "ServerSideEncryptionKmsKeyId": "string",
    --     "ServiceAccessRoleArn": "string",
    --     "TimeFormat": "string",
    --     "TrimBlanks": boolean,
    --     "TruncateColumns": boolean,
    --     "Username": "string",
    --     "WriteBufferSize": number
    --   },
    --   "ResourceIdentifier": "string",
    --   "S3Settings": {
    --     "AddColumnName": boolean,
    --     "BucketFolder": "string",
    --     "BucketName": "string",
    --     "CannedAclForObjects": "string",
    --     "CdcInsertsAndUpdates": boolean,
    --     "CdcInsertsOnly": boolean,
    --     "CdcMaxBatchInterval": number,
    --     "CdcMinFileSize": number,
    --     "CdcPath": "string",
    --     "CompressionType": "string",
    --     "CsvDelimiter": "string",
    --     "CsvNoSupValue": "string",
    --     "CsvNullValue": "string",
    --     "CsvRowDelimiter": "string",
    --     "DataFormat": "string",
    --     "DataPageSize": number,
    --     "DatePartitionDelimiter": "string",
    --     "DatePartitionEnabled": boolean,
    --     "DatePartitionSequence": "string",
    --     "DatePartitionTimezone": "string",
    --     "DictPageSizeLimit": number,
    --     "EnableStatistics": boolean,
    --     "EncodingType": "string",
    --     "EncryptionMode": "string",
    --     "ExternalTableDefinition": "string",
    --     "IgnoreHeaderRows": number,
    --     "IncludeOpForFullLoad": boolean,
    --     "MaxFileSize": number,
    --     "ParquetTimestampInMillisecond": boolean,
    --     "ParquetVersion": "string",
    --     "PreserveTransactions": boolean,
    --     "Rfc4180": boolean,
    --     "RowGroupLength": number,
    --     "ServerSideEncryptionKmsKeyId": "string",
    --     "ServiceAccessRoleArn": "string",
    --     "TimestampColumnName": "string",
    --     "UseCsvNoSupValue": boolean,
    --     "UseTaskStartTimeForFullLoadTimestamp": boolean
    --   },
    --   "ServerName": "string",
    --   "ServiceAccessRoleArn": "string",
    --   "SslMode": "string",
    --   "SybaseSettings": {
    --     "DatabaseName": "string",
    --     "Password": "string",
    --     "Port": number,
    --     "SecretsManagerAccessRoleArn": "string",
    --     "SecretsManagerSecretId": "string",
    --     "ServerName": "string",
    --     "Username": "string"
    --   },
    --   "Tags": [
    --     {
    --       "Key": "string",
    --       "ResourceArn": "string",
    --       "Value": "string"
    --     }
    --   ],
    --   "Username": "string"
    -- }

    EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'Content-Type', 'application/x-amz-json-1.1'
    EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'X-Amz-Target', 'AmazonDMSv20160101.CreateEndpoint'

    DECLARE @sbRequestBody int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbRequestBody OUT

    EXEC sp_OAMethod @json, 'EmitSb', @success OUT, @sbRequestBody
    DECLARE @sbResponseBody int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT

    EXEC sp_OAMethod @rest, 'FullRequestSb', @success OUT, 'POST', '/', @sbRequestBody, @sbResponseBody
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @authAws
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @sbRequestBody
        EXEC @hr = sp_OADestroy @sbResponseBody
        RETURN
      END
    DECLARE @respStatusCode int
    EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @respStatusCode OUT

    PRINT 'response status code = ' + @respStatusCode
    IF @respStatusCode <> 200
      BEGIN

        PRINT 'Response Header:'
        EXEC sp_OAGetProperty @rest, 'ResponseHeader', @sTmp0 OUT
        PRINT @sTmp0

        PRINT 'Response Body:'
        EXEC sp_OAMethod @sbResponseBody, 'GetAsString', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @authAws
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @sbRequestBody
        EXEC @hr = sp_OADestroy @sbResponseBody
        RETURN
      END

    DECLARE @jResp int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT

    EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody

    -- The following code parses the JSON response.
    -- A sample JSON response is shown below the sample code.

    -- Use this online tool to generate parsing code from sample JSON:
    -- Generate Parsing Code from JSON

    DECLARE @intVal int

    DECLARE @CertificateArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CertificateArn OUT, 'Endpoint.CertificateArn'
    DECLARE @DatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DatabaseName OUT, 'Endpoint.DatabaseName'
    DECLARE @BucketName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @BucketName OUT, 'Endpoint.DmsTransferSettings.BucketName'
    DECLARE @ServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ServiceAccessRoleArn OUT, 'Endpoint.DmsTransferSettings.ServiceAccessRoleArn'
    DECLARE @DocDbSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DocDbSettingsDatabaseName OUT, 'Endpoint.DocDbSettings.DatabaseName'
    DECLARE @DocsToInvestigate int
    EXEC sp_OAMethod @jResp, 'IntOf', @DocsToInvestigate OUT, 'Endpoint.DocDbSettings.DocsToInvestigate'
    DECLARE @ExtractDocId int
    EXEC sp_OAMethod @jResp, 'IntOf', @ExtractDocId OUT, 'Endpoint.DocDbSettings.ExtractDocId'
    DECLARE @KmsKeyId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @KmsKeyId OUT, 'Endpoint.DocDbSettings.KmsKeyId'
    DECLARE @NestingLevel nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @NestingLevel OUT, 'Endpoint.DocDbSettings.NestingLevel'
    DECLARE @Password nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @Password OUT, 'Endpoint.DocDbSettings.Password'
    DECLARE @Port int
    EXEC sp_OAMethod @jResp, 'IntOf', @Port OUT, 'Endpoint.DocDbSettings.Port'
    DECLARE @SecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecretsManagerAccessRoleArn OUT, 'Endpoint.DocDbSettings.SecretsManagerAccessRoleArn'
    DECLARE @SecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecretsManagerSecretId OUT, 'Endpoint.DocDbSettings.SecretsManagerSecretId'
    DECLARE @ServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ServerName OUT, 'Endpoint.DocDbSettings.ServerName'
    DECLARE @Username nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @Username OUT, 'Endpoint.DocDbSettings.Username'
    DECLARE @DynamoDbSettingsServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DynamoDbSettingsServiceAccessRoleArn OUT, 'Endpoint.DynamoDbSettings.ServiceAccessRoleArn'
    DECLARE @EndpointUri nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointUri OUT, 'Endpoint.ElasticsearchSettings.EndpointUri'
    DECLARE @ErrorRetryDuration int
    EXEC sp_OAMethod @jResp, 'IntOf', @ErrorRetryDuration OUT, 'Endpoint.ElasticsearchSettings.ErrorRetryDuration'
    DECLARE @FullLoadErrorPercentage int
    EXEC sp_OAMethod @jResp, 'IntOf', @FullLoadErrorPercentage OUT, 'Endpoint.ElasticsearchSettings.FullLoadErrorPercentage'
    DECLARE @ElasticsearchSettingsServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchSettingsServiceAccessRoleArn OUT, 'Endpoint.ElasticsearchSettings.ServiceAccessRoleArn'
    DECLARE @EndpointArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointArn OUT, 'Endpoint.EndpointArn'
    DECLARE @EndpointIdentifier nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointIdentifier OUT, 'Endpoint.EndpointIdentifier'
    DECLARE @EndpointType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointType OUT, 'Endpoint.EndpointType'
    DECLARE @EngineDisplayName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EngineDisplayName OUT, 'Endpoint.EngineDisplayName'
    DECLARE @EngineName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EngineName OUT, 'Endpoint.EngineName'
    DECLARE @ExternalId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ExternalId OUT, 'Endpoint.ExternalId'
    DECLARE @ExternalTableDefinition nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ExternalTableDefinition OUT, 'Endpoint.ExternalTableDefinition'
    DECLARE @ExtraConnectionAttributes nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ExtraConnectionAttributes OUT, 'Endpoint.ExtraConnectionAttributes'
    DECLARE @AfterConnectScript nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AfterConnectScript OUT, 'Endpoint.GcpMySQLSettings.AfterConnectScript'
    DECLARE @CleanSourceMetadataOnMismatch int
    EXEC sp_OAMethod @jResp, 'IntOf', @CleanSourceMetadataOnMismatch OUT, 'Endpoint.GcpMySQLSettings.CleanSourceMetadataOnMismatch'
    DECLARE @GcpMySQLSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @GcpMySQLSettingsDatabaseName OUT, 'Endpoint.GcpMySQLSettings.DatabaseName'
    DECLARE @EventsPollInterval int
    EXEC sp_OAMethod @jResp, 'IntOf', @EventsPollInterval OUT, 'Endpoint.GcpMySQLSettings.EventsPollInterval'
    DECLARE @MaxFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @MaxFileSize OUT, 'Endpoint.GcpMySQLSettings.MaxFileSize'
    DECLARE @ParallelLoadThreads int
    EXEC sp_OAMethod @jResp, 'IntOf', @ParallelLoadThreads OUT, 'Endpoint.GcpMySQLSettings.ParallelLoadThreads'
    DECLARE @GcpMySQLSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @GcpMySQLSettingsPassword OUT, 'Endpoint.GcpMySQLSettings.Password'
    DECLARE @GcpMySQLSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @GcpMySQLSettingsPort OUT, 'Endpoint.GcpMySQLSettings.Port'
    DECLARE @GcpMySQLSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @GcpMySQLSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.GcpMySQLSettings.SecretsManagerAccessRoleArn'
    DECLARE @GcpMySQLSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @GcpMySQLSettingsSecretsManagerSecretId OUT, 'Endpoint.GcpMySQLSettings.SecretsManagerSecretId'
    DECLARE @GcpMySQLSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @GcpMySQLSettingsServerName OUT, 'Endpoint.GcpMySQLSettings.ServerName'
    DECLARE @ServerTimezone nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ServerTimezone OUT, 'Endpoint.GcpMySQLSettings.ServerTimezone'
    DECLARE @TargetDbType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @TargetDbType OUT, 'Endpoint.GcpMySQLSettings.TargetDbType'
    DECLARE @GcpMySQLSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @GcpMySQLSettingsUsername OUT, 'Endpoint.GcpMySQLSettings.Username'
    DECLARE @CurrentLsn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CurrentLsn OUT, 'Endpoint.IBMDb2Settings.CurrentLsn'
    DECLARE @IBMDb2SettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @IBMDb2SettingsDatabaseName OUT, 'Endpoint.IBMDb2Settings.DatabaseName'
    DECLARE @MaxKBytesPerRead int
    EXEC sp_OAMethod @jResp, 'IntOf', @MaxKBytesPerRead OUT, 'Endpoint.IBMDb2Settings.MaxKBytesPerRead'
    DECLARE @IBMDb2SettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @IBMDb2SettingsPassword OUT, 'Endpoint.IBMDb2Settings.Password'
    DECLARE @IBMDb2SettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @IBMDb2SettingsPort OUT, 'Endpoint.IBMDb2Settings.Port'
    DECLARE @IBMDb2SettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @IBMDb2SettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.IBMDb2Settings.SecretsManagerAccessRoleArn'
    DECLARE @IBMDb2SettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @IBMDb2SettingsSecretsManagerSecretId OUT, 'Endpoint.IBMDb2Settings.SecretsManagerSecretId'
    DECLARE @IBMDb2SettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @IBMDb2SettingsServerName OUT, 'Endpoint.IBMDb2Settings.ServerName'
    DECLARE @SetDataCaptureChanges int
    EXEC sp_OAMethod @jResp, 'IntOf', @SetDataCaptureChanges OUT, 'Endpoint.IBMDb2Settings.SetDataCaptureChanges'
    DECLARE @IBMDb2SettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @IBMDb2SettingsUsername OUT, 'Endpoint.IBMDb2Settings.Username'
    DECLARE @Broker nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @Broker OUT, 'Endpoint.KafkaSettings.Broker'
    DECLARE @IncludeControlDetails int
    EXEC sp_OAMethod @jResp, 'IntOf', @IncludeControlDetails OUT, 'Endpoint.KafkaSettings.IncludeControlDetails'
    DECLARE @IncludeNullAndEmpty int
    EXEC sp_OAMethod @jResp, 'IntOf', @IncludeNullAndEmpty OUT, 'Endpoint.KafkaSettings.IncludeNullAndEmpty'
    DECLARE @IncludePartitionValue int
    EXEC sp_OAMethod @jResp, 'IntOf', @IncludePartitionValue OUT, 'Endpoint.KafkaSettings.IncludePartitionValue'
    DECLARE @IncludeTableAlterOperations int
    EXEC sp_OAMethod @jResp, 'IntOf', @IncludeTableAlterOperations OUT, 'Endpoint.KafkaSettings.IncludeTableAlterOperations'
    DECLARE @IncludeTransactionDetails int
    EXEC sp_OAMethod @jResp, 'IntOf', @IncludeTransactionDetails OUT, 'Endpoint.KafkaSettings.IncludeTransactionDetails'
    DECLARE @MessageFormat nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MessageFormat OUT, 'Endpoint.KafkaSettings.MessageFormat'
    DECLARE @MessageMaxBytes int
    EXEC sp_OAMethod @jResp, 'IntOf', @MessageMaxBytes OUT, 'Endpoint.KafkaSettings.MessageMaxBytes'
    DECLARE @NoHexPrefix int
    EXEC sp_OAMethod @jResp, 'IntOf', @NoHexPrefix OUT, 'Endpoint.KafkaSettings.NoHexPrefix'
    DECLARE @PartitionIncludeSchemaTable int
    EXEC sp_OAMethod @jResp, 'IntOf', @PartitionIncludeSchemaTable OUT, 'Endpoint.KafkaSettings.PartitionIncludeSchemaTable'
    DECLARE @SaslPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SaslPassword OUT, 'Endpoint.KafkaSettings.SaslPassword'
    DECLARE @SaslUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SaslUsername OUT, 'Endpoint.KafkaSettings.SaslUsername'
    DECLARE @SecurityProtocol nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecurityProtocol OUT, 'Endpoint.KafkaSettings.SecurityProtocol'
    DECLARE @SslCaCertificateArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SslCaCertificateArn OUT, 'Endpoint.KafkaSettings.SslCaCertificateArn'
    DECLARE @SslClientCertificateArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SslClientCertificateArn OUT, 'Endpoint.KafkaSettings.SslClientCertificateArn'
    DECLARE @SslClientKeyArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SslClientKeyArn OUT, 'Endpoint.KafkaSettings.SslClientKeyArn'
    DECLARE @SslClientKeyPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SslClientKeyPassword OUT, 'Endpoint.KafkaSettings.SslClientKeyPassword'
    DECLARE @Topic nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @Topic OUT, 'Endpoint.KafkaSettings.Topic'
    DECLARE @KinesisSettingsIncludeControlDetails int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsIncludeControlDetails OUT, 'Endpoint.KinesisSettings.IncludeControlDetails'
    DECLARE @KinesisSettingsIncludeNullAndEmpty int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsIncludeNullAndEmpty OUT, 'Endpoint.KinesisSettings.IncludeNullAndEmpty'
    DECLARE @KinesisSettingsIncludePartitionValue int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsIncludePartitionValue OUT, 'Endpoint.KinesisSettings.IncludePartitionValue'
    DECLARE @KinesisSettingsIncludeTableAlterOperations int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsIncludeTableAlterOperations OUT, 'Endpoint.KinesisSettings.IncludeTableAlterOperations'
    DECLARE @KinesisSettingsIncludeTransactionDetails int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsIncludeTransactionDetails OUT, 'Endpoint.KinesisSettings.IncludeTransactionDetails'
    DECLARE @KinesisSettingsMessageFormat nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @KinesisSettingsMessageFormat OUT, 'Endpoint.KinesisSettings.MessageFormat'
    DECLARE @KinesisSettingsNoHexPrefix int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsNoHexPrefix OUT, 'Endpoint.KinesisSettings.NoHexPrefix'
    DECLARE @KinesisSettingsPartitionIncludeSchemaTable int
    EXEC sp_OAMethod @jResp, 'IntOf', @KinesisSettingsPartitionIncludeSchemaTable OUT, 'Endpoint.KinesisSettings.PartitionIncludeSchemaTable'
    DECLARE @KinesisSettingsServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @KinesisSettingsServiceAccessRoleArn OUT, 'Endpoint.KinesisSettings.ServiceAccessRoleArn'
    DECLARE @StreamArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @StreamArn OUT, 'Endpoint.KinesisSettings.StreamArn'
    DECLARE @EndpointKmsKeyId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointKmsKeyId OUT, 'Endpoint.KmsKeyId'
    DECLARE @BcpPacketSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @BcpPacketSize OUT, 'Endpoint.MicrosoftSQLServerSettings.BcpPacketSize'
    DECLARE @ControlTablesFileGroup nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ControlTablesFileGroup OUT, 'Endpoint.MicrosoftSQLServerSettings.ControlTablesFileGroup'
    DECLARE @MicrosoftSQLServerSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MicrosoftSQLServerSettingsDatabaseName OUT, 'Endpoint.MicrosoftSQLServerSettings.DatabaseName'
    DECLARE @MicrosoftSQLServerSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MicrosoftSQLServerSettingsPassword OUT, 'Endpoint.MicrosoftSQLServerSettings.Password'
    DECLARE @MicrosoftSQLServerSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @MicrosoftSQLServerSettingsPort OUT, 'Endpoint.MicrosoftSQLServerSettings.Port'
    DECLARE @QuerySingleAlwaysOnNode int
    EXEC sp_OAMethod @jResp, 'IntOf', @QuerySingleAlwaysOnNode OUT, 'Endpoint.MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode'
    DECLARE @ReadBackupOnly int
    EXEC sp_OAMethod @jResp, 'IntOf', @ReadBackupOnly OUT, 'Endpoint.MicrosoftSQLServerSettings.ReadBackupOnly'
    DECLARE @SafeguardPolicy nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SafeguardPolicy OUT, 'Endpoint.MicrosoftSQLServerSettings.SafeguardPolicy'
    DECLARE @MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn'
    DECLARE @MicrosoftSQLServerSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MicrosoftSQLServerSettingsSecretsManagerSecretId OUT, 'Endpoint.MicrosoftSQLServerSettings.SecretsManagerSecretId'
    DECLARE @MicrosoftSQLServerSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MicrosoftSQLServerSettingsServerName OUT, 'Endpoint.MicrosoftSQLServerSettings.ServerName'
    DECLARE @UseBcpFullLoad int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseBcpFullLoad OUT, 'Endpoint.MicrosoftSQLServerSettings.UseBcpFullLoad'
    DECLARE @MicrosoftSQLServerSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MicrosoftSQLServerSettingsUsername OUT, 'Endpoint.MicrosoftSQLServerSettings.Username'
    DECLARE @UseThirdPartyBackupDevice int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseThirdPartyBackupDevice OUT, 'Endpoint.MicrosoftSQLServerSettings.UseThirdPartyBackupDevice'
    DECLARE @AuthMechanism nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AuthMechanism OUT, 'Endpoint.MongoDbSettings.AuthMechanism'
    DECLARE @AuthSource nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AuthSource OUT, 'Endpoint.MongoDbSettings.AuthSource'
    DECLARE @AuthType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AuthType OUT, 'Endpoint.MongoDbSettings.AuthType'
    DECLARE @MongoDbSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsDatabaseName OUT, 'Endpoint.MongoDbSettings.DatabaseName'
    DECLARE @MongoDbSettingsDocsToInvestigate nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsDocsToInvestigate OUT, 'Endpoint.MongoDbSettings.DocsToInvestigate'
    DECLARE @MongoDbSettingsExtractDocId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsExtractDocId OUT, 'Endpoint.MongoDbSettings.ExtractDocId'
    DECLARE @MongoDbSettingsKmsKeyId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsKmsKeyId OUT, 'Endpoint.MongoDbSettings.KmsKeyId'
    DECLARE @MongoDbSettingsNestingLevel nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsNestingLevel OUT, 'Endpoint.MongoDbSettings.NestingLevel'
    DECLARE @MongoDbSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsPassword OUT, 'Endpoint.MongoDbSettings.Password'
    DECLARE @MongoDbSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @MongoDbSettingsPort OUT, 'Endpoint.MongoDbSettings.Port'
    DECLARE @MongoDbSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.MongoDbSettings.SecretsManagerAccessRoleArn'
    DECLARE @MongoDbSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsSecretsManagerSecretId OUT, 'Endpoint.MongoDbSettings.SecretsManagerSecretId'
    DECLARE @MongoDbSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsServerName OUT, 'Endpoint.MongoDbSettings.ServerName'
    DECLARE @MongoDbSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MongoDbSettingsUsername OUT, 'Endpoint.MongoDbSettings.Username'
    DECLARE @MySQLSettingsAfterConnectScript nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsAfterConnectScript OUT, 'Endpoint.MySQLSettings.AfterConnectScript'
    DECLARE @MySQLSettingsCleanSourceMetadataOnMismatch int
    EXEC sp_OAMethod @jResp, 'IntOf', @MySQLSettingsCleanSourceMetadataOnMismatch OUT, 'Endpoint.MySQLSettings.CleanSourceMetadataOnMismatch'
    DECLARE @MySQLSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsDatabaseName OUT, 'Endpoint.MySQLSettings.DatabaseName'
    DECLARE @MySQLSettingsEventsPollInterval int
    EXEC sp_OAMethod @jResp, 'IntOf', @MySQLSettingsEventsPollInterval OUT, 'Endpoint.MySQLSettings.EventsPollInterval'
    DECLARE @MySQLSettingsMaxFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @MySQLSettingsMaxFileSize OUT, 'Endpoint.MySQLSettings.MaxFileSize'
    DECLARE @MySQLSettingsParallelLoadThreads int
    EXEC sp_OAMethod @jResp, 'IntOf', @MySQLSettingsParallelLoadThreads OUT, 'Endpoint.MySQLSettings.ParallelLoadThreads'
    DECLARE @MySQLSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsPassword OUT, 'Endpoint.MySQLSettings.Password'
    DECLARE @MySQLSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @MySQLSettingsPort OUT, 'Endpoint.MySQLSettings.Port'
    DECLARE @MySQLSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.MySQLSettings.SecretsManagerAccessRoleArn'
    DECLARE @MySQLSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsSecretsManagerSecretId OUT, 'Endpoint.MySQLSettings.SecretsManagerSecretId'
    DECLARE @MySQLSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsServerName OUT, 'Endpoint.MySQLSettings.ServerName'
    DECLARE @MySQLSettingsServerTimezone nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsServerTimezone OUT, 'Endpoint.MySQLSettings.ServerTimezone'
    DECLARE @MySQLSettingsTargetDbType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsTargetDbType OUT, 'Endpoint.MySQLSettings.TargetDbType'
    DECLARE @MySQLSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySQLSettingsUsername OUT, 'Endpoint.MySQLSettings.Username'
    DECLARE @NeptuneSettingsErrorRetryDuration int
    EXEC sp_OAMethod @jResp, 'IntOf', @NeptuneSettingsErrorRetryDuration OUT, 'Endpoint.NeptuneSettings.ErrorRetryDuration'
    DECLARE @IamAuthEnabled int
    EXEC sp_OAMethod @jResp, 'IntOf', @IamAuthEnabled OUT, 'Endpoint.NeptuneSettings.IamAuthEnabled'
    DECLARE @NeptuneSettingsMaxFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @NeptuneSettingsMaxFileSize OUT, 'Endpoint.NeptuneSettings.MaxFileSize'
    DECLARE @MaxRetryCount int
    EXEC sp_OAMethod @jResp, 'IntOf', @MaxRetryCount OUT, 'Endpoint.NeptuneSettings.MaxRetryCount'
    DECLARE @S3BucketFolder nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3BucketFolder OUT, 'Endpoint.NeptuneSettings.S3BucketFolder'
    DECLARE @S3BucketName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3BucketName OUT, 'Endpoint.NeptuneSettings.S3BucketName'
    DECLARE @NeptuneSettingsServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @NeptuneSettingsServiceAccessRoleArn OUT, 'Endpoint.NeptuneSettings.ServiceAccessRoleArn'
    DECLARE @AccessAlternateDirectly int
    EXEC sp_OAMethod @jResp, 'IntOf', @AccessAlternateDirectly OUT, 'Endpoint.OracleSettings.AccessAlternateDirectly'
    DECLARE @AdditionalArchivedLogDestId int
    EXEC sp_OAMethod @jResp, 'IntOf', @AdditionalArchivedLogDestId OUT, 'Endpoint.OracleSettings.AdditionalArchivedLogDestId'
    DECLARE @AddSupplementalLogging int
    EXEC sp_OAMethod @jResp, 'IntOf', @AddSupplementalLogging OUT, 'Endpoint.OracleSettings.AddSupplementalLogging'
    DECLARE @AllowSelectNestedTables int
    EXEC sp_OAMethod @jResp, 'IntOf', @AllowSelectNestedTables OUT, 'Endpoint.OracleSettings.AllowSelectNestedTables'
    DECLARE @ArchivedLogDestId int
    EXEC sp_OAMethod @jResp, 'IntOf', @ArchivedLogDestId OUT, 'Endpoint.OracleSettings.ArchivedLogDestId'
    DECLARE @ArchivedLogsOnly int
    EXEC sp_OAMethod @jResp, 'IntOf', @ArchivedLogsOnly OUT, 'Endpoint.OracleSettings.ArchivedLogsOnly'
    DECLARE @AsmPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AsmPassword OUT, 'Endpoint.OracleSettings.AsmPassword'
    DECLARE @AsmServer nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AsmServer OUT, 'Endpoint.OracleSettings.AsmServer'
    DECLARE @AsmUser nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AsmUser OUT, 'Endpoint.OracleSettings.AsmUser'
    DECLARE @CharLengthSemantics nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CharLengthSemantics OUT, 'Endpoint.OracleSettings.CharLengthSemantics'
    DECLARE @OracleSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OracleSettingsDatabaseName OUT, 'Endpoint.OracleSettings.DatabaseName'
    DECLARE @DirectPathNoLog int
    EXEC sp_OAMethod @jResp, 'IntOf', @DirectPathNoLog OUT, 'Endpoint.OracleSettings.DirectPathNoLog'
    DECLARE @DirectPathParallelLoad int
    EXEC sp_OAMethod @jResp, 'IntOf', @DirectPathParallelLoad OUT, 'Endpoint.OracleSettings.DirectPathParallelLoad'
    DECLARE @EnableHomogenousTablespace int
    EXEC sp_OAMethod @jResp, 'IntOf', @EnableHomogenousTablespace OUT, 'Endpoint.OracleSettings.EnableHomogenousTablespace'
    DECLARE @FailTasksOnLobTruncation int
    EXEC sp_OAMethod @jResp, 'IntOf', @FailTasksOnLobTruncation OUT, 'Endpoint.OracleSettings.FailTasksOnLobTruncation'
    DECLARE @NumberDatatypeScale int
    EXEC sp_OAMethod @jResp, 'IntOf', @NumberDatatypeScale OUT, 'Endpoint.OracleSettings.NumberDatatypeScale'
    DECLARE @OraclePathPrefix nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OraclePathPrefix OUT, 'Endpoint.OracleSettings.OraclePathPrefix'
    DECLARE @ParallelAsmReadThreads int
    EXEC sp_OAMethod @jResp, 'IntOf', @ParallelAsmReadThreads OUT, 'Endpoint.OracleSettings.ParallelAsmReadThreads'
    DECLARE @OracleSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OracleSettingsPassword OUT, 'Endpoint.OracleSettings.Password'
    DECLARE @OracleSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @OracleSettingsPort OUT, 'Endpoint.OracleSettings.Port'
    DECLARE @ReadAheadBlocks int
    EXEC sp_OAMethod @jResp, 'IntOf', @ReadAheadBlocks OUT, 'Endpoint.OracleSettings.ReadAheadBlocks'
    DECLARE @ReadTableSpaceName int
    EXEC sp_OAMethod @jResp, 'IntOf', @ReadTableSpaceName OUT, 'Endpoint.OracleSettings.ReadTableSpaceName'
    DECLARE @ReplacePathPrefix int
    EXEC sp_OAMethod @jResp, 'IntOf', @ReplacePathPrefix OUT, 'Endpoint.OracleSettings.ReplacePathPrefix'
    DECLARE @RetryInterval int
    EXEC sp_OAMethod @jResp, 'IntOf', @RetryInterval OUT, 'Endpoint.OracleSettings.RetryInterval'
    DECLARE @OracleSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OracleSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.OracleSettings.SecretsManagerAccessRoleArn'
    DECLARE @SecretsManagerOracleAsmAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecretsManagerOracleAsmAccessRoleArn OUT, 'Endpoint.OracleSettings.SecretsManagerOracleAsmAccessRoleArn'
    DECLARE @SecretsManagerOracleAsmSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecretsManagerOracleAsmSecretId OUT, 'Endpoint.OracleSettings.SecretsManagerOracleAsmSecretId'
    DECLARE @OracleSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OracleSettingsSecretsManagerSecretId OUT, 'Endpoint.OracleSettings.SecretsManagerSecretId'
    DECLARE @SecurityDbEncryption nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecurityDbEncryption OUT, 'Endpoint.OracleSettings.SecurityDbEncryption'
    DECLARE @SecurityDbEncryptionName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SecurityDbEncryptionName OUT, 'Endpoint.OracleSettings.SecurityDbEncryptionName'
    DECLARE @OracleSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OracleSettingsServerName OUT, 'Endpoint.OracleSettings.ServerName'
    DECLARE @SpatialDataOptionToGeoJsonFunctionName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SpatialDataOptionToGeoJsonFunctionName OUT, 'Endpoint.OracleSettings.SpatialDataOptionToGeoJsonFunctionName'
    DECLARE @StandbyDelayTime int
    EXEC sp_OAMethod @jResp, 'IntOf', @StandbyDelayTime OUT, 'Endpoint.OracleSettings.StandbyDelayTime'
    DECLARE @UseAlternateFolderForOnline int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseAlternateFolderForOnline OUT, 'Endpoint.OracleSettings.UseAlternateFolderForOnline'
    DECLARE @UseBFile int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseBFile OUT, 'Endpoint.OracleSettings.UseBFile'
    DECLARE @UseDirectPathFullLoad int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseDirectPathFullLoad OUT, 'Endpoint.OracleSettings.UseDirectPathFullLoad'
    DECLARE @UseLogminerReader int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseLogminerReader OUT, 'Endpoint.OracleSettings.UseLogminerReader'
    DECLARE @UsePathPrefix nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @UsePathPrefix OUT, 'Endpoint.OracleSettings.UsePathPrefix'
    DECLARE @OracleSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @OracleSettingsUsername OUT, 'Endpoint.OracleSettings.Username'
    DECLARE @EndpointPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @EndpointPort OUT, 'Endpoint.Port'
    DECLARE @PostgreSQLSettingsAfterConnectScript nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsAfterConnectScript OUT, 'Endpoint.PostgreSQLSettings.AfterConnectScript'
    DECLARE @CaptureDdls int
    EXEC sp_OAMethod @jResp, 'IntOf', @CaptureDdls OUT, 'Endpoint.PostgreSQLSettings.CaptureDdls'
    DECLARE @PostgreSQLSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsDatabaseName OUT, 'Endpoint.PostgreSQLSettings.DatabaseName'
    DECLARE @DdlArtifactsSchema nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DdlArtifactsSchema OUT, 'Endpoint.PostgreSQLSettings.DdlArtifactsSchema'
    DECLARE @ExecuteTimeout int
    EXEC sp_OAMethod @jResp, 'IntOf', @ExecuteTimeout OUT, 'Endpoint.PostgreSQLSettings.ExecuteTimeout'
    DECLARE @PostgreSQLSettingsFailTasksOnLobTruncation int
    EXEC sp_OAMethod @jResp, 'IntOf', @PostgreSQLSettingsFailTasksOnLobTruncation OUT, 'Endpoint.PostgreSQLSettings.FailTasksOnLobTruncation'
    DECLARE @HeartbeatEnable int
    EXEC sp_OAMethod @jResp, 'IntOf', @HeartbeatEnable OUT, 'Endpoint.PostgreSQLSettings.HeartbeatEnable'
    DECLARE @HeartbeatFrequency int
    EXEC sp_OAMethod @jResp, 'IntOf', @HeartbeatFrequency OUT, 'Endpoint.PostgreSQLSettings.HeartbeatFrequency'
    DECLARE @HeartbeatSchema nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @HeartbeatSchema OUT, 'Endpoint.PostgreSQLSettings.HeartbeatSchema'
    DECLARE @PostgreSQLSettingsMaxFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @PostgreSQLSettingsMaxFileSize OUT, 'Endpoint.PostgreSQLSettings.MaxFileSize'
    DECLARE @PostgreSQLSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsPassword OUT, 'Endpoint.PostgreSQLSettings.Password'
    DECLARE @PluginName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PluginName OUT, 'Endpoint.PostgreSQLSettings.PluginName'
    DECLARE @PostgreSQLSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @PostgreSQLSettingsPort OUT, 'Endpoint.PostgreSQLSettings.Port'
    DECLARE @PostgreSQLSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.PostgreSQLSettings.SecretsManagerAccessRoleArn'
    DECLARE @PostgreSQLSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsSecretsManagerSecretId OUT, 'Endpoint.PostgreSQLSettings.SecretsManagerSecretId'
    DECLARE @PostgreSQLSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsServerName OUT, 'Endpoint.PostgreSQLSettings.ServerName'
    DECLARE @SlotName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SlotName OUT, 'Endpoint.PostgreSQLSettings.SlotName'
    DECLARE @PostgreSQLSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @PostgreSQLSettingsUsername OUT, 'Endpoint.PostgreSQLSettings.Username'
    DECLARE @AuthPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AuthPassword OUT, 'Endpoint.RedisSettings.AuthPassword'
    DECLARE @RedisSettingsAuthType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedisSettingsAuthType OUT, 'Endpoint.RedisSettings.AuthType'
    DECLARE @AuthUserName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @AuthUserName OUT, 'Endpoint.RedisSettings.AuthUserName'
    DECLARE @RedisSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @RedisSettingsPort OUT, 'Endpoint.RedisSettings.Port'
    DECLARE @RedisSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedisSettingsServerName OUT, 'Endpoint.RedisSettings.ServerName'
    DECLARE @RedisSettingsSslCaCertificateArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedisSettingsSslCaCertificateArn OUT, 'Endpoint.RedisSettings.SslCaCertificateArn'
    DECLARE @SslSecurityProtocol nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SslSecurityProtocol OUT, 'Endpoint.RedisSettings.SslSecurityProtocol'
    DECLARE @AcceptAnyDate int
    EXEC sp_OAMethod @jResp, 'IntOf', @AcceptAnyDate OUT, 'Endpoint.RedshiftSettings.AcceptAnyDate'
    DECLARE @RedshiftSettingsAfterConnectScript nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsAfterConnectScript OUT, 'Endpoint.RedshiftSettings.AfterConnectScript'
    DECLARE @BucketFolder nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @BucketFolder OUT, 'Endpoint.RedshiftSettings.BucketFolder'
    DECLARE @RedshiftSettingsBucketName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsBucketName OUT, 'Endpoint.RedshiftSettings.BucketName'
    DECLARE @CaseSensitiveNames int
    EXEC sp_OAMethod @jResp, 'IntOf', @CaseSensitiveNames OUT, 'Endpoint.RedshiftSettings.CaseSensitiveNames'
    DECLARE @CompUpdate int
    EXEC sp_OAMethod @jResp, 'IntOf', @CompUpdate OUT, 'Endpoint.RedshiftSettings.CompUpdate'
    DECLARE @ConnectionTimeout int
    EXEC sp_OAMethod @jResp, 'IntOf', @ConnectionTimeout OUT, 'Endpoint.RedshiftSettings.ConnectionTimeout'
    DECLARE @RedshiftSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsDatabaseName OUT, 'Endpoint.RedshiftSettings.DatabaseName'
    DECLARE @DateFormat nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DateFormat OUT, 'Endpoint.RedshiftSettings.DateFormat'
    DECLARE @EmptyAsNull int
    EXEC sp_OAMethod @jResp, 'IntOf', @EmptyAsNull OUT, 'Endpoint.RedshiftSettings.EmptyAsNull'
    DECLARE @EncryptionMode nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionMode OUT, 'Endpoint.RedshiftSettings.EncryptionMode'
    DECLARE @ExplicitIds int
    EXEC sp_OAMethod @jResp, 'IntOf', @ExplicitIds OUT, 'Endpoint.RedshiftSettings.ExplicitIds'
    DECLARE @FileTransferUploadStreams int
    EXEC sp_OAMethod @jResp, 'IntOf', @FileTransferUploadStreams OUT, 'Endpoint.RedshiftSettings.FileTransferUploadStreams'
    DECLARE @LoadTimeout int
    EXEC sp_OAMethod @jResp, 'IntOf', @LoadTimeout OUT, 'Endpoint.RedshiftSettings.LoadTimeout'
    DECLARE @RedshiftSettingsMaxFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @RedshiftSettingsMaxFileSize OUT, 'Endpoint.RedshiftSettings.MaxFileSize'
    DECLARE @RedshiftSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsPassword OUT, 'Endpoint.RedshiftSettings.Password'
    DECLARE @RedshiftSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @RedshiftSettingsPort OUT, 'Endpoint.RedshiftSettings.Port'
    DECLARE @RemoveQuotes int
    EXEC sp_OAMethod @jResp, 'IntOf', @RemoveQuotes OUT, 'Endpoint.RedshiftSettings.RemoveQuotes'
    DECLARE @ReplaceChars nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ReplaceChars OUT, 'Endpoint.RedshiftSettings.ReplaceChars'
    DECLARE @ReplaceInvalidChars nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ReplaceInvalidChars OUT, 'Endpoint.RedshiftSettings.ReplaceInvalidChars'
    DECLARE @RedshiftSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.RedshiftSettings.SecretsManagerAccessRoleArn'
    DECLARE @RedshiftSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsSecretsManagerSecretId OUT, 'Endpoint.RedshiftSettings.SecretsManagerSecretId'
    DECLARE @RedshiftSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsServerName OUT, 'Endpoint.RedshiftSettings.ServerName'
    DECLARE @ServerSideEncryptionKmsKeyId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ServerSideEncryptionKmsKeyId OUT, 'Endpoint.RedshiftSettings.ServerSideEncryptionKmsKeyId'
    DECLARE @RedshiftSettingsServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsServiceAccessRoleArn OUT, 'Endpoint.RedshiftSettings.ServiceAccessRoleArn'
    DECLARE @TimeFormat nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @TimeFormat OUT, 'Endpoint.RedshiftSettings.TimeFormat'
    DECLARE @TrimBlanks int
    EXEC sp_OAMethod @jResp, 'IntOf', @TrimBlanks OUT, 'Endpoint.RedshiftSettings.TrimBlanks'
    DECLARE @TruncateColumns int
    EXEC sp_OAMethod @jResp, 'IntOf', @TruncateColumns OUT, 'Endpoint.RedshiftSettings.TruncateColumns'
    DECLARE @RedshiftSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftSettingsUsername OUT, 'Endpoint.RedshiftSettings.Username'
    DECLARE @WriteBufferSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @WriteBufferSize OUT, 'Endpoint.RedshiftSettings.WriteBufferSize'
    DECLARE @AddColumnName int
    EXEC sp_OAMethod @jResp, 'IntOf', @AddColumnName OUT, 'Endpoint.S3Settings.AddColumnName'
    DECLARE @S3SettingsBucketFolder nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3SettingsBucketFolder OUT, 'Endpoint.S3Settings.BucketFolder'
    DECLARE @S3SettingsBucketName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3SettingsBucketName OUT, 'Endpoint.S3Settings.BucketName'
    DECLARE @CannedAclForObjects nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CannedAclForObjects OUT, 'Endpoint.S3Settings.CannedAclForObjects'
    DECLARE @CdcInsertsAndUpdates int
    EXEC sp_OAMethod @jResp, 'IntOf', @CdcInsertsAndUpdates OUT, 'Endpoint.S3Settings.CdcInsertsAndUpdates'
    DECLARE @CdcInsertsOnly int
    EXEC sp_OAMethod @jResp, 'IntOf', @CdcInsertsOnly OUT, 'Endpoint.S3Settings.CdcInsertsOnly'
    DECLARE @CdcMaxBatchInterval int
    EXEC sp_OAMethod @jResp, 'IntOf', @CdcMaxBatchInterval OUT, 'Endpoint.S3Settings.CdcMaxBatchInterval'
    DECLARE @CdcMinFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @CdcMinFileSize OUT, 'Endpoint.S3Settings.CdcMinFileSize'
    DECLARE @CdcPath nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CdcPath OUT, 'Endpoint.S3Settings.CdcPath'
    DECLARE @CompressionType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CompressionType OUT, 'Endpoint.S3Settings.CompressionType'
    DECLARE @CsvDelimiter nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CsvDelimiter OUT, 'Endpoint.S3Settings.CsvDelimiter'
    DECLARE @CsvNoSupValue nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CsvNoSupValue OUT, 'Endpoint.S3Settings.CsvNoSupValue'
    DECLARE @CsvNullValue nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CsvNullValue OUT, 'Endpoint.S3Settings.CsvNullValue'
    DECLARE @CsvRowDelimiter nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @CsvRowDelimiter OUT, 'Endpoint.S3Settings.CsvRowDelimiter'
    DECLARE @DataFormat nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DataFormat OUT, 'Endpoint.S3Settings.DataFormat'
    DECLARE @DataPageSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @DataPageSize OUT, 'Endpoint.S3Settings.DataPageSize'
    DECLARE @DatePartitionDelimiter nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DatePartitionDelimiter OUT, 'Endpoint.S3Settings.DatePartitionDelimiter'
    DECLARE @DatePartitionEnabled int
    EXEC sp_OAMethod @jResp, 'IntOf', @DatePartitionEnabled OUT, 'Endpoint.S3Settings.DatePartitionEnabled'
    DECLARE @DatePartitionSequence nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DatePartitionSequence OUT, 'Endpoint.S3Settings.DatePartitionSequence'
    DECLARE @DatePartitionTimezone nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @DatePartitionTimezone OUT, 'Endpoint.S3Settings.DatePartitionTimezone'
    DECLARE @DictPageSizeLimit int
    EXEC sp_OAMethod @jResp, 'IntOf', @DictPageSizeLimit OUT, 'Endpoint.S3Settings.DictPageSizeLimit'
    DECLARE @EnableStatistics int
    EXEC sp_OAMethod @jResp, 'IntOf', @EnableStatistics OUT, 'Endpoint.S3Settings.EnableStatistics'
    DECLARE @EncodingType nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EncodingType OUT, 'Endpoint.S3Settings.EncodingType'
    DECLARE @S3SettingsEncryptionMode nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3SettingsEncryptionMode OUT, 'Endpoint.S3Settings.EncryptionMode'
    DECLARE @S3SettingsExternalTableDefinition nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3SettingsExternalTableDefinition OUT, 'Endpoint.S3Settings.ExternalTableDefinition'
    DECLARE @IgnoreHeaderRows int
    EXEC sp_OAMethod @jResp, 'IntOf', @IgnoreHeaderRows OUT, 'Endpoint.S3Settings.IgnoreHeaderRows'
    DECLARE @IncludeOpForFullLoad int
    EXEC sp_OAMethod @jResp, 'IntOf', @IncludeOpForFullLoad OUT, 'Endpoint.S3Settings.IncludeOpForFullLoad'
    DECLARE @S3SettingsMaxFileSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @S3SettingsMaxFileSize OUT, 'Endpoint.S3Settings.MaxFileSize'
    DECLARE @ParquetTimestampInMillisecond int
    EXEC sp_OAMethod @jResp, 'IntOf', @ParquetTimestampInMillisecond OUT, 'Endpoint.S3Settings.ParquetTimestampInMillisecond'
    DECLARE @ParquetVersion nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @ParquetVersion OUT, 'Endpoint.S3Settings.ParquetVersion'
    DECLARE @PreserveTransactions int
    EXEC sp_OAMethod @jResp, 'IntOf', @PreserveTransactions OUT, 'Endpoint.S3Settings.PreserveTransactions'
    DECLARE @Rfc4180 int
    EXEC sp_OAMethod @jResp, 'IntOf', @Rfc4180 OUT, 'Endpoint.S3Settings.Rfc4180'
    DECLARE @RowGroupLength int
    EXEC sp_OAMethod @jResp, 'IntOf', @RowGroupLength OUT, 'Endpoint.S3Settings.RowGroupLength'
    DECLARE @S3SettingsServerSideEncryptionKmsKeyId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3SettingsServerSideEncryptionKmsKeyId OUT, 'Endpoint.S3Settings.ServerSideEncryptionKmsKeyId'
    DECLARE @S3SettingsServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @S3SettingsServiceAccessRoleArn OUT, 'Endpoint.S3Settings.ServiceAccessRoleArn'
    DECLARE @TimestampColumnName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @TimestampColumnName OUT, 'Endpoint.S3Settings.TimestampColumnName'
    DECLARE @UseCsvNoSupValue int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseCsvNoSupValue OUT, 'Endpoint.S3Settings.UseCsvNoSupValue'
    DECLARE @UseTaskStartTimeForFullLoadTimestamp int
    EXEC sp_OAMethod @jResp, 'IntOf', @UseTaskStartTimeForFullLoadTimestamp OUT, 'Endpoint.S3Settings.UseTaskStartTimeForFullLoadTimestamp'
    DECLARE @EndpointServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointServerName OUT, 'Endpoint.ServerName'
    DECLARE @EndpointServiceAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointServiceAccessRoleArn OUT, 'Endpoint.ServiceAccessRoleArn'
    DECLARE @SslMode nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SslMode OUT, 'Endpoint.SslMode'
    DECLARE @Status nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'Endpoint.Status'
    DECLARE @SybaseSettingsDatabaseName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SybaseSettingsDatabaseName OUT, 'Endpoint.SybaseSettings.DatabaseName'
    DECLARE @SybaseSettingsPassword nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SybaseSettingsPassword OUT, 'Endpoint.SybaseSettings.Password'
    DECLARE @SybaseSettingsPort int
    EXEC sp_OAMethod @jResp, 'IntOf', @SybaseSettingsPort OUT, 'Endpoint.SybaseSettings.Port'
    DECLARE @SybaseSettingsSecretsManagerAccessRoleArn nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SybaseSettingsSecretsManagerAccessRoleArn OUT, 'Endpoint.SybaseSettings.SecretsManagerAccessRoleArn'
    DECLARE @SybaseSettingsSecretsManagerSecretId nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SybaseSettingsSecretsManagerSecretId OUT, 'Endpoint.SybaseSettings.SecretsManagerSecretId'
    DECLARE @SybaseSettingsServerName nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SybaseSettingsServerName OUT, 'Endpoint.SybaseSettings.ServerName'
    DECLARE @SybaseSettingsUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @SybaseSettingsUsername OUT, 'Endpoint.SybaseSettings.Username'
    DECLARE @EndpointUsername nvarchar(max)
    EXEC sp_OAMethod @jResp, 'StringOf', @EndpointUsername OUT, 'Endpoint.Username'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'Endpoint.OracleSettings.ExtraArchivedLogDestIds'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'Endpoint.OracleSettings.ExtraArchivedLogDestIds[i]'
        SELECT @i = @i + 1
      END

    -- A sample JSON response body parsed by the above code:

    -- {
    --   "Endpoint": {
    --     "CertificateArn": "string",
    --     "DatabaseName": "string",
    --     "DmsTransferSettings": {
    --       "BucketName": "string",
    --       "ServiceAccessRoleArn": "string"
    --     },
    --     "DocDbSettings": {
    --       "DatabaseName": "string",
    --       "DocsToInvestigate": number,
    --       "ExtractDocId": boolean,
    --       "KmsKeyId": "string",
    --       "NestingLevel": "string",
    --       "Password": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "Username": "string"
    --     },
    --     "DynamoDbSettings": {
    --       "ServiceAccessRoleArn": "string"
    --     },
    --     "ElasticsearchSettings": {
    --       "EndpointUri": "string",
    --       "ErrorRetryDuration": number,
    --       "FullLoadErrorPercentage": number,
    --       "ServiceAccessRoleArn": "string"
    --     },
    --     "EndpointArn": "string",
    --     "EndpointIdentifier": "string",
    --     "EndpointType": "string",
    --     "EngineDisplayName": "string",
    --     "EngineName": "string",
    --     "ExternalId": "string",
    --     "ExternalTableDefinition": "string",
    --     "ExtraConnectionAttributes": "string",
    --     "GcpMySQLSettings": {
    --       "AfterConnectScript": "string",
    --       "CleanSourceMetadataOnMismatch": boolean,
    --       "DatabaseName": "string",
    --       "EventsPollInterval": number,
    --       "MaxFileSize": number,
    --       "ParallelLoadThreads": number,
    --       "Password": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "ServerTimezone": "string",
    --       "TargetDbType": "string",
    --       "Username": "string"
    --     },
    --     "IBMDb2Settings": {
    --       "CurrentLsn": "string",
    --       "DatabaseName": "string",
    --       "MaxKBytesPerRead": number,
    --       "Password": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "SetDataCaptureChanges": boolean,
    --       "Username": "string"
    --     },
    --     "KafkaSettings": {
    --       "Broker": "string",
    --       "IncludeControlDetails": boolean,
    --       "IncludeNullAndEmpty": boolean,
    --       "IncludePartitionValue": boolean,
    --       "IncludeTableAlterOperations": boolean,
    --       "IncludeTransactionDetails": boolean,
    --       "MessageFormat": "string",
    --       "MessageMaxBytes": number,
    --       "NoHexPrefix": boolean,
    --       "PartitionIncludeSchemaTable": boolean,
    --       "SaslPassword": "string",
    --       "SaslUsername": "string",
    --       "SecurityProtocol": "string",
    --       "SslCaCertificateArn": "string",
    --       "SslClientCertificateArn": "string",
    --       "SslClientKeyArn": "string",
    --       "SslClientKeyPassword": "string",
    --       "Topic": "string"
    --     },
    --     "KinesisSettings": {
    --       "IncludeControlDetails": boolean,
    --       "IncludeNullAndEmpty": boolean,
    --       "IncludePartitionValue": boolean,
    --       "IncludeTableAlterOperations": boolean,
    --       "IncludeTransactionDetails": boolean,
    --       "MessageFormat": "string",
    --       "NoHexPrefix": boolean,
    --       "PartitionIncludeSchemaTable": boolean,
    --       "ServiceAccessRoleArn": "string",
    --       "StreamArn": "string"
    --     },
    --     "KmsKeyId": "string",
    --     "MicrosoftSQLServerSettings": {
    --       "BcpPacketSize": number,
    --       "ControlTablesFileGroup": "string",
    --       "DatabaseName": "string",
    --       "Password": "string",
    --       "Port": number,
    --       "QuerySingleAlwaysOnNode": boolean,
    --       "ReadBackupOnly": boolean,
    --       "SafeguardPolicy": "string",
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "UseBcpFullLoad": boolean,
    --       "Username": "string",
    --       "UseThirdPartyBackupDevice": boolean
    --     },
    --     "MongoDbSettings": {
    --       "AuthMechanism": "string",
    --       "AuthSource": "string",
    --       "AuthType": "string",
    --       "DatabaseName": "string",
    --       "DocsToInvestigate": "string",
    --       "ExtractDocId": "string",
    --       "KmsKeyId": "string",
    --       "NestingLevel": "string",
    --       "Password": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "Username": "string"
    --     },
    --     "MySQLSettings": {
    --       "AfterConnectScript": "string",
    --       "CleanSourceMetadataOnMismatch": boolean,
    --       "DatabaseName": "string",
    --       "EventsPollInterval": number,
    --       "MaxFileSize": number,
    --       "ParallelLoadThreads": number,
    --       "Password": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "ServerTimezone": "string",
    --       "TargetDbType": "string",
    --       "Username": "string"
    --     },
    --     "NeptuneSettings": {
    --       "ErrorRetryDuration": number,
    --       "IamAuthEnabled": boolean,
    --       "MaxFileSize": number,
    --       "MaxRetryCount": number,
    --       "S3BucketFolder": "string",
    --       "S3BucketName": "string",
    --       "ServiceAccessRoleArn": "string"
    --     },
    --     "OracleSettings": {
    --       "AccessAlternateDirectly": boolean,
    --       "AdditionalArchivedLogDestId": number,
    --       "AddSupplementalLogging": boolean,
    --       "AllowSelectNestedTables": boolean,
    --       "ArchivedLogDestId": number,
    --       "ArchivedLogsOnly": boolean,
    --       "AsmPassword": "string",
    --       "AsmServer": "string",
    --       "AsmUser": "string",
    --       "CharLengthSemantics": "string",
    --       "DatabaseName": "string",
    --       "DirectPathNoLog": boolean,
    --       "DirectPathParallelLoad": boolean,
    --       "EnableHomogenousTablespace": boolean,
    --       "ExtraArchivedLogDestIds": [
    --         number
    --       ],
    --       "FailTasksOnLobTruncation": boolean,
    --       "NumberDatatypeScale": number,
    --       "OraclePathPrefix": "string",
    --       "ParallelAsmReadThreads": number,
    --       "Password": "string",
    --       "Port": number,
    --       "ReadAheadBlocks": number,
    --       "ReadTableSpaceName": boolean,
    --       "ReplacePathPrefix": boolean,
    --       "RetryInterval": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerOracleAsmAccessRoleArn": "string",
    --       "SecretsManagerOracleAsmSecretId": "string",
    --       "SecretsManagerSecretId": "string",
    --       "SecurityDbEncryption": "string",
    --       "SecurityDbEncryptionName": "string",
    --       "ServerName": "string",
    --       "SpatialDataOptionToGeoJsonFunctionName": "string",
    --       "StandbyDelayTime": number,
    --       "UseAlternateFolderForOnline": boolean,
    --       "UseBFile": boolean,
    --       "UseDirectPathFullLoad": boolean,
    --       "UseLogminerReader": boolean,
    --       "UsePathPrefix": "string",
    --       "Username": "string"
    --     },
    --     "Port": number,
    --     "PostgreSQLSettings": {
    --       "AfterConnectScript": "string",
    --       "CaptureDdls": boolean,
    --       "DatabaseName": "string",
    --       "DdlArtifactsSchema": "string",
    --       "ExecuteTimeout": number,
    --       "FailTasksOnLobTruncation": boolean,
    --       "HeartbeatEnable": boolean,
    --       "HeartbeatFrequency": number,
    --       "HeartbeatSchema": "string",
    --       "MaxFileSize": number,
    --       "Password": "string",
    --       "PluginName": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "SlotName": "string",
    --       "Username": "string"
    --     },
    --     "RedisSettings": {
    --       "AuthPassword": "string",
    --       "AuthType": "string",
    --       "AuthUserName": "string",
    --       "Port": number,
    --       "ServerName": "string",
    --       "SslCaCertificateArn": "string",
    --       "SslSecurityProtocol": "string"
    --     },
    --     "RedshiftSettings": {
    --       "AcceptAnyDate": boolean,
    --       "AfterConnectScript": "string",
    --       "BucketFolder": "string",
    --       "BucketName": "string",
    --       "CaseSensitiveNames": boolean,
    --       "CompUpdate": boolean,
    --       "ConnectionTimeout": number,
    --       "DatabaseName": "string",
    --       "DateFormat": "string",
    --       "EmptyAsNull": boolean,
    --       "EncryptionMode": "string",
    --       "ExplicitIds": boolean,
    --       "FileTransferUploadStreams": number,
    --       "LoadTimeout": number,
    --       "MaxFileSize": number,
    --       "Password": "string",
    --       "Port": number,
    --       "RemoveQuotes": boolean,
    --       "ReplaceChars": "string",
    --       "ReplaceInvalidChars": "string",
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "ServerSideEncryptionKmsKeyId": "string",
    --       "ServiceAccessRoleArn": "string",
    --       "TimeFormat": "string",
    --       "TrimBlanks": boolean,
    --       "TruncateColumns": boolean,
    --       "Username": "string",
    --       "WriteBufferSize": number
    --     },
    --     "S3Settings": {
    --       "AddColumnName": boolean,
    --       "BucketFolder": "string",
    --       "BucketName": "string",
    --       "CannedAclForObjects": "string",
    --       "CdcInsertsAndUpdates": boolean,
    --       "CdcInsertsOnly": boolean,
    --       "CdcMaxBatchInterval": number,
    --       "CdcMinFileSize": number,
    --       "CdcPath": "string",
    --       "CompressionType": "string",
    --       "CsvDelimiter": "string",
    --       "CsvNoSupValue": "string",
    --       "CsvNullValue": "string",
    --       "CsvRowDelimiter": "string",
    --       "DataFormat": "string",
    --       "DataPageSize": number,
    --       "DatePartitionDelimiter": "string",
    --       "DatePartitionEnabled": boolean,
    --       "DatePartitionSequence": "string",
    --       "DatePartitionTimezone": "string",
    --       "DictPageSizeLimit": number,
    --       "EnableStatistics": boolean,
    --       "EncodingType": "string",
    --       "EncryptionMode": "string",
    --       "ExternalTableDefinition": "string",
    --       "IgnoreHeaderRows": number,
    --       "IncludeOpForFullLoad": boolean,
    --       "MaxFileSize": number,
    --       "ParquetTimestampInMillisecond": boolean,
    --       "ParquetVersion": "string",
    --       "PreserveTransactions": boolean,
    --       "Rfc4180": boolean,
    --       "RowGroupLength": number,
    --       "ServerSideEncryptionKmsKeyId": "string",
    --       "ServiceAccessRoleArn": "string",
    --       "TimestampColumnName": "string",
    --       "UseCsvNoSupValue": boolean,
    --       "UseTaskStartTimeForFullLoadTimestamp": boolean
    --     },
    --     "ServerName": "string",
    --     "ServiceAccessRoleArn": "string",
    --     "SslMode": "string",
    --     "Status": "string",
    --     "SybaseSettings": {
    --       "DatabaseName": "string",
    --       "Password": "string",
    --       "Port": number,
    --       "SecretsManagerAccessRoleArn": "string",
    --       "SecretsManagerSecretId": "string",
    --       "ServerName": "string",
    --       "Username": "string"
    --     },
    --     "Username": "string"
    --   }
    -- }

    EXEC @hr = sp_OADestroy @rest
    EXEC @hr = sp_OADestroy @authAws
    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @sbRequestBody
    EXEC @hr = sp_OADestroy @sbResponseBody
    EXEC @hr = sp_OADestroy @jResp


END
GO