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