DeleteEndpoint SQL Server Example
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, 'EndpointArn', 'string'
-- The JSON request body created by the above code:
-- {
-- "EndpointArn": "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.DeleteEndpoint'
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
