ModifyEndpoint autoit Example
; This example requires the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.
$oRest = ObjCreate("Chilkat_9_5_0.Rest")
Local $bSuccess
$oAuthAws = ObjCreate("Chilkat_9_5_0.AuthAws")
$oAuthAws.AccessKey = "AWS_ACCESS_KEY"
$oAuthAws.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.)
$oAuthAws.Region = "us-west-2"
$oAuthAws.ServiceName = "dms"
; SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
$oRest.SetAuthAws($oAuthAws)
; URL: https://dms.us-west-2.amazonaws.com/
; Use the same region as specified above.
$bSuccess = $oRest.Connect("dms.us-west-2.amazonaws.com",443,True,True)
If ($bSuccess <> True) Then
ConsoleWrite("ConnectFailReason: " & $oRest.ConnectFailReason & @CRLF)
ConsoleWrite($oRest.LastErrorText & @CRLF)
Exit
EndIf
; 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
$oJson = ObjCreate("Chilkat_9_5_0.JsonObject")
$oJson.UpdateString("CertificateArn","string")
$oJson.UpdateString("DatabaseName","string")
$oJson.UpdateString("DmsTransferSettings.BucketName","string")
$oJson.UpdateString("DmsTransferSettings.ServiceAccessRoleArn","string")
$oJson.UpdateString("DocDbSettings.DatabaseName","string")
$oJson.UpdateInt("DocDbSettings.DocsToInvestigate",123)
$oJson.UpdateInt("DocDbSettings.ExtractDocId",123)
$oJson.UpdateString("DocDbSettings.KmsKeyId","string")
$oJson.UpdateString("DocDbSettings.NestingLevel","string")
$oJson.UpdateString("DocDbSettings.Password","string")
$oJson.UpdateInt("DocDbSettings.Port",123)
$oJson.UpdateString("DocDbSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("DocDbSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("DocDbSettings.ServerName","string")
$oJson.UpdateString("DocDbSettings.Username","string")
$oJson.UpdateString("DynamoDbSettings.ServiceAccessRoleArn","string")
$oJson.UpdateString("ElasticsearchSettings.EndpointUri","string")
$oJson.UpdateInt("ElasticsearchSettings.ErrorRetryDuration",123)
$oJson.UpdateInt("ElasticsearchSettings.FullLoadErrorPercentage",123)
$oJson.UpdateString("ElasticsearchSettings.ServiceAccessRoleArn","string")
$oJson.UpdateString("EndpointArn","string")
$oJson.UpdateString("EndpointIdentifier","string")
$oJson.UpdateString("EndpointType","string")
$oJson.UpdateString("EngineName","string")
$oJson.UpdateInt("ExactSettings",123)
$oJson.UpdateString("ExternalTableDefinition","string")
$oJson.UpdateString("ExtraConnectionAttributes","string")
$oJson.UpdateString("GcpMySQLSettings.AfterConnectScript","string")
$oJson.UpdateInt("GcpMySQLSettings.CleanSourceMetadataOnMismatch",123)
$oJson.UpdateString("GcpMySQLSettings.DatabaseName","string")
$oJson.UpdateInt("GcpMySQLSettings.EventsPollInterval",123)
$oJson.UpdateInt("GcpMySQLSettings.MaxFileSize",123)
$oJson.UpdateInt("GcpMySQLSettings.ParallelLoadThreads",123)
$oJson.UpdateString("GcpMySQLSettings.Password","string")
$oJson.UpdateInt("GcpMySQLSettings.Port",123)
$oJson.UpdateString("GcpMySQLSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("GcpMySQLSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("GcpMySQLSettings.ServerName","string")
$oJson.UpdateString("GcpMySQLSettings.ServerTimezone","string")
$oJson.UpdateString("GcpMySQLSettings.TargetDbType","string")
$oJson.UpdateString("GcpMySQLSettings.Username","string")
$oJson.UpdateString("IBMDb2Settings.CurrentLsn","string")
$oJson.UpdateString("IBMDb2Settings.DatabaseName","string")
$oJson.UpdateInt("IBMDb2Settings.MaxKBytesPerRead",123)
$oJson.UpdateString("IBMDb2Settings.Password","string")
$oJson.UpdateInt("IBMDb2Settings.Port",123)
$oJson.UpdateString("IBMDb2Settings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("IBMDb2Settings.SecretsManagerSecretId","string")
$oJson.UpdateString("IBMDb2Settings.ServerName","string")
$oJson.UpdateInt("IBMDb2Settings.SetDataCaptureChanges",123)
$oJson.UpdateString("IBMDb2Settings.Username","string")
$oJson.UpdateString("KafkaSettings.Broker","string")
$oJson.UpdateInt("KafkaSettings.IncludeControlDetails",123)
$oJson.UpdateInt("KafkaSettings.IncludeNullAndEmpty",123)
$oJson.UpdateInt("KafkaSettings.IncludePartitionValue",123)
$oJson.UpdateInt("KafkaSettings.IncludeTableAlterOperations",123)
$oJson.UpdateInt("KafkaSettings.IncludeTransactionDetails",123)
$oJson.UpdateString("KafkaSettings.MessageFormat","string")
$oJson.UpdateInt("KafkaSettings.MessageMaxBytes",123)
$oJson.UpdateInt("KafkaSettings.NoHexPrefix",123)
$oJson.UpdateInt("KafkaSettings.PartitionIncludeSchemaTable",123)
$oJson.UpdateString("KafkaSettings.SaslPassword","string")
$oJson.UpdateString("KafkaSettings.SaslUsername","string")
$oJson.UpdateString("KafkaSettings.SecurityProtocol","string")
$oJson.UpdateString("KafkaSettings.SslCaCertificateArn","string")
$oJson.UpdateString("KafkaSettings.SslClientCertificateArn","string")
$oJson.UpdateString("KafkaSettings.SslClientKeyArn","string")
$oJson.UpdateString("KafkaSettings.SslClientKeyPassword","string")
$oJson.UpdateString("KafkaSettings.Topic","string")
$oJson.UpdateInt("KinesisSettings.IncludeControlDetails",123)
$oJson.UpdateInt("KinesisSettings.IncludeNullAndEmpty",123)
$oJson.UpdateInt("KinesisSettings.IncludePartitionValue",123)
$oJson.UpdateInt("KinesisSettings.IncludeTableAlterOperations",123)
$oJson.UpdateInt("KinesisSettings.IncludeTransactionDetails",123)
$oJson.UpdateString("KinesisSettings.MessageFormat","string")
$oJson.UpdateInt("KinesisSettings.NoHexPrefix",123)
$oJson.UpdateInt("KinesisSettings.PartitionIncludeSchemaTable",123)
$oJson.UpdateString("KinesisSettings.ServiceAccessRoleArn","string")
$oJson.UpdateString("KinesisSettings.StreamArn","string")
$oJson.UpdateInt("MicrosoftSQLServerSettings.BcpPacketSize",123)
$oJson.UpdateString("MicrosoftSQLServerSettings.ControlTablesFileGroup","string")
$oJson.UpdateString("MicrosoftSQLServerSettings.DatabaseName","string")
$oJson.UpdateString("MicrosoftSQLServerSettings.Password","string")
$oJson.UpdateInt("MicrosoftSQLServerSettings.Port",123)
$oJson.UpdateInt("MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode",123)
$oJson.UpdateInt("MicrosoftSQLServerSettings.ReadBackupOnly",123)
$oJson.UpdateString("MicrosoftSQLServerSettings.SafeguardPolicy","string")
$oJson.UpdateString("MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("MicrosoftSQLServerSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("MicrosoftSQLServerSettings.ServerName","string")
$oJson.UpdateInt("MicrosoftSQLServerSettings.UseBcpFullLoad",123)
$oJson.UpdateString("MicrosoftSQLServerSettings.Username","string")
$oJson.UpdateInt("MicrosoftSQLServerSettings.UseThirdPartyBackupDevice",123)
$oJson.UpdateString("MongoDbSettings.AuthMechanism","string")
$oJson.UpdateString("MongoDbSettings.AuthSource","string")
$oJson.UpdateString("MongoDbSettings.AuthType","string")
$oJson.UpdateString("MongoDbSettings.DatabaseName","string")
$oJson.UpdateString("MongoDbSettings.DocsToInvestigate","string")
$oJson.UpdateString("MongoDbSettings.ExtractDocId","string")
$oJson.UpdateString("MongoDbSettings.KmsKeyId","string")
$oJson.UpdateString("MongoDbSettings.NestingLevel","string")
$oJson.UpdateString("MongoDbSettings.Password","string")
$oJson.UpdateInt("MongoDbSettings.Port",123)
$oJson.UpdateString("MongoDbSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("MongoDbSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("MongoDbSettings.ServerName","string")
$oJson.UpdateString("MongoDbSettings.Username","string")
$oJson.UpdateString("MySQLSettings.AfterConnectScript","string")
$oJson.UpdateInt("MySQLSettings.CleanSourceMetadataOnMismatch",123)
$oJson.UpdateString("MySQLSettings.DatabaseName","string")
$oJson.UpdateInt("MySQLSettings.EventsPollInterval",123)
$oJson.UpdateInt("MySQLSettings.MaxFileSize",123)
$oJson.UpdateInt("MySQLSettings.ParallelLoadThreads",123)
$oJson.UpdateString("MySQLSettings.Password","string")
$oJson.UpdateInt("MySQLSettings.Port",123)
$oJson.UpdateString("MySQLSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("MySQLSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("MySQLSettings.ServerName","string")
$oJson.UpdateString("MySQLSettings.ServerTimezone","string")
$oJson.UpdateString("MySQLSettings.TargetDbType","string")
$oJson.UpdateString("MySQLSettings.Username","string")
$oJson.UpdateInt("NeptuneSettings.ErrorRetryDuration",123)
$oJson.UpdateInt("NeptuneSettings.IamAuthEnabled",123)
$oJson.UpdateInt("NeptuneSettings.MaxFileSize",123)
$oJson.UpdateInt("NeptuneSettings.MaxRetryCount",123)
$oJson.UpdateString("NeptuneSettings.S3BucketFolder","string")
$oJson.UpdateString("NeptuneSettings.S3BucketName","string")
$oJson.UpdateString("NeptuneSettings.ServiceAccessRoleArn","string")
$oJson.UpdateInt("OracleSettings.AccessAlternateDirectly",123)
$oJson.UpdateInt("OracleSettings.AdditionalArchivedLogDestId",123)
$oJson.UpdateInt("OracleSettings.AddSupplementalLogging",123)
$oJson.UpdateInt("OracleSettings.AllowSelectNestedTables",123)
$oJson.UpdateInt("OracleSettings.ArchivedLogDestId",123)
$oJson.UpdateInt("OracleSettings.ArchivedLogsOnly",123)
$oJson.UpdateString("OracleSettings.AsmPassword","string")
$oJson.UpdateString("OracleSettings.AsmServer","string")
$oJson.UpdateString("OracleSettings.AsmUser","string")
$oJson.UpdateString("OracleSettings.CharLengthSemantics","string")
$oJson.UpdateString("OracleSettings.DatabaseName","string")
$oJson.UpdateInt("OracleSettings.DirectPathNoLog",123)
$oJson.UpdateInt("OracleSettings.DirectPathParallelLoad",123)
$oJson.UpdateInt("OracleSettings.EnableHomogenousTablespace",123)
ERROR: Undefined variable(number)
$oJson.UpdateInt("OracleSettings.ExtraArchivedLogDestIds[0]",ERROR: Undefined variable(number)
)
$oJson.UpdateInt("OracleSettings.FailTasksOnLobTruncation",123)
$oJson.UpdateInt("OracleSettings.NumberDatatypeScale",123)
$oJson.UpdateString("OracleSettings.OraclePathPrefix","string")
$oJson.UpdateInt("OracleSettings.ParallelAsmReadThreads",123)
$oJson.UpdateString("OracleSettings.Password","string")
$oJson.UpdateInt("OracleSettings.Port",123)
$oJson.UpdateInt("OracleSettings.ReadAheadBlocks",123)
$oJson.UpdateInt("OracleSettings.ReadTableSpaceName",123)
$oJson.UpdateInt("OracleSettings.ReplacePathPrefix",123)
$oJson.UpdateInt("OracleSettings.RetryInterval",123)
$oJson.UpdateString("OracleSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("OracleSettings.SecretsManagerOracleAsmAccessRoleArn","string")
$oJson.UpdateString("OracleSettings.SecretsManagerOracleAsmSecretId","string")
$oJson.UpdateString("OracleSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("OracleSettings.SecurityDbEncryption","string")
$oJson.UpdateString("OracleSettings.SecurityDbEncryptionName","string")
$oJson.UpdateString("OracleSettings.ServerName","string")
$oJson.UpdateString("OracleSettings.SpatialDataOptionToGeoJsonFunctionName","string")
$oJson.UpdateInt("OracleSettings.StandbyDelayTime",123)
$oJson.UpdateInt("OracleSettings.UseAlternateFolderForOnline",123)
$oJson.UpdateInt("OracleSettings.UseBFile",123)
$oJson.UpdateInt("OracleSettings.UseDirectPathFullLoad",123)
$oJson.UpdateInt("OracleSettings.UseLogminerReader",123)
$oJson.UpdateString("OracleSettings.UsePathPrefix","string")
$oJson.UpdateString("OracleSettings.Username","string")
$oJson.UpdateString("Password","string")
$oJson.UpdateInt("Port",123)
$oJson.UpdateString("PostgreSQLSettings.AfterConnectScript","string")
$oJson.UpdateInt("PostgreSQLSettings.CaptureDdls",123)
$oJson.UpdateString("PostgreSQLSettings.DatabaseName","string")
$oJson.UpdateString("PostgreSQLSettings.DdlArtifactsSchema","string")
$oJson.UpdateInt("PostgreSQLSettings.ExecuteTimeout",123)
$oJson.UpdateInt("PostgreSQLSettings.FailTasksOnLobTruncation",123)
$oJson.UpdateInt("PostgreSQLSettings.HeartbeatEnable",123)
$oJson.UpdateInt("PostgreSQLSettings.HeartbeatFrequency",123)
$oJson.UpdateString("PostgreSQLSettings.HeartbeatSchema","string")
$oJson.UpdateInt("PostgreSQLSettings.MaxFileSize",123)
$oJson.UpdateString("PostgreSQLSettings.Password","string")
$oJson.UpdateString("PostgreSQLSettings.PluginName","string")
$oJson.UpdateInt("PostgreSQLSettings.Port",123)
$oJson.UpdateString("PostgreSQLSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("PostgreSQLSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("PostgreSQLSettings.ServerName","string")
$oJson.UpdateString("PostgreSQLSettings.SlotName","string")
$oJson.UpdateString("PostgreSQLSettings.Username","string")
$oJson.UpdateString("RedisSettings.AuthPassword","string")
$oJson.UpdateString("RedisSettings.AuthType","string")
$oJson.UpdateString("RedisSettings.AuthUserName","string")
$oJson.UpdateInt("RedisSettings.Port",123)
$oJson.UpdateString("RedisSettings.ServerName","string")
$oJson.UpdateString("RedisSettings.SslCaCertificateArn","string")
$oJson.UpdateString("RedisSettings.SslSecurityProtocol","string")
$oJson.UpdateInt("RedshiftSettings.AcceptAnyDate",123)
$oJson.UpdateString("RedshiftSettings.AfterConnectScript","string")
$oJson.UpdateString("RedshiftSettings.BucketFolder","string")
$oJson.UpdateString("RedshiftSettings.BucketName","string")
$oJson.UpdateInt("RedshiftSettings.CaseSensitiveNames",123)
$oJson.UpdateInt("RedshiftSettings.CompUpdate",123)
$oJson.UpdateInt("RedshiftSettings.ConnectionTimeout",123)
$oJson.UpdateString("RedshiftSettings.DatabaseName","string")
$oJson.UpdateString("RedshiftSettings.DateFormat","string")
$oJson.UpdateInt("RedshiftSettings.EmptyAsNull",123)
$oJson.UpdateString("RedshiftSettings.EncryptionMode","string")
$oJson.UpdateInt("RedshiftSettings.ExplicitIds",123)
$oJson.UpdateInt("RedshiftSettings.FileTransferUploadStreams",123)
$oJson.UpdateInt("RedshiftSettings.LoadTimeout",123)
$oJson.UpdateInt("RedshiftSettings.MaxFileSize",123)
$oJson.UpdateString("RedshiftSettings.Password","string")
$oJson.UpdateInt("RedshiftSettings.Port",123)
$oJson.UpdateInt("RedshiftSettings.RemoveQuotes",123)
$oJson.UpdateString("RedshiftSettings.ReplaceChars","string")
$oJson.UpdateString("RedshiftSettings.ReplaceInvalidChars","string")
$oJson.UpdateString("RedshiftSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("RedshiftSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("RedshiftSettings.ServerName","string")
$oJson.UpdateString("RedshiftSettings.ServerSideEncryptionKmsKeyId","string")
$oJson.UpdateString("RedshiftSettings.ServiceAccessRoleArn","string")
$oJson.UpdateString("RedshiftSettings.TimeFormat","string")
$oJson.UpdateInt("RedshiftSettings.TrimBlanks",123)
$oJson.UpdateInt("RedshiftSettings.TruncateColumns",123)
$oJson.UpdateString("RedshiftSettings.Username","string")
$oJson.UpdateInt("RedshiftSettings.WriteBufferSize",123)
$oJson.UpdateInt("S3Settings.AddColumnName",123)
$oJson.UpdateString("S3Settings.BucketFolder","string")
$oJson.UpdateString("S3Settings.BucketName","string")
$oJson.UpdateString("S3Settings.CannedAclForObjects","string")
$oJson.UpdateInt("S3Settings.CdcInsertsAndUpdates",123)
$oJson.UpdateInt("S3Settings.CdcInsertsOnly",123)
$oJson.UpdateInt("S3Settings.CdcMaxBatchInterval",123)
$oJson.UpdateInt("S3Settings.CdcMinFileSize",123)
$oJson.UpdateString("S3Settings.CdcPath","string")
$oJson.UpdateString("S3Settings.CompressionType","string")
$oJson.UpdateString("S3Settings.CsvDelimiter","string")
$oJson.UpdateString("S3Settings.CsvNoSupValue","string")
$oJson.UpdateString("S3Settings.CsvNullValue","string")
$oJson.UpdateString("S3Settings.CsvRowDelimiter","string")
$oJson.UpdateString("S3Settings.DataFormat","string")
$oJson.UpdateInt("S3Settings.DataPageSize",123)
$oJson.UpdateString("S3Settings.DatePartitionDelimiter","string")
$oJson.UpdateInt("S3Settings.DatePartitionEnabled",123)
$oJson.UpdateString("S3Settings.DatePartitionSequence","string")
$oJson.UpdateString("S3Settings.DatePartitionTimezone","string")
$oJson.UpdateInt("S3Settings.DictPageSizeLimit",123)
$oJson.UpdateInt("S3Settings.EnableStatistics",123)
$oJson.UpdateString("S3Settings.EncodingType","string")
$oJson.UpdateString("S3Settings.EncryptionMode","string")
$oJson.UpdateString("S3Settings.ExternalTableDefinition","string")
$oJson.UpdateInt("S3Settings.IgnoreHeaderRows",123)
$oJson.UpdateInt("S3Settings.IncludeOpForFullLoad",123)
$oJson.UpdateInt("S3Settings.MaxFileSize",123)
$oJson.UpdateInt("S3Settings.ParquetTimestampInMillisecond",123)
$oJson.UpdateString("S3Settings.ParquetVersion","string")
$oJson.UpdateInt("S3Settings.PreserveTransactions",123)
$oJson.UpdateInt("S3Settings.Rfc4180",123)
$oJson.UpdateInt("S3Settings.RowGroupLength",123)
$oJson.UpdateString("S3Settings.ServerSideEncryptionKmsKeyId","string")
$oJson.UpdateString("S3Settings.ServiceAccessRoleArn","string")
$oJson.UpdateString("S3Settings.TimestampColumnName","string")
$oJson.UpdateInt("S3Settings.UseCsvNoSupValue",123)
$oJson.UpdateInt("S3Settings.UseTaskStartTimeForFullLoadTimestamp",123)
$oJson.UpdateString("ServerName","string")
$oJson.UpdateString("ServiceAccessRoleArn","string")
$oJson.UpdateString("SslMode","string")
$oJson.UpdateString("SybaseSettings.DatabaseName","string")
$oJson.UpdateString("SybaseSettings.Password","string")
$oJson.UpdateInt("SybaseSettings.Port",123)
$oJson.UpdateString("SybaseSettings.SecretsManagerAccessRoleArn","string")
$oJson.UpdateString("SybaseSettings.SecretsManagerSecretId","string")
$oJson.UpdateString("SybaseSettings.ServerName","string")
$oJson.UpdateString("SybaseSettings.Username","string")
$oJson.UpdateString("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"
; },
; "EndpointArn": "string",
; "EndpointIdentifier": "string",
; "EndpointType": "string",
; "EngineName": "string",
; "ExactSettings": boolean,
; "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"
; },
; "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
; },
; "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"
; },
; "Username": "string"
; }
$oRest.AddHeader("Content-Type","application/x-amz-json-1.1")
$oRest.AddHeader("X-Amz-Target","AmazonDMSv20160101.ModifyEndpoint")
$oSbRequestBody = ObjCreate("Chilkat_9_5_0.StringBuilder")
$oJson.EmitSb($oSbRequestBody)
$oSbResponseBody = ObjCreate("Chilkat_9_5_0.StringBuilder")
$bSuccess = $oRest.FullRequestSb("POST","/",$oSbRequestBody,$oSbResponseBody)
If ($bSuccess <> True) Then
ConsoleWrite($oRest.LastErrorText & @CRLF)
Exit
EndIf
Local $iRespStatusCode = $oRest.ResponseStatusCode
ConsoleWrite("response status code = " & $iRespStatusCode & @CRLF)
If ($iRespStatusCode <> 200) Then
ConsoleWrite("Response Header:" & @CRLF)
ConsoleWrite($oRest.ResponseHeader & @CRLF)
ConsoleWrite("Response Body:" & @CRLF)
ConsoleWrite($oSbResponseBody.GetAsString() & @CRLF)
Exit
EndIf
$oJResp = ObjCreate("Chilkat_9_5_0.JsonObject")
$oJResp.LoadSb($oSbResponseBody)
; 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
Local $intVal
Local $sCertificateArn = $oJResp.StringOf("Endpoint.CertificateArn")
Local $sDatabaseName = $oJResp.StringOf("Endpoint.DatabaseName")
Local $sBucketName = $oJResp.StringOf("Endpoint.DmsTransferSettings.BucketName")
Local $sServiceAccessRoleArn = $oJResp.StringOf("Endpoint.DmsTransferSettings.ServiceAccessRoleArn")
Local $sDocDbSettingsDatabaseName = $oJResp.StringOf("Endpoint.DocDbSettings.DatabaseName")
Local $iDocsToInvestigate = $oJResp.IntOf("Endpoint.DocDbSettings.DocsToInvestigate")
Local $iExtractDocId = $oJResp.IntOf("Endpoint.DocDbSettings.ExtractDocId")
Local $sKmsKeyId = $oJResp.StringOf("Endpoint.DocDbSettings.KmsKeyId")
Local $sNestingLevel = $oJResp.StringOf("Endpoint.DocDbSettings.NestingLevel")
Local $sPassword = $oJResp.StringOf("Endpoint.DocDbSettings.Password")
Local $iPort = $oJResp.IntOf("Endpoint.DocDbSettings.Port")
Local $sSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.DocDbSettings.SecretsManagerAccessRoleArn")
Local $sSecretsManagerSecretId = $oJResp.StringOf("Endpoint.DocDbSettings.SecretsManagerSecretId")
Local $sServerName = $oJResp.StringOf("Endpoint.DocDbSettings.ServerName")
Local $sUsername = $oJResp.StringOf("Endpoint.DocDbSettings.Username")
Local $sDynamoDbSettingsServiceAccessRoleArn = $oJResp.StringOf("Endpoint.DynamoDbSettings.ServiceAccessRoleArn")
Local $sEndpointUri = $oJResp.StringOf("Endpoint.ElasticsearchSettings.EndpointUri")
Local $iErrorRetryDuration = $oJResp.IntOf("Endpoint.ElasticsearchSettings.ErrorRetryDuration")
Local $iFullLoadErrorPercentage = $oJResp.IntOf("Endpoint.ElasticsearchSettings.FullLoadErrorPercentage")
Local $sElasticsearchSettingsServiceAccessRoleArn = $oJResp.StringOf("Endpoint.ElasticsearchSettings.ServiceAccessRoleArn")
Local $sEndpointArn = $oJResp.StringOf("Endpoint.EndpointArn")
Local $sEndpointIdentifier = $oJResp.StringOf("Endpoint.EndpointIdentifier")
Local $sEndpointType = $oJResp.StringOf("Endpoint.EndpointType")
Local $sEngineDisplayName = $oJResp.StringOf("Endpoint.EngineDisplayName")
Local $sEngineName = $oJResp.StringOf("Endpoint.EngineName")
Local $sExternalId = $oJResp.StringOf("Endpoint.ExternalId")
Local $sExternalTableDefinition = $oJResp.StringOf("Endpoint.ExternalTableDefinition")
Local $sExtraConnectionAttributes = $oJResp.StringOf("Endpoint.ExtraConnectionAttributes")
Local $sAfterConnectScript = $oJResp.StringOf("Endpoint.GcpMySQLSettings.AfterConnectScript")
Local $iCleanSourceMetadataOnMismatch = $oJResp.IntOf("Endpoint.GcpMySQLSettings.CleanSourceMetadataOnMismatch")
Local $sGcpMySQLSettingsDatabaseName = $oJResp.StringOf("Endpoint.GcpMySQLSettings.DatabaseName")
Local $iEventsPollInterval = $oJResp.IntOf("Endpoint.GcpMySQLSettings.EventsPollInterval")
Local $iMaxFileSize = $oJResp.IntOf("Endpoint.GcpMySQLSettings.MaxFileSize")
Local $iParallelLoadThreads = $oJResp.IntOf("Endpoint.GcpMySQLSettings.ParallelLoadThreads")
Local $sGcpMySQLSettingsPassword = $oJResp.StringOf("Endpoint.GcpMySQLSettings.Password")
Local $iGcpMySQLSettingsPort = $oJResp.IntOf("Endpoint.GcpMySQLSettings.Port")
Local $sGcpMySQLSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.GcpMySQLSettings.SecretsManagerAccessRoleArn")
Local $sGcpMySQLSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.GcpMySQLSettings.SecretsManagerSecretId")
Local $sGcpMySQLSettingsServerName = $oJResp.StringOf("Endpoint.GcpMySQLSettings.ServerName")
Local $sServerTimezone = $oJResp.StringOf("Endpoint.GcpMySQLSettings.ServerTimezone")
Local $sTargetDbType = $oJResp.StringOf("Endpoint.GcpMySQLSettings.TargetDbType")
Local $sGcpMySQLSettingsUsername = $oJResp.StringOf("Endpoint.GcpMySQLSettings.Username")
Local $sCurrentLsn = $oJResp.StringOf("Endpoint.IBMDb2Settings.CurrentLsn")
Local $sIBMDb2SettingsDatabaseName = $oJResp.StringOf("Endpoint.IBMDb2Settings.DatabaseName")
Local $iMaxKBytesPerRead = $oJResp.IntOf("Endpoint.IBMDb2Settings.MaxKBytesPerRead")
Local $sIBMDb2SettingsPassword = $oJResp.StringOf("Endpoint.IBMDb2Settings.Password")
Local $iIBMDb2SettingsPort = $oJResp.IntOf("Endpoint.IBMDb2Settings.Port")
Local $sIBMDb2SettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.IBMDb2Settings.SecretsManagerAccessRoleArn")
Local $sIBMDb2SettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.IBMDb2Settings.SecretsManagerSecretId")
Local $sIBMDb2SettingsServerName = $oJResp.StringOf("Endpoint.IBMDb2Settings.ServerName")
Local $iSetDataCaptureChanges = $oJResp.IntOf("Endpoint.IBMDb2Settings.SetDataCaptureChanges")
Local $sIBMDb2SettingsUsername = $oJResp.StringOf("Endpoint.IBMDb2Settings.Username")
Local $sBroker = $oJResp.StringOf("Endpoint.KafkaSettings.Broker")
Local $iIncludeControlDetails = $oJResp.IntOf("Endpoint.KafkaSettings.IncludeControlDetails")
Local $iIncludeNullAndEmpty = $oJResp.IntOf("Endpoint.KafkaSettings.IncludeNullAndEmpty")
Local $iIncludePartitionValue = $oJResp.IntOf("Endpoint.KafkaSettings.IncludePartitionValue")
Local $iIncludeTableAlterOperations = $oJResp.IntOf("Endpoint.KafkaSettings.IncludeTableAlterOperations")
Local $iIncludeTransactionDetails = $oJResp.IntOf("Endpoint.KafkaSettings.IncludeTransactionDetails")
Local $sMessageFormat = $oJResp.StringOf("Endpoint.KafkaSettings.MessageFormat")
Local $iMessageMaxBytes = $oJResp.IntOf("Endpoint.KafkaSettings.MessageMaxBytes")
Local $iNoHexPrefix = $oJResp.IntOf("Endpoint.KafkaSettings.NoHexPrefix")
Local $iPartitionIncludeSchemaTable = $oJResp.IntOf("Endpoint.KafkaSettings.PartitionIncludeSchemaTable")
Local $sSaslPassword = $oJResp.StringOf("Endpoint.KafkaSettings.SaslPassword")
Local $sSaslUsername = $oJResp.StringOf("Endpoint.KafkaSettings.SaslUsername")
Local $sSecurityProtocol = $oJResp.StringOf("Endpoint.KafkaSettings.SecurityProtocol")
Local $sSslCaCertificateArn = $oJResp.StringOf("Endpoint.KafkaSettings.SslCaCertificateArn")
Local $sSslClientCertificateArn = $oJResp.StringOf("Endpoint.KafkaSettings.SslClientCertificateArn")
Local $sSslClientKeyArn = $oJResp.StringOf("Endpoint.KafkaSettings.SslClientKeyArn")
Local $sSslClientKeyPassword = $oJResp.StringOf("Endpoint.KafkaSettings.SslClientKeyPassword")
Local $sTopic = $oJResp.StringOf("Endpoint.KafkaSettings.Topic")
Local $iKinesisSettingsIncludeControlDetails = $oJResp.IntOf("Endpoint.KinesisSettings.IncludeControlDetails")
Local $iKinesisSettingsIncludeNullAndEmpty = $oJResp.IntOf("Endpoint.KinesisSettings.IncludeNullAndEmpty")
Local $iKinesisSettingsIncludePartitionValue = $oJResp.IntOf("Endpoint.KinesisSettings.IncludePartitionValue")
Local $iKinesisSettingsIncludeTableAlterOperations = $oJResp.IntOf("Endpoint.KinesisSettings.IncludeTableAlterOperations")
Local $iKinesisSettingsIncludeTransactionDetails = $oJResp.IntOf("Endpoint.KinesisSettings.IncludeTransactionDetails")
Local $sKinesisSettingsMessageFormat = $oJResp.StringOf("Endpoint.KinesisSettings.MessageFormat")
Local $iKinesisSettingsNoHexPrefix = $oJResp.IntOf("Endpoint.KinesisSettings.NoHexPrefix")
Local $iKinesisSettingsPartitionIncludeSchemaTable = $oJResp.IntOf("Endpoint.KinesisSettings.PartitionIncludeSchemaTable")
Local $sKinesisSettingsServiceAccessRoleArn = $oJResp.StringOf("Endpoint.KinesisSettings.ServiceAccessRoleArn")
Local $sStreamArn = $oJResp.StringOf("Endpoint.KinesisSettings.StreamArn")
Local $sEndpointKmsKeyId = $oJResp.StringOf("Endpoint.KmsKeyId")
Local $iBcpPacketSize = $oJResp.IntOf("Endpoint.MicrosoftSQLServerSettings.BcpPacketSize")
Local $sControlTablesFileGroup = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.ControlTablesFileGroup")
Local $sMicrosoftSQLServerSettingsDatabaseName = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.DatabaseName")
Local $sMicrosoftSQLServerSettingsPassword = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.Password")
Local $iMicrosoftSQLServerSettingsPort = $oJResp.IntOf("Endpoint.MicrosoftSQLServerSettings.Port")
Local $iQuerySingleAlwaysOnNode = $oJResp.IntOf("Endpoint.MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode")
Local $iReadBackupOnly = $oJResp.IntOf("Endpoint.MicrosoftSQLServerSettings.ReadBackupOnly")
Local $sSafeguardPolicy = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SafeguardPolicy")
Local $sMicrosoftSQLServerSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn")
Local $sMicrosoftSQLServerSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SecretsManagerSecretId")
Local $sMicrosoftSQLServerSettingsServerName = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.ServerName")
Local $iUseBcpFullLoad = $oJResp.IntOf("Endpoint.MicrosoftSQLServerSettings.UseBcpFullLoad")
Local $sMicrosoftSQLServerSettingsUsername = $oJResp.StringOf("Endpoint.MicrosoftSQLServerSettings.Username")
Local $iUseThirdPartyBackupDevice = $oJResp.IntOf("Endpoint.MicrosoftSQLServerSettings.UseThirdPartyBackupDevice")
Local $sAuthMechanism = $oJResp.StringOf("Endpoint.MongoDbSettings.AuthMechanism")
Local $sAuthSource = $oJResp.StringOf("Endpoint.MongoDbSettings.AuthSource")
Local $sAuthType = $oJResp.StringOf("Endpoint.MongoDbSettings.AuthType")
Local $sMongoDbSettingsDatabaseName = $oJResp.StringOf("Endpoint.MongoDbSettings.DatabaseName")
Local $sMongoDbSettingsDocsToInvestigate = $oJResp.StringOf("Endpoint.MongoDbSettings.DocsToInvestigate")
Local $sMongoDbSettingsExtractDocId = $oJResp.StringOf("Endpoint.MongoDbSettings.ExtractDocId")
Local $sMongoDbSettingsKmsKeyId = $oJResp.StringOf("Endpoint.MongoDbSettings.KmsKeyId")
Local $sMongoDbSettingsNestingLevel = $oJResp.StringOf("Endpoint.MongoDbSettings.NestingLevel")
Local $sMongoDbSettingsPassword = $oJResp.StringOf("Endpoint.MongoDbSettings.Password")
Local $iMongoDbSettingsPort = $oJResp.IntOf("Endpoint.MongoDbSettings.Port")
Local $sMongoDbSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.MongoDbSettings.SecretsManagerAccessRoleArn")
Local $sMongoDbSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.MongoDbSettings.SecretsManagerSecretId")
Local $sMongoDbSettingsServerName = $oJResp.StringOf("Endpoint.MongoDbSettings.ServerName")
Local $sMongoDbSettingsUsername = $oJResp.StringOf("Endpoint.MongoDbSettings.Username")
Local $sMySQLSettingsAfterConnectScript = $oJResp.StringOf("Endpoint.MySQLSettings.AfterConnectScript")
Local $iMySQLSettingsCleanSourceMetadataOnMismatch = $oJResp.IntOf("Endpoint.MySQLSettings.CleanSourceMetadataOnMismatch")
Local $sMySQLSettingsDatabaseName = $oJResp.StringOf("Endpoint.MySQLSettings.DatabaseName")
Local $iMySQLSettingsEventsPollInterval = $oJResp.IntOf("Endpoint.MySQLSettings.EventsPollInterval")
Local $iMySQLSettingsMaxFileSize = $oJResp.IntOf("Endpoint.MySQLSettings.MaxFileSize")
Local $iMySQLSettingsParallelLoadThreads = $oJResp.IntOf("Endpoint.MySQLSettings.ParallelLoadThreads")
Local $sMySQLSettingsPassword = $oJResp.StringOf("Endpoint.MySQLSettings.Password")
Local $iMySQLSettingsPort = $oJResp.IntOf("Endpoint.MySQLSettings.Port")
Local $sMySQLSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.MySQLSettings.SecretsManagerAccessRoleArn")
Local $sMySQLSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.MySQLSettings.SecretsManagerSecretId")
Local $sMySQLSettingsServerName = $oJResp.StringOf("Endpoint.MySQLSettings.ServerName")
Local $sMySQLSettingsServerTimezone = $oJResp.StringOf("Endpoint.MySQLSettings.ServerTimezone")
Local $sMySQLSettingsTargetDbType = $oJResp.StringOf("Endpoint.MySQLSettings.TargetDbType")
Local $sMySQLSettingsUsername = $oJResp.StringOf("Endpoint.MySQLSettings.Username")
Local $iNeptuneSettingsErrorRetryDuration = $oJResp.IntOf("Endpoint.NeptuneSettings.ErrorRetryDuration")
Local $iIamAuthEnabled = $oJResp.IntOf("Endpoint.NeptuneSettings.IamAuthEnabled")
Local $iNeptuneSettingsMaxFileSize = $oJResp.IntOf("Endpoint.NeptuneSettings.MaxFileSize")
Local $iMaxRetryCount = $oJResp.IntOf("Endpoint.NeptuneSettings.MaxRetryCount")
Local $sS3BucketFolder = $oJResp.StringOf("Endpoint.NeptuneSettings.S3BucketFolder")
Local $sS3BucketName = $oJResp.StringOf("Endpoint.NeptuneSettings.S3BucketName")
Local $sNeptuneSettingsServiceAccessRoleArn = $oJResp.StringOf("Endpoint.NeptuneSettings.ServiceAccessRoleArn")
Local $iAccessAlternateDirectly = $oJResp.IntOf("Endpoint.OracleSettings.AccessAlternateDirectly")
Local $iAdditionalArchivedLogDestId = $oJResp.IntOf("Endpoint.OracleSettings.AdditionalArchivedLogDestId")
Local $iAddSupplementalLogging = $oJResp.IntOf("Endpoint.OracleSettings.AddSupplementalLogging")
Local $iAllowSelectNestedTables = $oJResp.IntOf("Endpoint.OracleSettings.AllowSelectNestedTables")
Local $iArchivedLogDestId = $oJResp.IntOf("Endpoint.OracleSettings.ArchivedLogDestId")
Local $iArchivedLogsOnly = $oJResp.IntOf("Endpoint.OracleSettings.ArchivedLogsOnly")
Local $sAsmPassword = $oJResp.StringOf("Endpoint.OracleSettings.AsmPassword")
Local $sAsmServer = $oJResp.StringOf("Endpoint.OracleSettings.AsmServer")
Local $sAsmUser = $oJResp.StringOf("Endpoint.OracleSettings.AsmUser")
Local $sCharLengthSemantics = $oJResp.StringOf("Endpoint.OracleSettings.CharLengthSemantics")
Local $sOracleSettingsDatabaseName = $oJResp.StringOf("Endpoint.OracleSettings.DatabaseName")
Local $iDirectPathNoLog = $oJResp.IntOf("Endpoint.OracleSettings.DirectPathNoLog")
Local $iDirectPathParallelLoad = $oJResp.IntOf("Endpoint.OracleSettings.DirectPathParallelLoad")
Local $iEnableHomogenousTablespace = $oJResp.IntOf("Endpoint.OracleSettings.EnableHomogenousTablespace")
Local $iFailTasksOnLobTruncation = $oJResp.IntOf("Endpoint.OracleSettings.FailTasksOnLobTruncation")
Local $iNumberDatatypeScale = $oJResp.IntOf("Endpoint.OracleSettings.NumberDatatypeScale")
Local $sOraclePathPrefix = $oJResp.StringOf("Endpoint.OracleSettings.OraclePathPrefix")
Local $iParallelAsmReadThreads = $oJResp.IntOf("Endpoint.OracleSettings.ParallelAsmReadThreads")
Local $sOracleSettingsPassword = $oJResp.StringOf("Endpoint.OracleSettings.Password")
Local $iOracleSettingsPort = $oJResp.IntOf("Endpoint.OracleSettings.Port")
Local $iReadAheadBlocks = $oJResp.IntOf("Endpoint.OracleSettings.ReadAheadBlocks")
Local $iReadTableSpaceName = $oJResp.IntOf("Endpoint.OracleSettings.ReadTableSpaceName")
Local $iReplacePathPrefix = $oJResp.IntOf("Endpoint.OracleSettings.ReplacePathPrefix")
Local $iRetryInterval = $oJResp.IntOf("Endpoint.OracleSettings.RetryInterval")
Local $sOracleSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.OracleSettings.SecretsManagerAccessRoleArn")
Local $sSecretsManagerOracleAsmAccessRoleArn = $oJResp.StringOf("Endpoint.OracleSettings.SecretsManagerOracleAsmAccessRoleArn")
Local $sSecretsManagerOracleAsmSecretId = $oJResp.StringOf("Endpoint.OracleSettings.SecretsManagerOracleAsmSecretId")
Local $sOracleSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.OracleSettings.SecretsManagerSecretId")
Local $sSecurityDbEncryption = $oJResp.StringOf("Endpoint.OracleSettings.SecurityDbEncryption")
Local $sSecurityDbEncryptionName = $oJResp.StringOf("Endpoint.OracleSettings.SecurityDbEncryptionName")
Local $sOracleSettingsServerName = $oJResp.StringOf("Endpoint.OracleSettings.ServerName")
Local $sSpatialDataOptionToGeoJsonFunctionName = $oJResp.StringOf("Endpoint.OracleSettings.SpatialDataOptionToGeoJsonFunctionName")
Local $iStandbyDelayTime = $oJResp.IntOf("Endpoint.OracleSettings.StandbyDelayTime")
Local $iUseAlternateFolderForOnline = $oJResp.IntOf("Endpoint.OracleSettings.UseAlternateFolderForOnline")
Local $iUseBFile = $oJResp.IntOf("Endpoint.OracleSettings.UseBFile")
Local $iUseDirectPathFullLoad = $oJResp.IntOf("Endpoint.OracleSettings.UseDirectPathFullLoad")
Local $iUseLogminerReader = $oJResp.IntOf("Endpoint.OracleSettings.UseLogminerReader")
Local $sUsePathPrefix = $oJResp.StringOf("Endpoint.OracleSettings.UsePathPrefix")
Local $sOracleSettingsUsername = $oJResp.StringOf("Endpoint.OracleSettings.Username")
Local $iEndpointPort = $oJResp.IntOf("Endpoint.Port")
Local $sPostgreSQLSettingsAfterConnectScript = $oJResp.StringOf("Endpoint.PostgreSQLSettings.AfterConnectScript")
Local $iCaptureDdls = $oJResp.IntOf("Endpoint.PostgreSQLSettings.CaptureDdls")
Local $sPostgreSQLSettingsDatabaseName = $oJResp.StringOf("Endpoint.PostgreSQLSettings.DatabaseName")
Local $sDdlArtifactsSchema = $oJResp.StringOf("Endpoint.PostgreSQLSettings.DdlArtifactsSchema")
Local $iExecuteTimeout = $oJResp.IntOf("Endpoint.PostgreSQLSettings.ExecuteTimeout")
Local $iPostgreSQLSettingsFailTasksOnLobTruncation = $oJResp.IntOf("Endpoint.PostgreSQLSettings.FailTasksOnLobTruncation")
Local $iHeartbeatEnable = $oJResp.IntOf("Endpoint.PostgreSQLSettings.HeartbeatEnable")
Local $iHeartbeatFrequency = $oJResp.IntOf("Endpoint.PostgreSQLSettings.HeartbeatFrequency")
Local $sHeartbeatSchema = $oJResp.StringOf("Endpoint.PostgreSQLSettings.HeartbeatSchema")
Local $iPostgreSQLSettingsMaxFileSize = $oJResp.IntOf("Endpoint.PostgreSQLSettings.MaxFileSize")
Local $sPostgreSQLSettingsPassword = $oJResp.StringOf("Endpoint.PostgreSQLSettings.Password")
Local $sPluginName = $oJResp.StringOf("Endpoint.PostgreSQLSettings.PluginName")
Local $iPostgreSQLSettingsPort = $oJResp.IntOf("Endpoint.PostgreSQLSettings.Port")
Local $sPostgreSQLSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.PostgreSQLSettings.SecretsManagerAccessRoleArn")
Local $sPostgreSQLSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.PostgreSQLSettings.SecretsManagerSecretId")
Local $sPostgreSQLSettingsServerName = $oJResp.StringOf("Endpoint.PostgreSQLSettings.ServerName")
Local $sSlotName = $oJResp.StringOf("Endpoint.PostgreSQLSettings.SlotName")
Local $sPostgreSQLSettingsUsername = $oJResp.StringOf("Endpoint.PostgreSQLSettings.Username")
Local $sAuthPassword = $oJResp.StringOf("Endpoint.RedisSettings.AuthPassword")
Local $sRedisSettingsAuthType = $oJResp.StringOf("Endpoint.RedisSettings.AuthType")
Local $sAuthUserName = $oJResp.StringOf("Endpoint.RedisSettings.AuthUserName")
Local $iRedisSettingsPort = $oJResp.IntOf("Endpoint.RedisSettings.Port")
Local $sRedisSettingsServerName = $oJResp.StringOf("Endpoint.RedisSettings.ServerName")
Local $sRedisSettingsSslCaCertificateArn = $oJResp.StringOf("Endpoint.RedisSettings.SslCaCertificateArn")
Local $sSslSecurityProtocol = $oJResp.StringOf("Endpoint.RedisSettings.SslSecurityProtocol")
Local $iAcceptAnyDate = $oJResp.IntOf("Endpoint.RedshiftSettings.AcceptAnyDate")
Local $sRedshiftSettingsAfterConnectScript = $oJResp.StringOf("Endpoint.RedshiftSettings.AfterConnectScript")
Local $sBucketFolder = $oJResp.StringOf("Endpoint.RedshiftSettings.BucketFolder")
Local $sRedshiftSettingsBucketName = $oJResp.StringOf("Endpoint.RedshiftSettings.BucketName")
Local $iCaseSensitiveNames = $oJResp.IntOf("Endpoint.RedshiftSettings.CaseSensitiveNames")
Local $iCompUpdate = $oJResp.IntOf("Endpoint.RedshiftSettings.CompUpdate")
Local $iConnectionTimeout = $oJResp.IntOf("Endpoint.RedshiftSettings.ConnectionTimeout")
Local $sRedshiftSettingsDatabaseName = $oJResp.StringOf("Endpoint.RedshiftSettings.DatabaseName")
Local $sDateFormat = $oJResp.StringOf("Endpoint.RedshiftSettings.DateFormat")
Local $iEmptyAsNull = $oJResp.IntOf("Endpoint.RedshiftSettings.EmptyAsNull")
Local $sEncryptionMode = $oJResp.StringOf("Endpoint.RedshiftSettings.EncryptionMode")
Local $iExplicitIds = $oJResp.IntOf("Endpoint.RedshiftSettings.ExplicitIds")
Local $iFileTransferUploadStreams = $oJResp.IntOf("Endpoint.RedshiftSettings.FileTransferUploadStreams")
Local $iLoadTimeout = $oJResp.IntOf("Endpoint.RedshiftSettings.LoadTimeout")
Local $iRedshiftSettingsMaxFileSize = $oJResp.IntOf("Endpoint.RedshiftSettings.MaxFileSize")
Local $sRedshiftSettingsPassword = $oJResp.StringOf("Endpoint.RedshiftSettings.Password")
Local $iRedshiftSettingsPort = $oJResp.IntOf("Endpoint.RedshiftSettings.Port")
Local $iRemoveQuotes = $oJResp.IntOf("Endpoint.RedshiftSettings.RemoveQuotes")
Local $sReplaceChars = $oJResp.StringOf("Endpoint.RedshiftSettings.ReplaceChars")
Local $sReplaceInvalidChars = $oJResp.StringOf("Endpoint.RedshiftSettings.ReplaceInvalidChars")
Local $sRedshiftSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.RedshiftSettings.SecretsManagerAccessRoleArn")
Local $sRedshiftSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.RedshiftSettings.SecretsManagerSecretId")
Local $sRedshiftSettingsServerName = $oJResp.StringOf("Endpoint.RedshiftSettings.ServerName")
Local $sServerSideEncryptionKmsKeyId = $oJResp.StringOf("Endpoint.RedshiftSettings.ServerSideEncryptionKmsKeyId")
Local $sRedshiftSettingsServiceAccessRoleArn = $oJResp.StringOf("Endpoint.RedshiftSettings.ServiceAccessRoleArn")
Local $sTimeFormat = $oJResp.StringOf("Endpoint.RedshiftSettings.TimeFormat")
Local $iTrimBlanks = $oJResp.IntOf("Endpoint.RedshiftSettings.TrimBlanks")
Local $iTruncateColumns = $oJResp.IntOf("Endpoint.RedshiftSettings.TruncateColumns")
Local $sRedshiftSettingsUsername = $oJResp.StringOf("Endpoint.RedshiftSettings.Username")
Local $iWriteBufferSize = $oJResp.IntOf("Endpoint.RedshiftSettings.WriteBufferSize")
Local $iAddColumnName = $oJResp.IntOf("Endpoint.S3Settings.AddColumnName")
Local $sS3SettingsBucketFolder = $oJResp.StringOf("Endpoint.S3Settings.BucketFolder")
Local $sS3SettingsBucketName = $oJResp.StringOf("Endpoint.S3Settings.BucketName")
Local $sCannedAclForObjects = $oJResp.StringOf("Endpoint.S3Settings.CannedAclForObjects")
Local $iCdcInsertsAndUpdates = $oJResp.IntOf("Endpoint.S3Settings.CdcInsertsAndUpdates")
Local $iCdcInsertsOnly = $oJResp.IntOf("Endpoint.S3Settings.CdcInsertsOnly")
Local $iCdcMaxBatchInterval = $oJResp.IntOf("Endpoint.S3Settings.CdcMaxBatchInterval")
Local $iCdcMinFileSize = $oJResp.IntOf("Endpoint.S3Settings.CdcMinFileSize")
Local $sCdcPath = $oJResp.StringOf("Endpoint.S3Settings.CdcPath")
Local $sCompressionType = $oJResp.StringOf("Endpoint.S3Settings.CompressionType")
Local $sCsvDelimiter = $oJResp.StringOf("Endpoint.S3Settings.CsvDelimiter")
Local $sCsvNoSupValue = $oJResp.StringOf("Endpoint.S3Settings.CsvNoSupValue")
Local $sCsvNullValue = $oJResp.StringOf("Endpoint.S3Settings.CsvNullValue")
Local $sCsvRowDelimiter = $oJResp.StringOf("Endpoint.S3Settings.CsvRowDelimiter")
Local $sDataFormat = $oJResp.StringOf("Endpoint.S3Settings.DataFormat")
Local $iDataPageSize = $oJResp.IntOf("Endpoint.S3Settings.DataPageSize")
Local $sDatePartitionDelimiter = $oJResp.StringOf("Endpoint.S3Settings.DatePartitionDelimiter")
Local $iDatePartitionEnabled = $oJResp.IntOf("Endpoint.S3Settings.DatePartitionEnabled")
Local $sDatePartitionSequence = $oJResp.StringOf("Endpoint.S3Settings.DatePartitionSequence")
Local $sDatePartitionTimezone = $oJResp.StringOf("Endpoint.S3Settings.DatePartitionTimezone")
Local $iDictPageSizeLimit = $oJResp.IntOf("Endpoint.S3Settings.DictPageSizeLimit")
Local $iEnableStatistics = $oJResp.IntOf("Endpoint.S3Settings.EnableStatistics")
Local $sEncodingType = $oJResp.StringOf("Endpoint.S3Settings.EncodingType")
Local $sS3SettingsEncryptionMode = $oJResp.StringOf("Endpoint.S3Settings.EncryptionMode")
Local $sS3SettingsExternalTableDefinition = $oJResp.StringOf("Endpoint.S3Settings.ExternalTableDefinition")
Local $iIgnoreHeaderRows = $oJResp.IntOf("Endpoint.S3Settings.IgnoreHeaderRows")
Local $iIncludeOpForFullLoad = $oJResp.IntOf("Endpoint.S3Settings.IncludeOpForFullLoad")
Local $iS3SettingsMaxFileSize = $oJResp.IntOf("Endpoint.S3Settings.MaxFileSize")
Local $iParquetTimestampInMillisecond = $oJResp.IntOf("Endpoint.S3Settings.ParquetTimestampInMillisecond")
Local $sParquetVersion = $oJResp.StringOf("Endpoint.S3Settings.ParquetVersion")
Local $iPreserveTransactions = $oJResp.IntOf("Endpoint.S3Settings.PreserveTransactions")
Local $iRfc4180 = $oJResp.IntOf("Endpoint.S3Settings.Rfc4180")
Local $iRowGroupLength = $oJResp.IntOf("Endpoint.S3Settings.RowGroupLength")
Local $sS3SettingsServerSideEncryptionKmsKeyId = $oJResp.StringOf("Endpoint.S3Settings.ServerSideEncryptionKmsKeyId")
Local $sS3SettingsServiceAccessRoleArn = $oJResp.StringOf("Endpoint.S3Settings.ServiceAccessRoleArn")
Local $sTimestampColumnName = $oJResp.StringOf("Endpoint.S3Settings.TimestampColumnName")
Local $iUseCsvNoSupValue = $oJResp.IntOf("Endpoint.S3Settings.UseCsvNoSupValue")
Local $iUseTaskStartTimeForFullLoadTimestamp = $oJResp.IntOf("Endpoint.S3Settings.UseTaskStartTimeForFullLoadTimestamp")
Local $sEndpointServerName = $oJResp.StringOf("Endpoint.ServerName")
Local $sEndpointServiceAccessRoleArn = $oJResp.StringOf("Endpoint.ServiceAccessRoleArn")
Local $sSslMode = $oJResp.StringOf("Endpoint.SslMode")
Local $sStatus = $oJResp.StringOf("Endpoint.Status")
Local $sSybaseSettingsDatabaseName = $oJResp.StringOf("Endpoint.SybaseSettings.DatabaseName")
Local $sSybaseSettingsPassword = $oJResp.StringOf("Endpoint.SybaseSettings.Password")
Local $iSybaseSettingsPort = $oJResp.IntOf("Endpoint.SybaseSettings.Port")
Local $sSybaseSettingsSecretsManagerAccessRoleArn = $oJResp.StringOf("Endpoint.SybaseSettings.SecretsManagerAccessRoleArn")
Local $sSybaseSettingsSecretsManagerSecretId = $oJResp.StringOf("Endpoint.SybaseSettings.SecretsManagerSecretId")
Local $sSybaseSettingsServerName = $oJResp.StringOf("Endpoint.SybaseSettings.ServerName")
Local $sSybaseSettingsUsername = $oJResp.StringOf("Endpoint.SybaseSettings.Username")
Local $sEndpointUsername = $oJResp.StringOf("Endpoint.Username")
Local $i = 0
Local $iCount_i = $oJResp.SizeOfArray("Endpoint.OracleSettings.ExtraArchivedLogDestIds")
While $i < $iCount_i
$oJResp.I = $i
$intVal = $oJResp.IntOf("Endpoint.OracleSettings.ExtraArchivedLogDestIds[i]")
$i = $i + 1
Wend
; 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"
; }
; }