We recommend new projects start with resources from the AWS provider.
Viewing docs for AWS Cloud Control v1.76.0
published on Monday, Aug 24, 2026 by Pulumi
published on Monday, Aug 24, 2026 by Pulumi
We recommend new projects start with resources from the AWS provider.
Viewing docs for AWS Cloud Control v1.76.0
published on Monday, Aug 24, 2026 by Pulumi
published on Monday, Aug 24, 2026 by Pulumi
Resource Type definition for AWS::DMS::Endpoint
Using getEndpoint
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getEndpoint(args: GetEndpointArgs, opts?: InvokeOptions): Promise<GetEndpointResult>
function getEndpointOutput(args: GetEndpointOutputArgs, opts?: InvokeOutputOptions): Output<GetEndpointResult>def get_endpoint(endpoint_arn: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetEndpointResult
def get_endpoint_output(endpoint_arn: pulumi.Input[Optional[str]] = None,
opts: Optional[InvokeOutputOptions] = None) -> Output[GetEndpointResult]func LookupEndpoint(ctx *Context, args *LookupEndpointArgs, opts ...InvokeOption) (*LookupEndpointResult, error)
func LookupEndpointOutput(ctx *Context, args *LookupEndpointOutputArgs, opts ...InvokeOption) LookupEndpointResultOutput> Note: This function is named LookupEndpoint in the Go SDK.
public static class GetEndpoint
{
public static Task<GetEndpointResult> InvokeAsync(GetEndpointArgs args, InvokeOptions? opts = null)
public static Output<GetEndpointResult> Invoke(GetEndpointInvokeArgs args, InvokeOptions? opts = null)
public static Output<GetEndpointResult> Invoke(GetEndpointInvokeArgs args, InvokeOutputOptions opts)
}public static CompletableFuture<GetEndpointResult> getEndpoint(GetEndpointArgs args, InvokeOptions options)
public static Output<GetEndpointResult> getEndpoint(GetEndpointArgs args, InvokeOptions options)
public static Output<GetEndpointResult> getEndpoint(GetEndpointArgs args, InvokeOutputOptions options)
fn::invoke:
function: aws-native:dms:getEndpoint
arguments:
# arguments dictionarydata "aws-native_dms_get_endpoint" "name" {
# arguments
}The following arguments are supported:
- Endpoint
Arn string - The endpoint ARN.
- Endpoint
Arn string - The endpoint ARN.
- endpoint_
arn string - The endpoint ARN.
- endpoint
Arn String - The endpoint ARN.
- endpoint
Arn string - The endpoint ARN.
- endpoint_
arn str - The endpoint ARN.
- endpoint
Arn String - The endpoint ARN.
getEndpoint Result
The following output properties are available:
- Certificate
Arn string - The Amazon Resource Name (ARN) for the certificate.
- Database
Name string - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- Doc
Db Pulumi.Settings Aws Native. Dms. Outputs. Endpoint Doc Db Settings - Settings in JSON format for the source and target DocumentDB endpoint
- Dynamo
Db Pulumi.Settings Aws Native. Dms. Outputs. Endpoint Dynamo Db Settings - Settings in JSON format for the target Amazon DynamoDB endpoint
- Elasticsearch
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Elasticsearch Settings - Settings in JSON format for the target OpenSearch endpoint
- Endpoint
Arn string - The endpoint ARN.
- Endpoint
Identifier string - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- Endpoint
Type string - The type of endpoint. Valid values are source and target.
- Engine
Name string - The type of engine for the endpoint, depending on the EndpointType value.
- External
Id string - A value that can be used for cross-account validation.
- Gcp
My Pulumi.Sql Settings Aws Native. Dms. Outputs. Endpoint Gcp My Sql Settings - Settings in JSON format for the source GCP MySQL endpoint
- Ibm
Db2Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Ibm Db2Settings - Settings in JSON format for the source IBM Db2 LUW endpoint
- Kafka
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Kafka Settings - Settings in JSON format for the target Apache Kafka endpoint
- Kinesis
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Kinesis Settings - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- Microsoft
Sql Pulumi.Server Settings Aws Native. Dms. Outputs. Endpoint Microsoft Sql Server Settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- Mongo
Db Pulumi.Settings Aws Native. Dms. Outputs. Endpoint Mongo Db Settings - Settings in JSON format for the source MongoDB endpoint
- My
Sql Pulumi.Settings Aws Native. Dms. Outputs. Endpoint My Sql Settings - Settings in JSON format for the source and target MySQL endpoin
- Neptune
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Neptune Settings - Settings in JSON format for the target Amazon Neptune endpoint
- Oracle
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Oracle Settings - Settings in JSON format for the source and target Oracle endpoint
- Port int
- The port used by the endpoint database.
- Postgre
Sql Pulumi.Settings Aws Native. Dms. Outputs. Endpoint Postgre Sql Settings - Settings in JSON format for the source and target PostgreSQL endpoint.
- Redis
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Redis Settings - Settings in JSON format for the target Redis endpoint
- Redshift
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Redshift Settings - Settings in JSON format for the Amazon Redshift endpoint.
- S3Settings
Pulumi.
Aws Native. Dms. Outputs. Endpoint S3Settings - Settings in JSON format for the source and target Amazon S3 endpoint
- Server
Name string - The name of the server where the endpoint database resides.
- Ssl
Mode string - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- Sybase
Settings Pulumi.Aws Native. Dms. Outputs. Endpoint Sybase Settings - Settings in JSON format for the source and target SAP ASE endpoint.
-
List<Pulumi.
Aws Native. Outputs. Tag> - One or more tags to be assigned to the endpoint.
- Username string
- The user name to be used to log in to the endpoint database.
- Certificate
Arn string - The Amazon Resource Name (ARN) for the certificate.
- Database
Name string - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- Doc
Db EndpointSettings Doc Db Settings - Settings in JSON format for the source and target DocumentDB endpoint
- Dynamo
Db EndpointSettings Dynamo Db Settings - Settings in JSON format for the target Amazon DynamoDB endpoint
- Elasticsearch
Settings EndpointElasticsearch Settings - Settings in JSON format for the target OpenSearch endpoint
- Endpoint
Arn string - The endpoint ARN.
- Endpoint
Identifier string - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- Endpoint
Type string - The type of endpoint. Valid values are source and target.
- Engine
Name string - The type of engine for the endpoint, depending on the EndpointType value.
- External
Id string - A value that can be used for cross-account validation.
- Gcp
My EndpointSql Settings Gcp My Sql Settings - Settings in JSON format for the source GCP MySQL endpoint
- Ibm
Db2Settings EndpointIbm Db2Settings - Settings in JSON format for the source IBM Db2 LUW endpoint
- Kafka
Settings EndpointKafka Settings - Settings in JSON format for the target Apache Kafka endpoint
- Kinesis
Settings EndpointKinesis Settings - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- Microsoft
Sql EndpointServer Settings Microsoft Sql Server Settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- Mongo
Db EndpointSettings Mongo Db Settings - Settings in JSON format for the source MongoDB endpoint
- My
Sql EndpointSettings My Sql Settings - Settings in JSON format for the source and target MySQL endpoin
- Neptune
Settings EndpointNeptune Settings - Settings in JSON format for the target Amazon Neptune endpoint
- Oracle
Settings EndpointOracle Settings - Settings in JSON format for the source and target Oracle endpoint
- Port int
- The port used by the endpoint database.
- Postgre
Sql EndpointSettings Postgre Sql Settings - Settings in JSON format for the source and target PostgreSQL endpoint.
- Redis
Settings EndpointRedis Settings - Settings in JSON format for the target Redis endpoint
- Redshift
Settings EndpointRedshift Settings - Settings in JSON format for the Amazon Redshift endpoint.
- S3Settings
Endpoint
S3Settings - Settings in JSON format for the source and target Amazon S3 endpoint
- Server
Name string - The name of the server where the endpoint database resides.
- Ssl
Mode string - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- Sybase
Settings EndpointSybase Settings - Settings in JSON format for the source and target SAP ASE endpoint.
- Tag
- One or more tags to be assigned to the endpoint.
- Username string
- The user name to be used to log in to the endpoint database.
- certificate_
arn string - The Amazon Resource Name (ARN) for the certificate.
- database_
name string - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- doc_
db_ objectsettings - Settings in JSON format for the source and target DocumentDB endpoint
- dynamo_
db_ objectsettings - Settings in JSON format for the target Amazon DynamoDB endpoint
- elasticsearch_
settings object - Settings in JSON format for the target OpenSearch endpoint
- endpoint_
arn string - The endpoint ARN.
- endpoint_
identifier string - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- endpoint_
type string - The type of endpoint. Valid values are source and target.
- engine_
name string - The type of engine for the endpoint, depending on the EndpointType value.
- external_
id string - A value that can be used for cross-account validation.
- gcp_
my_ objectsql_ settings - Settings in JSON format for the source GCP MySQL endpoint
- ibm_
db2_ objectsettings - Settings in JSON format for the source IBM Db2 LUW endpoint
- kafka_
settings object - Settings in JSON format for the target Apache Kafka endpoint
- kinesis_
settings object - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- microsoft_
sql_ objectserver_ settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- mongo_
db_ objectsettings - Settings in JSON format for the source MongoDB endpoint
- my_
sql_ objectsettings - Settings in JSON format for the source and target MySQL endpoin
- neptune_
settings object - Settings in JSON format for the target Amazon Neptune endpoint
- oracle_
settings object - Settings in JSON format for the source and target Oracle endpoint
- port number
- The port used by the endpoint database.
- postgre_
sql_ objectsettings - Settings in JSON format for the source and target PostgreSQL endpoint.
- redis_
settings object - Settings in JSON format for the target Redis endpoint
- redshift_
settings object - Settings in JSON format for the Amazon Redshift endpoint.
- s3_
settings object - Settings in JSON format for the source and target Amazon S3 endpoint
- server_
name string - The name of the server where the endpoint database resides.
- ssl_
mode string - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- sybase_
settings object - Settings in JSON format for the source and target SAP ASE endpoint.
- list(object)
- One or more tags to be assigned to the endpoint.
- username string
- The user name to be used to log in to the endpoint database.
- certificate
Arn String - The Amazon Resource Name (ARN) for the certificate.
- database
Name String - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- doc
Db EndpointSettings Doc Db Settings - Settings in JSON format for the source and target DocumentDB endpoint
- dynamo
Db EndpointSettings Dynamo Db Settings - Settings in JSON format for the target Amazon DynamoDB endpoint
- elasticsearch
Settings EndpointElasticsearch Settings - Settings in JSON format for the target OpenSearch endpoint
- endpoint
Arn String - The endpoint ARN.
- endpoint
Identifier String - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- endpoint
Type String - The type of endpoint. Valid values are source and target.
- engine
Name String - The type of engine for the endpoint, depending on the EndpointType value.
- external
Id String - A value that can be used for cross-account validation.
- gcp
My EndpointSql Settings Gcp My Sql Settings - Settings in JSON format for the source GCP MySQL endpoint
- ibm
Db2Settings EndpointIbm Db2Settings - Settings in JSON format for the source IBM Db2 LUW endpoint
- kafka
Settings EndpointKafka Settings - Settings in JSON format for the target Apache Kafka endpoint
- kinesis
Settings EndpointKinesis Settings - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- microsoft
Sql EndpointServer Settings Microsoft Sql Server Settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- mongo
Db EndpointSettings Mongo Db Settings - Settings in JSON format for the source MongoDB endpoint
- my
Sql EndpointSettings My Sql Settings - Settings in JSON format for the source and target MySQL endpoin
- neptune
Settings EndpointNeptune Settings - Settings in JSON format for the target Amazon Neptune endpoint
- oracle
Settings EndpointOracle Settings - Settings in JSON format for the source and target Oracle endpoint
- port Integer
- The port used by the endpoint database.
- postgre
Sql EndpointSettings Postgre Sql Settings - Settings in JSON format for the source and target PostgreSQL endpoint.
- redis
Settings EndpointRedis Settings - Settings in JSON format for the target Redis endpoint
- redshift
Settings EndpointRedshift Settings - Settings in JSON format for the Amazon Redshift endpoint.
- s3Settings
Endpoint
S3Settings - Settings in JSON format for the source and target Amazon S3 endpoint
- server
Name String - The name of the server where the endpoint database resides.
- ssl
Mode String - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- sybase
Settings EndpointSybase Settings - Settings in JSON format for the source and target SAP ASE endpoint.
- List<Tag>
- One or more tags to be assigned to the endpoint.
- username String
- The user name to be used to log in to the endpoint database.
- certificate
Arn string - The Amazon Resource Name (ARN) for the certificate.
- database
Name string - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- doc
Db EndpointSettings Doc Db Settings - Settings in JSON format for the source and target DocumentDB endpoint
- dynamo
Db EndpointSettings Dynamo Db Settings - Settings in JSON format for the target Amazon DynamoDB endpoint
- elasticsearch
Settings EndpointElasticsearch Settings - Settings in JSON format for the target OpenSearch endpoint
- endpoint
Arn string - The endpoint ARN.
- endpoint
Identifier string - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- endpoint
Type string - The type of endpoint. Valid values are source and target.
- engine
Name string - The type of engine for the endpoint, depending on the EndpointType value.
- external
Id string - A value that can be used for cross-account validation.
- gcp
My EndpointSql Settings Gcp My Sql Settings - Settings in JSON format for the source GCP MySQL endpoint
- ibm
Db2Settings EndpointIbm Db2Settings - Settings in JSON format for the source IBM Db2 LUW endpoint
- kafka
Settings EndpointKafka Settings - Settings in JSON format for the target Apache Kafka endpoint
- kinesis
Settings EndpointKinesis Settings - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- microsoft
Sql EndpointServer Settings Microsoft Sql Server Settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- mongo
Db EndpointSettings Mongo Db Settings - Settings in JSON format for the source MongoDB endpoint
- my
Sql EndpointSettings My Sql Settings - Settings in JSON format for the source and target MySQL endpoin
- neptune
Settings EndpointNeptune Settings - Settings in JSON format for the target Amazon Neptune endpoint
- oracle
Settings EndpointOracle Settings - Settings in JSON format for the source and target Oracle endpoint
- port number
- The port used by the endpoint database.
- postgre
Sql EndpointSettings Postgre Sql Settings - Settings in JSON format for the source and target PostgreSQL endpoint.
- redis
Settings EndpointRedis Settings - Settings in JSON format for the target Redis endpoint
- redshift
Settings EndpointRedshift Settings - Settings in JSON format for the Amazon Redshift endpoint.
- s3Settings
Endpoint
S3Settings - Settings in JSON format for the source and target Amazon S3 endpoint
- server
Name string - The name of the server where the endpoint database resides.
- ssl
Mode string - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- sybase
Settings EndpointSybase Settings - Settings in JSON format for the source and target SAP ASE endpoint.
- Tag[]
- One or more tags to be assigned to the endpoint.
- username string
- The user name to be used to log in to the endpoint database.
- certificate_
arn str - The Amazon Resource Name (ARN) for the certificate.
- database_
name str - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- doc_
db_ Endpointsettings Doc Db Settings - Settings in JSON format for the source and target DocumentDB endpoint
- dynamo_
db_ Endpointsettings Dynamo Db Settings - Settings in JSON format for the target Amazon DynamoDB endpoint
- elasticsearch_
settings EndpointElasticsearch Settings - Settings in JSON format for the target OpenSearch endpoint
- endpoint_
arn str - The endpoint ARN.
- endpoint_
identifier str - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- endpoint_
type str - The type of endpoint. Valid values are source and target.
- engine_
name str - The type of engine for the endpoint, depending on the EndpointType value.
- external_
id str - A value that can be used for cross-account validation.
- gcp_
my_ Endpointsql_ settings Gcp My Sql Settings - Settings in JSON format for the source GCP MySQL endpoint
- ibm_
db2_ Endpointsettings Ibm Db2Settings - Settings in JSON format for the source IBM Db2 LUW endpoint
- kafka_
settings EndpointKafka Settings - Settings in JSON format for the target Apache Kafka endpoint
- kinesis_
settings EndpointKinesis Settings - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- microsoft_
sql_ Endpointserver_ settings Microsoft Sql Server Settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- mongo_
db_ Endpointsettings Mongo Db Settings - Settings in JSON format for the source MongoDB endpoint
- my_
sql_ Endpointsettings My Sql Settings - Settings in JSON format for the source and target MySQL endpoin
- neptune_
settings EndpointNeptune Settings - Settings in JSON format for the target Amazon Neptune endpoint
- oracle_
settings EndpointOracle Settings - Settings in JSON format for the source and target Oracle endpoint
- port int
- The port used by the endpoint database.
- postgre_
sql_ Endpointsettings Postgre Sql Settings - Settings in JSON format for the source and target PostgreSQL endpoint.
- redis_
settings EndpointRedis Settings - Settings in JSON format for the target Redis endpoint
- redshift_
settings EndpointRedshift Settings - Settings in JSON format for the Amazon Redshift endpoint.
- s3_
settings EndpointS3Settings - Settings in JSON format for the source and target Amazon S3 endpoint
- server_
name str - The name of the server where the endpoint database resides.
- ssl_
mode str - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- sybase_
settings EndpointSybase Settings - Settings in JSON format for the source and target SAP ASE endpoint.
- Sequence[root_Tag]
- One or more tags to be assigned to the endpoint.
- username str
- The user name to be used to log in to the endpoint database.
- certificate
Arn String - The Amazon Resource Name (ARN) for the certificate.
- database
Name String - The name of the endpoint database. For a MySQL source or target endpoint, don't specify DatabaseName. To migrate to a specific database, use this setting and targetDbType.
- doc
Db Property MapSettings - Settings in JSON format for the source and target DocumentDB endpoint
- dynamo
Db Property MapSettings - Settings in JSON format for the target Amazon DynamoDB endpoint
- elasticsearch
Settings Property Map - Settings in JSON format for the target OpenSearch endpoint
- endpoint
Arn String - The endpoint ARN.
- endpoint
Identifier String - The database endpoint identifier. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.
- endpoint
Type String - The type of endpoint. Valid values are source and target.
- engine
Name String - The type of engine for the endpoint, depending on the EndpointType value.
- external
Id String - A value that can be used for cross-account validation.
- gcp
My Property MapSql Settings - Settings in JSON format for the source GCP MySQL endpoint
- ibm
Db2Settings Property Map - Settings in JSON format for the source IBM Db2 LUW endpoint
- kafka
Settings Property Map - Settings in JSON format for the target Apache Kafka endpoint
- kinesis
Settings Property Map - Settings in JSON format for the target endpoint for Amazon Kinesis Data Streams
- microsoft
Sql Property MapServer Settings - Settings in JSON format for the source and target Microsoft SQL Server endpoint
- mongo
Db Property MapSettings - Settings in JSON format for the source MongoDB endpoint
- my
Sql Property MapSettings - Settings in JSON format for the source and target MySQL endpoin
- neptune
Settings Property Map - Settings in JSON format for the target Amazon Neptune endpoint
- oracle
Settings Property Map - Settings in JSON format for the source and target Oracle endpoint
- port Number
- The port used by the endpoint database.
- postgre
Sql Property MapSettings - Settings in JSON format for the source and target PostgreSQL endpoint.
- redis
Settings Property Map - Settings in JSON format for the target Redis endpoint
- redshift
Settings Property Map - Settings in JSON format for the Amazon Redshift endpoint.
- s3Settings Property Map
- Settings in JSON format for the source and target Amazon S3 endpoint
- server
Name String - The name of the server where the endpoint database resides.
- ssl
Mode String - The Secure Sockets Layer (SSL) mode to use for the SSL connection. The default is none.
- sybase
Settings Property Map - Settings in JSON format for the source and target SAP ASE endpoint.
- List<Property Map>
- One or more tags to be assigned to the endpoint.
- username String
- The user name to be used to log in to the endpoint database.
Supporting Types
EndpointDocDbSettings
- Docs
To intInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- Extract
Doc boolId - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- Nesting
Level string - Specifies either document or table mode.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- Secrets
Manager stringSecret Id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- Docs
To intInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- Extract
Doc boolId - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- Nesting
Level string - Specifies either document or table mode.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- Secrets
Manager stringSecret Id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- docs_
to_ numberinvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract_
doc_ boolid - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- nesting_
level string - Specifies either document or table mode.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- secrets_
manager_ stringsecret_ id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- docs
To IntegerInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract
Doc BooleanId - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- nesting
Level String - Specifies either document or table mode.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- secrets
Manager StringSecret Id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- docs
To numberInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract
Doc booleanId - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- nesting
Level string - Specifies either document or table mode.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- secrets
Manager stringSecret Id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- docs_
to_ intinvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract_
doc_ boolid - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- nesting_
level str - Specifies either document or table mode.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- secrets_
manager_ strsecret_ id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- docs
To NumberInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract
Doc BooleanId - Specifies the document ID. Use this setting when NestingLevel is set to "none"
- nesting
Level String - Specifies either document or table mode.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
- secrets
Manager StringSecret Id - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the DocumentDB endpoint.
EndpointDynamoDbSettings
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- service_
access_ stringrole_ arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- service
Access stringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- service_
access_ strrole_ arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
EndpointElasticsearchSettings
- Endpoint
Uri string - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- Error
Retry intDuration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- Full
Load intError Percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- Endpoint
Uri string - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- Error
Retry intDuration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- Full
Load intError Percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- endpoint_
uri string - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- error_
retry_ numberduration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- full_
load_ numbererror_ percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- service_
access_ stringrole_ arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- endpoint
Uri String - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- error
Retry IntegerDuration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- full
Load IntegerError Percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- endpoint
Uri string - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- error
Retry numberDuration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- full
Load numberError Percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- service
Access stringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- endpoint_
uri str - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- error_
retry_ intduration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- full_
load_ interror_ percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- service_
access_ strrole_ arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
- endpoint
Uri String - The endpoint for the OpenSearch cluster. AWS DMS uses HTTPS if a transport protocol (either HTTP or HTTPS) isn't specified.
- error
Retry NumberDuration - The maximum number of seconds for which DMS retries failed API requests to the OpenSearch cluster.
- full
Load NumberError Percentage - The maximum percentage of records that can fail to be written before a full load operation stops.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) used by the service to access the IAM role. The role must allow the iam:PassRole action.
EndpointGcpMySqlSettings
- After
Connect stringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- Clean
Source boolMetadata On Mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- Database
Name string - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- Events
Poll intInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- Max
File intSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- Parallel
Load intThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- Password string
- Endpoint connection password.
- Port int
- The port used by the endpoint database.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- Server
Name string - The MySQL host name.
- Server
Timezone string - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- Username string
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- After
Connect stringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- Clean
Source boolMetadata On Mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- Database
Name string - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- Events
Poll intInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- Max
File intSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- Parallel
Load intThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- Password string
- Endpoint connection password.
- Port int
- The port used by the endpoint database.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- Server
Name string - The MySQL host name.
- Server
Timezone string - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- Username string
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- after_
connect_ stringscript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean_
source_ boolmetadata_ on_ mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- database_
name string - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- events_
poll_ numberinterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max_
file_ numbersize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel_
load_ numberthreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- password string
- Endpoint connection password.
- port number
- The port used by the endpoint database.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server_
name string - The MySQL host name.
- server_
timezone string - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- username string
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- after
Connect StringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean
Source BooleanMetadata On Mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- database
Name String - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- events
Poll IntegerInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max
File IntegerSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel
Load IntegerThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- password String
- Endpoint connection password.
- port Integer
- The port used by the endpoint database.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server
Name String - The MySQL host name.
- server
Timezone String - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- username String
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- after
Connect stringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean
Source booleanMetadata On Mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- database
Name string - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- events
Poll numberInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max
File numberSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel
Load numberThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- password string
- Endpoint connection password.
- port number
- The port used by the endpoint database.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server
Name string - The MySQL host name.
- server
Timezone string - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- username string
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- after_
connect_ strscript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean_
source_ boolmetadata_ on_ mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- database_
name str - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- events_
poll_ intinterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max_
file_ intsize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel_
load_ intthreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- password str
- Endpoint connection password.
- port int
- The port used by the endpoint database.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server_
name str - The MySQL host name.
- server_
timezone str - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- username str
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- after
Connect StringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean
Source BooleanMetadata On Mismatch - Adjusts the behavior of AWS DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster. If you need AWS DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false.
- database
Name String - Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName request parameter on either the CreateEndpoint or ModifyEndpoint API call. Specifying DatabaseName when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the AWS DMS task.
- events
Poll NumberInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max
File NumberSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel
Load NumberThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
- password String
- Endpoint connection password.
- port Number
- The port used by the endpoint database.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server
Name String - The MySQL host name.
- server
Timezone String - Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
- username String
- Specifies the time zone for the source MySQL database. Don't enclose time zones in single quotation marks.
EndpointIbmDb2Settings
- Current
Lsn string - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- Keep
Csv boolFiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- Load
Timeout int - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- Max
File intSize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- Max
KBytes intPer Read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- Set
Data boolCapture Changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- Write
Buffer intSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
- Current
Lsn string - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- Keep
Csv boolFiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- Load
Timeout int - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- Max
File intSize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- Max
KBytes intPer Read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- Set
Data boolCapture Changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- Write
Buffer intSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
- current_
lsn string - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- keep_
csv_ boolfiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- load_
timeout number - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- max_
file_ numbersize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- max_
k_ numberbytes_ per_ read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- set_
data_ boolcapture_ changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- write_
buffer_ numbersize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
- current
Lsn String - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- keep
Csv BooleanFiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- load
Timeout Integer - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- max
File IntegerSize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- max
KBytes IntegerPer Read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- set
Data BooleanCapture Changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- write
Buffer IntegerSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
- current
Lsn string - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- keep
Csv booleanFiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- load
Timeout number - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- max
File numberSize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- max
KBytes numberPer Read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- set
Data booleanCapture Changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- write
Buffer numberSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
- current_
lsn str - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- keep_
csv_ boolfiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- load_
timeout int - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- max_
file_ intsize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- max_
k_ intbytes_ per_ read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- set_
data_ boolcapture_ changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- write_
buffer_ intsize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
- current
Lsn String - For ongoing replication (CDC), use CurrentLSN to specify a log sequence number (LSN) where you want the replication to start.
- keep
Csv BooleanFiles - If true, AWS DMS saves any .csv files to the Db2 LUW target that were used to replicate data. DMS uses these files for analysis and troubleshooting.
- load
Timeout Number - The amount of time (in milliseconds) before AWS DMS times out operations performed by DMS on the Db2 target. The default value is 1200 (20 minutes).
- max
File NumberSize - Specifies the maximum size (in KB) of .csv files used to transfer data to Db2 LUW.
- max
KBytes NumberPer Read - Maximum number of bytes per read, as a NUMBER value. The default is 64 KB.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret. The role must allow the iam:PassRole action. SecretsManagerSecret has the value ofthe AWS Secrets Manager secret that allows access to the Db2 LUW endpoint.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the IBMDB2 endpoint connection details.
- set
Data BooleanCapture Changes - Enables ongoing replication (CDC) as a BOOLEAN value. The default is true.
- write
Buffer NumberSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk on the DMS replication instance. The default value is 1024 (1 MB).
EndpointKafkaSettings
- Broker string
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- Include
Control boolDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- Include
Null boolAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- Include
Partition boolValue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- Include
Table boolAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- Include
Transaction boolDetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- Message
Format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- Message
Max intBytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- No
Hex boolPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- Partition
Include boolSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- Sasl
Password string - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- Sasl
User stringName - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- Security
Protocol string - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- Ssl
Ca stringCertificate Arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- Ssl
Client stringCertificate Arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- Ssl
Client stringKey Arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- Ssl
Client stringKey Password - The password for the client private key used to securely connect to a Kafka target endpoint.
- Topic string
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
- Broker string
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- Include
Control boolDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- Include
Null boolAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- Include
Partition boolValue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- Include
Table boolAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- Include
Transaction boolDetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- Message
Format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- Message
Max intBytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- No
Hex boolPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- Partition
Include boolSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- Sasl
Password string - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- Sasl
User stringName - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- Security
Protocol string - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- Ssl
Ca stringCertificate Arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- Ssl
Client stringCertificate Arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- Ssl
Client stringKey Arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- Ssl
Client stringKey Password - The password for the client private key used to securely connect to a Kafka target endpoint.
- Topic string
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
- broker string
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- include_
control_ booldetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- include_
null_ booland_ empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include_
partition_ boolvalue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- include_
table_ boolalter_ operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include_
transaction_ booldetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- message_
format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- message_
max_ numberbytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- no_
hex_ boolprefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- partition_
include_ boolschema_ table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- sasl_
password string - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- sasl_
user_ stringname - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- security_
protocol string - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- ssl_
ca_ stringcertificate_ arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- ssl_
client_ stringcertificate_ arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- ssl_
client_ stringkey_ arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- ssl_
client_ stringkey_ password - The password for the client private key used to securely connect to a Kafka target endpoint.
- topic string
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
- broker String
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- include
Control BooleanDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- include
Null BooleanAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include
Partition BooleanValue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- include
Table BooleanAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include
Transaction BooleanDetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- message
Format String - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- message
Max IntegerBytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- no
Hex BooleanPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- partition
Include BooleanSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- sasl
Password String - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- sasl
User StringName - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- security
Protocol String - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- ssl
Ca StringCertificate Arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- ssl
Client StringCertificate Arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- ssl
Client StringKey Arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- ssl
Client StringKey Password - The password for the client private key used to securely connect to a Kafka target endpoint.
- topic String
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
- broker string
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- include
Control booleanDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- include
Null booleanAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include
Partition booleanValue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- include
Table booleanAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include
Transaction booleanDetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- message
Format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- message
Max numberBytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- no
Hex booleanPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- partition
Include booleanSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- sasl
Password string - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- sasl
User stringName - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- security
Protocol string - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- ssl
Ca stringCertificate Arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- ssl
Client stringCertificate Arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- ssl
Client stringKey Arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- ssl
Client stringKey Password - The password for the client private key used to securely connect to a Kafka target endpoint.
- topic string
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
- broker str
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- include_
control_ booldetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- include_
null_ booland_ empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include_
partition_ boolvalue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- include_
table_ boolalter_ operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include_
transaction_ booldetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- message_
format str - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- message_
max_ intbytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- no_
hex_ boolprefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- partition_
include_ boolschema_ table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- sasl_
password str - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- sasl_
user_ strname - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- security_
protocol str - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- ssl_
ca_ strcertificate_ arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- ssl_
client_ strcertificate_ arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- ssl_
client_ strkey_ arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- ssl_
client_ strkey_ password - The password for the client private key used to securely connect to a Kafka target endpoint.
- topic str
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
- broker String
- A comma-separated list of one or more broker locations in your Kafka cluster that host your Kafka instance. Specify each broker location in the form broker-hostname-or-ip:port
- include
Control BooleanDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kafka message output. The default is false.
- include
Null BooleanAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include
Partition BooleanValue - Shows the partition value within the Kafka message output unless the partition type is schema-table-type. The default is false.
- include
Table BooleanAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include
Transaction BooleanDetails - Provides detailed transaction information from the source database. This information includes a commit timestamp, a log position, and values for transaction_id, previous transaction_id, and transaction_record_id (the record offset within a transaction). The default is false.
- message
Format String - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- message
Max NumberBytes - The maximum size in bytes for records created on the endpoint The default is 1,000,000.
- no
Hex BooleanPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format. For example, by default, AWS DMS adds a '0x' prefix to the LOB column type in hexadecimal format moving from an Oracle source to a Kafka target. Use the NoHexPrefix endpoint setting to enable migration of RAW data type columns without adding the '0x' prefix.
- partition
Include BooleanSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- sasl
Password String - The secure password that you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- sasl
User StringName - The secure user name you created when you first set up your Amazon MSK cluster to validate a client identity and make an encrypted connection between server and client using SASL-SSL authentication.
- security
Protocol String - Set secure connection to a Kafka target endpoint using Transport Layer Security (TLS). Options include ssl-encryption, ssl-authentication, and sasl-ssl. sasl-ssl requires SaslUsername and SaslPassword.
- ssl
Ca StringCertificate Arn - The Amazon Resource Name (ARN) for the private certificate authority (CA) cert that AWS DMS uses to securely connect to your Kafka target endpoint.
- ssl
Client StringCertificate Arn - The Amazon Resource Name (ARN) of the client certificate used to securely connect to a Kafka target endpoint.
- ssl
Client StringKey Arn - The Amazon Resource Name (ARN) for the client private key used to securely connect to a Kafka target endpoint.
- ssl
Client StringKey Password - The password for the client private key used to securely connect to a Kafka target endpoint.
- topic String
- The topic to which you migrate the data. If you don't specify a topic, AWS DMS specifies "kafka-default-topic" as the migration topic.
EndpointKinesisSettings
- Include
Control boolDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- Include
Null boolAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- Include
Partition boolValue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- Include
Table boolAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- Include
Transaction boolDetails - Provides detailed transaction information from the source database.
- Message
Format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- No
Hex boolPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- Partition
Include boolSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- Stream
Arn string - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
- Include
Control boolDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- Include
Null boolAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- Include
Partition boolValue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- Include
Table boolAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- Include
Transaction boolDetails - Provides detailed transaction information from the source database.
- Message
Format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- No
Hex boolPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- Partition
Include boolSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- Stream
Arn string - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
- include_
control_ booldetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- include_
null_ booland_ empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include_
partition_ boolvalue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- include_
table_ boolalter_ operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include_
transaction_ booldetails - Provides detailed transaction information from the source database.
- message_
format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- no_
hex_ boolprefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- partition_
include_ boolschema_ table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- service_
access_ stringrole_ arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- stream_
arn string - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
- include
Control BooleanDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- include
Null BooleanAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include
Partition BooleanValue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- include
Table BooleanAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include
Transaction BooleanDetails - Provides detailed transaction information from the source database.
- message
Format String - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- no
Hex BooleanPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- partition
Include BooleanSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- stream
Arn String - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
- include
Control booleanDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- include
Null booleanAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include
Partition booleanValue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- include
Table booleanAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include
Transaction booleanDetails - Provides detailed transaction information from the source database.
- message
Format string - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- no
Hex booleanPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- partition
Include booleanSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- service
Access stringRole Arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- stream
Arn string - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
- include_
control_ booldetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- include_
null_ booland_ empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include_
partition_ boolvalue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- include_
table_ boolalter_ operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include_
transaction_ booldetails - Provides detailed transaction information from the source database.
- message_
format str - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- no_
hex_ boolprefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- partition_
include_ boolschema_ table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- service_
access_ strrole_ arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- stream_
arn str - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
- include
Control BooleanDetails - Shows detailed control information for table definition, column definition, and table and column changes in the Kinesis message output. The default is false.
- include
Null BooleanAnd Empty - Include NULL and empty columns for records migrated to the endpoint. The default is false.
- include
Partition BooleanValue - Shows the partition value within the Kinesis message output, unless the partition type is schema-table-type. The default is false.
- include
Table BooleanAlter Operations - Includes any data definition language (DDL) operations that change the table in the control data, such as rename-table, drop-table, add-column, drop-column, and rename-column. The default is false.
- include
Transaction BooleanDetails - Provides detailed transaction information from the source database.
- message
Format String - The output format for the records created on the endpoint. The message format is JSON (default) or JSON_UNFORMATTED (a single line with no tab).
- no
Hex BooleanPrefix - Set this optional parameter to true to avoid adding a '0x' prefix to raw data in hexadecimal format.
- partition
Include BooleanSchema Table - Prefixes schema and table names to partition values, when the partition type is primary-key-type.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) for the IAM role that AWS DMS uses to write to the Kinesis data stream. The role must allow the iam:PassRole action.
- stream
Arn String - The Amazon Resource Name (ARN) for the Amazon Kinesis Data Streams endpoint.
EndpointMicrosoftSqlServerSettings
- Bcp
Packet intSize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- Control
Tables stringFile Group - Specifies a file group for the AWS DMS internal tables.
- Database
Name string - Database name for the endpoint.
- Force
Lob boolLookup - Forces LOB lookup on inline LOB.
- Password string
- Endpoint connection password.
- Port int
- Endpoint TCP port.
- Query
Single boolAlways On Node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- Read
Backup boolOnly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- Safeguard
Policy string - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- Server
Name string - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- Tlog
Access stringMode - Indicates the mode used to fetch CDC data.
- Trim
Space boolIn Char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- Use
Bcp boolFull Load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- Use
Third boolParty Backup Device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- Username string
- Endpoint connection user name.
- Bcp
Packet intSize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- Control
Tables stringFile Group - Specifies a file group for the AWS DMS internal tables.
- Database
Name string - Database name for the endpoint.
- Force
Lob boolLookup - Forces LOB lookup on inline LOB.
- Password string
- Endpoint connection password.
- Port int
- Endpoint TCP port.
- Query
Single boolAlways On Node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- Read
Backup boolOnly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- Safeguard
Policy string - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- Server
Name string - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- Tlog
Access stringMode - Indicates the mode used to fetch CDC data.
- Trim
Space boolIn Char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- Use
Bcp boolFull Load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- Use
Third boolParty Backup Device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- Username string
- Endpoint connection user name.
- bcp_
packet_ numbersize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- control_
tables_ stringfile_ group - Specifies a file group for the AWS DMS internal tables.
- database_
name string - Database name for the endpoint.
- force_
lob_ boollookup - Forces LOB lookup on inline LOB.
- password string
- Endpoint connection password.
- port number
- Endpoint TCP port.
- query_
single_ boolalways_ on_ node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- read_
backup_ boolonly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- safeguard_
policy string - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- server_
name string - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- tlog_
access_ stringmode - Indicates the mode used to fetch CDC data.
- trim_
space_ boolin_ char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- use_
bcp_ boolfull_ load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- use_
third_ boolparty_ backup_ device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- username string
- Endpoint connection user name.
- bcp
Packet IntegerSize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- control
Tables StringFile Group - Specifies a file group for the AWS DMS internal tables.
- database
Name String - Database name for the endpoint.
- force
Lob BooleanLookup - Forces LOB lookup on inline LOB.
- password String
- Endpoint connection password.
- port Integer
- Endpoint TCP port.
- query
Single BooleanAlways On Node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- read
Backup BooleanOnly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- safeguard
Policy String - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- server
Name String - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- tlog
Access StringMode - Indicates the mode used to fetch CDC data.
- trim
Space BooleanIn Char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- use
Bcp BooleanFull Load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- use
Third BooleanParty Backup Device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- username String
- Endpoint connection user name.
- bcp
Packet numberSize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- control
Tables stringFile Group - Specifies a file group for the AWS DMS internal tables.
- database
Name string - Database name for the endpoint.
- force
Lob booleanLookup - Forces LOB lookup on inline LOB.
- password string
- Endpoint connection password.
- port number
- Endpoint TCP port.
- query
Single booleanAlways On Node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- read
Backup booleanOnly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- safeguard
Policy string - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- server
Name string - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- tlog
Access stringMode - Indicates the mode used to fetch CDC data.
- trim
Space booleanIn Char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- use
Bcp booleanFull Load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- use
Third booleanParty Backup Device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- username string
- Endpoint connection user name.
- bcp_
packet_ intsize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- control_
tables_ strfile_ group - Specifies a file group for the AWS DMS internal tables.
- database_
name str - Database name for the endpoint.
- force_
lob_ boollookup - Forces LOB lookup on inline LOB.
- password str
- Endpoint connection password.
- port int
- Endpoint TCP port.
- query_
single_ boolalways_ on_ node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- read_
backup_ boolonly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- safeguard_
policy str - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- server_
name str - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- tlog_
access_ strmode - Indicates the mode used to fetch CDC data.
- trim_
space_ boolin_ char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- use_
bcp_ boolfull_ load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- use_
third_ boolparty_ backup_ device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- username str
- Endpoint connection user name.
- bcp
Packet NumberSize - The maximum size of the packets (in bytes) used to transfer data using BCP.
- control
Tables StringFile Group - Specifies a file group for the AWS DMS internal tables.
- database
Name String - Database name for the endpoint.
- force
Lob BooleanLookup - Forces LOB lookup on inline LOB.
- password String
- Endpoint connection password.
- port Number
- Endpoint TCP port.
- query
Single BooleanAlways On Node - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.
- read
Backup BooleanOnly - When this attribute is set to Y, AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.
- safeguard
Policy String - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.
- server
Name String - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances, in the Endpoint.Address field.
- tlog
Access StringMode - Indicates the mode used to fetch CDC data.
- trim
Space BooleanIn Char - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true.
- use
Bcp BooleanFull Load - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.
- use
Third BooleanParty Backup Device - When this attribute is set to Y, DMS processes third-party transaction log backups if they are created in native format.
- username String
- Endpoint connection user name.
EndpointMongoDbSettings
- Auth
Mechanism string - The authentication mechanism you use to access the MongoDB source endpoint.
- Auth
Source string - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- Auth
Type string - The authentication type you use to access the MongoDB source endpoint.
- Database
Name string - The database name on the MongoDB source endpoint.
- Docs
To stringInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- Extract
Doc stringId - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- Nesting
Level string - Specifies either document or table mode.
- Password string
- The password for the user account you use to access the MongoDB source endpoint.
- Port int
- The port value for the MongoDB source endpoint.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- Server
Name string - The name of the server on the MongoDB source endpoint.
- Username string
- The user name you use to access the MongoDB source endpoint.
- Auth
Mechanism string - The authentication mechanism you use to access the MongoDB source endpoint.
- Auth
Source string - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- Auth
Type string - The authentication type you use to access the MongoDB source endpoint.
- Database
Name string - The database name on the MongoDB source endpoint.
- Docs
To stringInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- Extract
Doc stringId - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- Nesting
Level string - Specifies either document or table mode.
- Password string
- The password for the user account you use to access the MongoDB source endpoint.
- Port int
- The port value for the MongoDB source endpoint.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- Server
Name string - The name of the server on the MongoDB source endpoint.
- Username string
- The user name you use to access the MongoDB source endpoint.
- auth_
mechanism string - The authentication mechanism you use to access the MongoDB source endpoint.
- auth_
source string - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- auth_
type string - The authentication type you use to access the MongoDB source endpoint.
- database_
name string - The database name on the MongoDB source endpoint.
- docs_
to_ stringinvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract_
doc_ stringid - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- nesting_
level string - Specifies either document or table mode.
- password string
- The password for the user account you use to access the MongoDB source endpoint.
- port number
- The port value for the MongoDB source endpoint.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- server_
name string - The name of the server on the MongoDB source endpoint.
- username string
- The user name you use to access the MongoDB source endpoint.
- auth
Mechanism String - The authentication mechanism you use to access the MongoDB source endpoint.
- auth
Source String - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- auth
Type String - The authentication type you use to access the MongoDB source endpoint.
- database
Name String - The database name on the MongoDB source endpoint.
- docs
To StringInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract
Doc StringId - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- nesting
Level String - Specifies either document or table mode.
- password String
- The password for the user account you use to access the MongoDB source endpoint.
- port Integer
- The port value for the MongoDB source endpoint.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- server
Name String - The name of the server on the MongoDB source endpoint.
- username String
- The user name you use to access the MongoDB source endpoint.
- auth
Mechanism string - The authentication mechanism you use to access the MongoDB source endpoint.
- auth
Source string - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- auth
Type string - The authentication type you use to access the MongoDB source endpoint.
- database
Name string - The database name on the MongoDB source endpoint.
- docs
To stringInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract
Doc stringId - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- nesting
Level string - Specifies either document or table mode.
- password string
- The password for the user account you use to access the MongoDB source endpoint.
- port number
- The port value for the MongoDB source endpoint.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- server
Name string - The name of the server on the MongoDB source endpoint.
- username string
- The user name you use to access the MongoDB source endpoint.
- auth_
mechanism str - The authentication mechanism you use to access the MongoDB source endpoint.
- auth_
source str - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- auth_
type str - The authentication type you use to access the MongoDB source endpoint.
- database_
name str - The database name on the MongoDB source endpoint.
- docs_
to_ strinvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract_
doc_ strid - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- nesting_
level str - Specifies either document or table mode.
- password str
- The password for the user account you use to access the MongoDB source endpoint.
- port int
- The port value for the MongoDB source endpoint.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- server_
name str - The name of the server on the MongoDB source endpoint.
- username str
- The user name you use to access the MongoDB source endpoint.
- auth
Mechanism String - The authentication mechanism you use to access the MongoDB source endpoint.
- auth
Source String - The MongoDB database name. This setting isn't used when AuthType is set to "no".
- auth
Type String - The authentication type you use to access the MongoDB source endpoint.
- database
Name String - The database name on the MongoDB source endpoint.
- docs
To StringInvestigate - Indicates the number of documents to preview to determine the document organization. Use this setting when NestingLevel is set to "one".
- extract
Doc StringId - Specifies the document ID. Use this setting when NestingLevel is set to "none".
- nesting
Level String - Specifies either document or table mode.
- password String
- The password for the user account you use to access the MongoDB source endpoint.
- port Number
- The port value for the MongoDB source endpoint.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MongoDB endpoint connection details.
- server
Name String - The name of the server on the MongoDB source endpoint.
- username String
- The user name you use to access the MongoDB source endpoint.
EndpointMySqlSettings
- After
Connect stringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- Clean
Source boolMetadata On Mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- Events
Poll intInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- Max
File intSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- Parallel
Load intThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- Server
Timezone string - Specifies the time zone for the source MySQL database.
- Target
Db stringType - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
- After
Connect stringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- Clean
Source boolMetadata On Mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- Events
Poll intInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- Max
File intSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- Parallel
Load intThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- Server
Timezone string - Specifies the time zone for the source MySQL database.
- Target
Db stringType - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
- after_
connect_ stringscript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean_
source_ boolmetadata_ on_ mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- events_
poll_ numberinterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max_
file_ numbersize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel_
load_ numberthreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server_
timezone string - Specifies the time zone for the source MySQL database.
- target_
db_ stringtype - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
- after
Connect StringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean
Source BooleanMetadata On Mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- events
Poll IntegerInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max
File IntegerSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel
Load IntegerThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server
Timezone String - Specifies the time zone for the source MySQL database.
- target
Db StringType - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
- after
Connect stringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean
Source booleanMetadata On Mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- events
Poll numberInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max
File numberSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel
Load numberThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server
Timezone string - Specifies the time zone for the source MySQL database.
- target
Db stringType - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
- after_
connect_ strscript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean_
source_ boolmetadata_ on_ mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- events_
poll_ intinterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max_
file_ intsize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel_
load_ intthreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server_
timezone str - Specifies the time zone for the source MySQL database.
- target_
db_ strtype - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
- after
Connect StringScript - Specifies a script to run immediately after AWS DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
- clean
Source BooleanMetadata On Mismatch - Cleans and recreates table metadata information on the replication instance when a mismatch occurs.
- events
Poll NumberInterval - Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
- max
File NumberSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
- parallel
Load NumberThreads - Improves performance when loading data into the MySQL-compatible target database. Specifies how many threads to use to load the data into the MySQL-compatible target database.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MySQL endpoint connection details.
- server
Timezone String - Specifies the time zone for the source MySQL database.
- target
Db StringType - Specifies where to migrate source tables on the target, either to a single database or multiple databases.
EndpointNeptuneSettings
- Error
Retry intDuration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- Iam
Auth boolEnabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- Max
File intSize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- Max
Retry intCount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- S3Bucket
Folder string - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- S3Bucket
Name string - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
- Error
Retry intDuration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- Iam
Auth boolEnabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- Max
File intSize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- Max
Retry intCount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- S3Bucket
Folder string - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- S3Bucket
Name string - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
- error_
retry_ numberduration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- iam_
auth_ boolenabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- max_
file_ numbersize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- max_
retry_ numbercount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- s3_
bucket_ stringfolder - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- s3_
bucket_ stringname - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- service_
access_ stringrole_ arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
- error
Retry IntegerDuration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- iam
Auth BooleanEnabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- max
File IntegerSize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- max
Retry IntegerCount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- s3Bucket
Folder String - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- s3Bucket
Name String - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
- error
Retry numberDuration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- iam
Auth booleanEnabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- max
File numberSize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- max
Retry numberCount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- s3Bucket
Folder string - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- s3Bucket
Name string - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- service
Access stringRole Arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
- error_
retry_ intduration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- iam_
auth_ boolenabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- max_
file_ intsize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- max_
retry_ intcount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- s3_
bucket_ strfolder - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- s3_
bucket_ strname - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- service_
access_ strrole_ arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
- error
Retry NumberDuration - The number of milliseconds for AWS DMS to wait to retry a bulk-load of migrated graph data to the Neptune target database before raising an error. The default is 250.
- iam
Auth BooleanEnabled - If you want IAM authorization enabled for this endpoint, set this parameter to true.
- max
File NumberSize - The maximum size in kilobytes of migrated graph data stored in a .csv file before AWS DMS bulk-loads the data to the Neptune target database.
- max
Retry NumberCount - The number of times for AWS DMS to retry a bulk load of migrated graph data to the Neptune target database before raising an error. The default is 5.
- s3Bucket
Folder String - A folder path where you want AWS DMS to store migrated graph data in the S3 bucket specified by S3BucketName
- s3Bucket
Name String - The name of the Amazon S3 bucket where AWS DMS can temporarily store migrated graph data in .csv files before bulk-loading it to the Neptune target database.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) of the service role that you created for the Neptune target endpoint. The role must allow the iam:PassRole action.
EndpointOracleSettings
- Access
Alternate boolDirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Add
Supplemental boolLogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- Additional
Archived intLog Dest Id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- Allow
Select boolNested Tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- Archived
Log intDest Id - Specifies the ID of the destination for the archived redo logs.
- Archived
Logs boolOnly - When this field is set to True, AWS DMS only accesses the archived redo logs
- Asm
Password string - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- Asm
Server string - For an Oracle source endpoint, your ASM server address.
- Asm
User string - For an Oracle source endpoint, your ASM user name.
- Char
Length stringSemantics - Specifies whether the length of a character column is in bytes or in characters.
- Direct
Path boolNo Log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- Direct
Path boolParallel Load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- Enable
Homogenous boolTablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- Extra
Archived List<int>Log Dest Ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- Fail
Tasks boolOn Lob Truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- Number
Datatype intScale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- Oracle
Path stringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Parallel
Asm intRead Threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- Read
Ahead intBlocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- Read
Table boolSpace Name - When set to true, this attribute supports tablespace replication.
- Replace
Path boolPrefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Retry
Interval int - Specifies the number of seconds that the system waits before resending a query.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringOracle Asm Access Role Arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- Secrets
Manager stringOracle Asm Secret Id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- Security
Db stringEncryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- Security
Db stringEncryption Name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- Spatial
Data stringOption To Geo Json Function Name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- Standby
Delay intTime - Use this attribute to specify a time in minutes for the delay in standby sync.
- Use
Alternate boolFolder For Online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- Use
BFile bool - Set this attribute to True to capture change data using the Binary Reader utility.
- Use
Direct boolPath Full Load - Set this attribute to True to have AWS DMS use a direct path full load.
- Use
Logminer boolReader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- Use
Path stringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Access
Alternate boolDirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Add
Supplemental boolLogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- Additional
Archived intLog Dest Id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- Allow
Select boolNested Tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- Archived
Log intDest Id - Specifies the ID of the destination for the archived redo logs.
- Archived
Logs boolOnly - When this field is set to True, AWS DMS only accesses the archived redo logs
- Asm
Password string - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- Asm
Server string - For an Oracle source endpoint, your ASM server address.
- Asm
User string - For an Oracle source endpoint, your ASM user name.
- Char
Length stringSemantics - Specifies whether the length of a character column is in bytes or in characters.
- Direct
Path boolNo Log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- Direct
Path boolParallel Load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- Enable
Homogenous boolTablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- Extra
Archived []intLog Dest Ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- Fail
Tasks boolOn Lob Truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- Number
Datatype intScale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- Oracle
Path stringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Parallel
Asm intRead Threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- Read
Ahead intBlocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- Read
Table boolSpace Name - When set to true, this attribute supports tablespace replication.
- Replace
Path boolPrefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- Retry
Interval int - Specifies the number of seconds that the system waits before resending a query.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringOracle Asm Access Role Arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- Secrets
Manager stringOracle Asm Secret Id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- Security
Db stringEncryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- Security
Db stringEncryption Name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- Spatial
Data stringOption To Geo Json Function Name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- Standby
Delay intTime - Use this attribute to specify a time in minutes for the delay in standby sync.
- Use
Alternate boolFolder For Online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- Use
BFile bool - Set this attribute to True to capture change data using the Binary Reader utility.
- Use
Direct boolPath Full Load - Set this attribute to True to have AWS DMS use a direct path full load.
- Use
Logminer boolReader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- Use
Path stringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- access_
alternate_ booldirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- add_
supplemental_ boollogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- additional_
archived_ numberlog_ dest_ id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- allow_
select_ boolnested_ tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- archived_
log_ numberdest_ id - Specifies the ID of the destination for the archived redo logs.
- archived_
logs_ boolonly - When this field is set to True, AWS DMS only accesses the archived redo logs
- asm_
password string - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- asm_
server string - For an Oracle source endpoint, your ASM server address.
- asm_
user string - For an Oracle source endpoint, your ASM user name.
- char_
length_ stringsemantics - Specifies whether the length of a character column is in bytes or in characters.
- direct_
path_ boolno_ log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- direct_
path_ boolparallel_ load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- enable_
homogenous_ booltablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- extra_
archived_ list(number)log_ dest_ ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- fail_
tasks_ boolon_ lob_ truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- number_
datatype_ numberscale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- oracle_
path_ stringprefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- parallel_
asm_ numberread_ threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read_
ahead_ numberblocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read_
table_ boolspace_ name - When set to true, this attribute supports tablespace replication.
- replace_
path_ boolprefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- retry_
interval number - Specifies the number of seconds that the system waits before resending a query.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ stringoracle_ asm_ access_ role_ arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets_
manager_ stringoracle_ asm_ secret_ id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- security_
db_ stringencryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- security_
db_ stringencryption_ name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- spatial_
data_ stringoption_ to_ geo_ json_ function_ name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- standby_
delay_ numbertime - Use this attribute to specify a time in minutes for the delay in standby sync.
- use_
alternate_ boolfolder_ for_ online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- use_
b_ boolfile - Set this attribute to True to capture change data using the Binary Reader utility.
- use_
direct_ boolpath_ full_ load - Set this attribute to True to have AWS DMS use a direct path full load.
- use_
logminer_ boolreader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- use_
path_ stringprefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- access
Alternate BooleanDirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- add
Supplemental BooleanLogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- additional
Archived IntegerLog Dest Id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- allow
Select BooleanNested Tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- archived
Log IntegerDest Id - Specifies the ID of the destination for the archived redo logs.
- archived
Logs BooleanOnly - When this field is set to True, AWS DMS only accesses the archived redo logs
- asm
Password String - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- asm
Server String - For an Oracle source endpoint, your ASM server address.
- asm
User String - For an Oracle source endpoint, your ASM user name.
- char
Length StringSemantics - Specifies whether the length of a character column is in bytes or in characters.
- direct
Path BooleanNo Log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- direct
Path BooleanParallel Load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- enable
Homogenous BooleanTablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- extra
Archived List<Integer>Log Dest Ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- fail
Tasks BooleanOn Lob Truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- number
Datatype IntegerScale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- oracle
Path StringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- parallel
Asm IntegerRead Threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read
Ahead IntegerBlocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read
Table BooleanSpace Name - When set to true, this attribute supports tablespace replication.
- replace
Path BooleanPrefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- retry
Interval Integer - Specifies the number of seconds that the system waits before resending a query.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringOracle Asm Access Role Arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets
Manager StringOracle Asm Secret Id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- security
Db StringEncryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- security
Db StringEncryption Name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- spatial
Data StringOption To Geo Json Function Name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- standby
Delay IntegerTime - Use this attribute to specify a time in minutes for the delay in standby sync.
- use
Alternate BooleanFolder For Online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- use
BFile Boolean - Set this attribute to True to capture change data using the Binary Reader utility.
- use
Direct BooleanPath Full Load - Set this attribute to True to have AWS DMS use a direct path full load.
- use
Logminer BooleanReader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- use
Path StringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- access
Alternate booleanDirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- add
Supplemental booleanLogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- additional
Archived numberLog Dest Id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- allow
Select booleanNested Tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- archived
Log numberDest Id - Specifies the ID of the destination for the archived redo logs.
- archived
Logs booleanOnly - When this field is set to True, AWS DMS only accesses the archived redo logs
- asm
Password string - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- asm
Server string - For an Oracle source endpoint, your ASM server address.
- asm
User string - For an Oracle source endpoint, your ASM user name.
- char
Length stringSemantics - Specifies whether the length of a character column is in bytes or in characters.
- direct
Path booleanNo Log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- direct
Path booleanParallel Load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- enable
Homogenous booleanTablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- extra
Archived number[]Log Dest Ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- fail
Tasks booleanOn Lob Truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- number
Datatype numberScale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- oracle
Path stringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- parallel
Asm numberRead Threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read
Ahead numberBlocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read
Table booleanSpace Name - When set to true, this attribute supports tablespace replication.
- replace
Path booleanPrefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- retry
Interval number - Specifies the number of seconds that the system waits before resending a query.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager stringOracle Asm Access Role Arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets
Manager stringOracle Asm Secret Id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- security
Db stringEncryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- security
Db stringEncryption Name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- spatial
Data stringOption To Geo Json Function Name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- standby
Delay numberTime - Use this attribute to specify a time in minutes for the delay in standby sync.
- use
Alternate booleanFolder For Online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- use
BFile boolean - Set this attribute to True to capture change data using the Binary Reader utility.
- use
Direct booleanPath Full Load - Set this attribute to True to have AWS DMS use a direct path full load.
- use
Logminer booleanReader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- use
Path stringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- access_
alternate_ booldirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- add_
supplemental_ boollogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- additional_
archived_ intlog_ dest_ id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- allow_
select_ boolnested_ tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- archived_
log_ intdest_ id - Specifies the ID of the destination for the archived redo logs.
- archived_
logs_ boolonly - When this field is set to True, AWS DMS only accesses the archived redo logs
- asm_
password str - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- asm_
server str - For an Oracle source endpoint, your ASM server address.
- asm_
user str - For an Oracle source endpoint, your ASM user name.
- char_
length_ strsemantics - Specifies whether the length of a character column is in bytes or in characters.
- direct_
path_ boolno_ log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- direct_
path_ boolparallel_ load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- enable_
homogenous_ booltablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- extra_
archived_ Sequence[int]log_ dest_ ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- fail_
tasks_ boolon_ lob_ truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- number_
datatype_ intscale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- oracle_
path_ strprefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- parallel_
asm_ intread_ threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read_
ahead_ intblocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read_
table_ boolspace_ name - When set to true, this attribute supports tablespace replication.
- replace_
path_ boolprefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- retry_
interval int - Specifies the number of seconds that the system waits before resending a query.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ stroracle_ asm_ access_ role_ arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets_
manager_ stroracle_ asm_ secret_ id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- security_
db_ strencryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- security_
db_ strencryption_ name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- spatial_
data_ stroption_ to_ geo_ json_ function_ name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- standby_
delay_ inttime - Use this attribute to specify a time in minutes for the delay in standby sync.
- use_
alternate_ boolfolder_ for_ online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- use_
b_ boolfile - Set this attribute to True to capture change data using the Binary Reader utility.
- use_
direct_ boolpath_ full_ load - Set this attribute to True to have AWS DMS use a direct path full load.
- use_
logminer_ boolreader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- use_
path_ strprefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- access
Alternate BooleanDirectly - Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- add
Supplemental BooleanLogging - Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.
- additional
Archived NumberLog Dest Id - Set this attribute with ArchivedLogDestId in a primary/ standby setup
- allow
Select BooleanNested Tables - Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.
- archived
Log NumberDest Id - Specifies the ID of the destination for the archived redo logs.
- archived
Logs BooleanOnly - When this field is set to True, AWS DMS only accesses the archived redo logs
- asm
Password String - For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password.
- asm
Server String - For an Oracle source endpoint, your ASM server address.
- asm
User String - For an Oracle source endpoint, your ASM user name.
- char
Length StringSemantics - Specifies whether the length of a character column is in bytes or in characters.
- direct
Path BooleanNo Log - When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.
- direct
Path BooleanParallel Load - When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y.
- enable
Homogenous BooleanTablespace - Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.
- extra
Archived List<Number>Log Dest Ids - Specifies the IDs of one more destinations for one or more archived redo logs.
- fail
Tasks BooleanOn Lob Truncation - When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.
- number
Datatype NumberScale - Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.
- oracle
Path StringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- parallel
Asm NumberRead Threads - Set this attribute to change the number of threads that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read
Ahead NumberBlocks - Set this attribute to change the number of read-ahead blocks that DMS configures to perform a change data capture (CDC) load using Oracle Automatic Storage Management (ASM).
- read
Table BooleanSpace Name - When set to true, this attribute supports tablespace replication.
- replace
Path BooleanPrefix - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
- retry
Interval Number - Specifies the number of seconds that the system waits before resending a query.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringOracle Asm Access Role Arn - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets
Manager StringOracle Asm Secret Id - Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Oracle endpoint connection details.
- security
Db StringEncryption - For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader.
- security
Db StringEncryption Name - For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE.
- spatial
Data StringOption To Geo Json Function Name - Use this attribute to convert SDO_GEOMETRY to GEOJSON format. By default, DMS calls the SDO2GEOJSON custom function if present and accessible. Or you can create your own custom function that mimics the operation of SDOGEOJSON and set SpatialDataOptionToGeoJsonFunctionName to call it instead.
- standby
Delay NumberTime - Use this attribute to specify a time in minutes for the delay in standby sync.
- use
Alternate BooleanFolder For Online - Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source
- use
BFile Boolean - Set this attribute to True to capture change data using the Binary Reader utility.
- use
Direct BooleanPath Full Load - Set this attribute to True to have AWS DMS use a direct path full load.
- use
Logminer BooleanReader - Set this attribute to True to capture change data using the Oracle LogMiner utility (the default).
- use
Path StringPrefix - Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source.
EndpointPostgreSqlSettings
- After
Connect stringScript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- Babelfish
Database stringName - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- Capture
Ddls bool - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- Database
Mode string - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- Ddl
Artifacts stringSchema - The schema in which the operational DDL database artifacts are created.
- Execute
Timeout int - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- Fail
Tasks boolOn Lob Truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- Heartbeat
Enable bool - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- Heartbeat
Frequency int - Sets the WAL heartbeat frequency (in minutes).
- Heartbeat
Schema string - Sets the schema in which the heartbeat artifacts are created.
- Map
Boolean boolAs Boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- Max
File intSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- Plugin
Name string - Specifies the plugin to use to create a replication slot.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- Slot
Name string - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
- After
Connect stringScript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- Babelfish
Database stringName - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- Capture
Ddls bool - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- Database
Mode string - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- Ddl
Artifacts stringSchema - The schema in which the operational DDL database artifacts are created.
- Execute
Timeout int - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- Fail
Tasks boolOn Lob Truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- Heartbeat
Enable bool - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- Heartbeat
Frequency int - Sets the WAL heartbeat frequency (in minutes).
- Heartbeat
Schema string - Sets the schema in which the heartbeat artifacts are created.
- Map
Boolean boolAs Boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- Max
File intSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- Plugin
Name string - Specifies the plugin to use to create a replication slot.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- Slot
Name string - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
- after_
connect_ stringscript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- babelfish_
database_ stringname - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- capture_
ddls bool - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- database_
mode string - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- ddl_
artifacts_ stringschema - The schema in which the operational DDL database artifacts are created.
- execute_
timeout number - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- fail_
tasks_ boolon_ lob_ truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- heartbeat_
enable bool - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- heartbeat_
frequency number - Sets the WAL heartbeat frequency (in minutes).
- heartbeat_
schema string - Sets the schema in which the heartbeat artifacts are created.
- map_
boolean_ boolas_ boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- max_
file_ numbersize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- plugin_
name string - Specifies the plugin to use to create a replication slot.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- slot_
name string - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
- after
Connect StringScript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- babelfish
Database StringName - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- capture
Ddls Boolean - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- database
Mode String - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- ddl
Artifacts StringSchema - The schema in which the operational DDL database artifacts are created.
- execute
Timeout Integer - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- fail
Tasks BooleanOn Lob Truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- heartbeat
Enable Boolean - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- heartbeat
Frequency Integer - Sets the WAL heartbeat frequency (in minutes).
- heartbeat
Schema String - Sets the schema in which the heartbeat artifacts are created.
- map
Boolean BooleanAs Boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- max
File IntegerSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- plugin
Name String - Specifies the plugin to use to create a replication slot.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- slot
Name String - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
- after
Connect stringScript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- babelfish
Database stringName - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- capture
Ddls boolean - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- database
Mode string - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- ddl
Artifacts stringSchema - The schema in which the operational DDL database artifacts are created.
- execute
Timeout number - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- fail
Tasks booleanOn Lob Truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- heartbeat
Enable boolean - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- heartbeat
Frequency number - Sets the WAL heartbeat frequency (in minutes).
- heartbeat
Schema string - Sets the schema in which the heartbeat artifacts are created.
- map
Boolean booleanAs Boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- max
File numberSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- plugin
Name string - Specifies the plugin to use to create a replication slot.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- slot
Name string - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
- after_
connect_ strscript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- babelfish_
database_ strname - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- capture_
ddls bool - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- database_
mode str - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- ddl_
artifacts_ strschema - The schema in which the operational DDL database artifacts are created.
- execute_
timeout int - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- fail_
tasks_ boolon_ lob_ truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- heartbeat_
enable bool - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- heartbeat_
frequency int - Sets the WAL heartbeat frequency (in minutes).
- heartbeat_
schema str - Sets the schema in which the heartbeat artifacts are created.
- map_
boolean_ boolas_ boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- max_
file_ intsize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- plugin_
name str - Specifies the plugin to use to create a replication slot.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- slot_
name str - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
- after
Connect StringScript - For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.
- babelfish
Database StringName - The Babelfish for Aurora PostgreSQL database name for the endpoint.
- capture
Ddls Boolean - To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
- database
Mode String - Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
- ddl
Artifacts StringSchema - The schema in which the operational DDL database artifacts are created.
- execute
Timeout Number - Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
- fail
Tasks BooleanOn Lob Truncation - When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize.
- heartbeat
Enable Boolean - The write-ahead log (WAL) heartbeat feature mimics a dummy transaction.
- heartbeat
Frequency Number - Sets the WAL heartbeat frequency (in minutes).
- heartbeat
Schema String - Sets the schema in which the heartbeat artifacts are created.
- map
Boolean BooleanAs Boolean - When true, lets PostgreSQL migrate the boolean type as boolean.
- max
File NumberSize - Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
- plugin
Name String - Specifies the plugin to use to create a replication slot.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the PostgreSQL endpoint connection details.
- slot
Name String - Sets the name of a previously created logical replication slot for a change data capture (CDC) load of the PostgreSQL source instance.
EndpointRedisSettings
- Auth
Password string - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- Auth
Type string - The type of authentication to perform when connecting to a Redis target.
- Auth
User stringName - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- Port double
- Transmission Control Protocol (TCP) port for the endpoint.
- Server
Name string - Fully qualified domain name of the endpoint.
- Ssl
Ca stringCertificate Arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- Ssl
Security stringProtocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
- Auth
Password string - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- Auth
Type string - The type of authentication to perform when connecting to a Redis target.
- Auth
User stringName - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- Port float64
- Transmission Control Protocol (TCP) port for the endpoint.
- Server
Name string - Fully qualified domain name of the endpoint.
- Ssl
Ca stringCertificate Arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- Ssl
Security stringProtocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
- auth_
password string - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- auth_
type string - The type of authentication to perform when connecting to a Redis target.
- auth_
user_ stringname - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- port number
- Transmission Control Protocol (TCP) port for the endpoint.
- server_
name string - Fully qualified domain name of the endpoint.
- ssl_
ca_ stringcertificate_ arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- ssl_
security_ stringprotocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
- auth
Password String - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- auth
Type String - The type of authentication to perform when connecting to a Redis target.
- auth
User StringName - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- port Double
- Transmission Control Protocol (TCP) port for the endpoint.
- server
Name String - Fully qualified domain name of the endpoint.
- ssl
Ca StringCertificate Arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- ssl
Security StringProtocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
- auth
Password string - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- auth
Type string - The type of authentication to perform when connecting to a Redis target.
- auth
User stringName - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- port number
- Transmission Control Protocol (TCP) port for the endpoint.
- server
Name string - Fully qualified domain name of the endpoint.
- ssl
Ca stringCertificate Arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- ssl
Security stringProtocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
- auth_
password str - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- auth_
type str - The type of authentication to perform when connecting to a Redis target.
- auth_
user_ strname - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- port float
- Transmission Control Protocol (TCP) port for the endpoint.
- server_
name str - Fully qualified domain name of the endpoint.
- ssl_
ca_ strcertificate_ arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- ssl_
security_ strprotocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
- auth
Password String - The password provided with the auth-role and auth-token options of the AuthType setting for a Redis target endpoint.
- auth
Type String - The type of authentication to perform when connecting to a Redis target.
- auth
User StringName - The user name provided with the auth-role option of the AuthType setting for a Redis target endpoint.
- port Number
- Transmission Control Protocol (TCP) port for the endpoint.
- server
Name String - Fully qualified domain name of the endpoint.
- ssl
Ca StringCertificate Arn - The Amazon Resource Name (ARN) for the certificate authority (CA) that DMS uses to connect to your Redis target endpoint.
- ssl
Security StringProtocol - The connection to a Redis target endpoint using Transport Layer Security (TLS). Valid values include plaintext and ssl-encryption.
EndpointRedshiftSettings
- Accept
Any boolDate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- After
Connect stringScript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- Bucket
Folder string - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- Bucket
Name string - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- Case
Sensitive boolNames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- Comp
Update bool - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- Connection
Timeout int - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- Date
Format string - The date format that you are using.
- Empty
As boolNull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- Encryption
Mode string - The type of server-side encryption that you want to use for your data.
- Explicit
Ids bool - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- File
Transfer intUpload Streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- Load
Timeout int - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- Map
Boolean boolAs Boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- Max
File intSize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- Remove
Quotes bool - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- Replace
Chars string - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- Replace
Invalid stringChars - A list of characters that you want to replace. Use with ReplaceChars.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- Server
Side stringEncryption Kms Key Id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- Time
Format string - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- Trim
Blanks bool - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- Truncate
Columns bool - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- Write
Buffer intSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
- Accept
Any boolDate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- After
Connect stringScript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- Bucket
Folder string - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- Bucket
Name string - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- Case
Sensitive boolNames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- Comp
Update bool - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- Connection
Timeout int - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- Date
Format string - The date format that you are using.
- Empty
As boolNull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- Encryption
Mode string - The type of server-side encryption that you want to use for your data.
- Explicit
Ids bool - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- File
Transfer intUpload Streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- Load
Timeout int - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- Map
Boolean boolAs Boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- Max
File intSize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- Remove
Quotes bool - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- Replace
Chars string - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- Replace
Invalid stringChars - A list of characters that you want to replace. Use with ReplaceChars.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- Server
Side stringEncryption Kms Key Id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- Service
Access stringRole Arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- Time
Format string - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- Trim
Blanks bool - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- Truncate
Columns bool - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- Write
Buffer intSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
- accept_
any_ booldate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- after_
connect_ stringscript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- bucket_
folder string - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- bucket_
name string - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- case_
sensitive_ boolnames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- comp_
update bool - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- connection_
timeout number - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- date_
format string - The date format that you are using.
- empty_
as_ boolnull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- encryption_
mode string - The type of server-side encryption that you want to use for your data.
- explicit_
ids bool - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- file_
transfer_ numberupload_ streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- load_
timeout number - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- map_
boolean_ boolas_ boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- max_
file_ numbersize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- remove_
quotes bool - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- replace_
chars string - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- replace_
invalid_ stringchars - A list of characters that you want to replace. Use with ReplaceChars.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- server_
side_ stringencryption_ kms_ key_ id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- service_
access_ stringrole_ arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- time_
format string - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- trim_
blanks bool - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- truncate_
columns bool - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- write_
buffer_ numbersize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
- accept
Any BooleanDate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- after
Connect StringScript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- bucket
Folder String - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- bucket
Name String - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- case
Sensitive BooleanNames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- comp
Update Boolean - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- connection
Timeout Integer - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- date
Format String - The date format that you are using.
- empty
As BooleanNull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- encryption
Mode String - The type of server-side encryption that you want to use for your data.
- explicit
Ids Boolean - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- file
Transfer IntegerUpload Streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- load
Timeout Integer - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- map
Boolean BooleanAs Boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- max
File IntegerSize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- remove
Quotes Boolean - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- replace
Chars String - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- replace
Invalid StringChars - A list of characters that you want to replace. Use with ReplaceChars.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- server
Side StringEncryption Kms Key Id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- time
Format String - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- trim
Blanks Boolean - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- truncate
Columns Boolean - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- write
Buffer IntegerSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
- accept
Any booleanDate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- after
Connect stringScript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- bucket
Folder string - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- bucket
Name string - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- case
Sensitive booleanNames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- comp
Update boolean - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- connection
Timeout number - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- date
Format string - The date format that you are using.
- empty
As booleanNull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- encryption
Mode string - The type of server-side encryption that you want to use for your data.
- explicit
Ids boolean - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- file
Transfer numberUpload Streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- load
Timeout number - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- map
Boolean booleanAs Boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- max
File numberSize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- remove
Quotes boolean - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- replace
Chars string - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- replace
Invalid stringChars - A list of characters that you want to replace. Use with ReplaceChars.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- server
Side stringEncryption Kms Key Id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- service
Access stringRole Arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- time
Format string - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- trim
Blanks boolean - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- truncate
Columns boolean - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- write
Buffer numberSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
- accept_
any_ booldate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- after_
connect_ strscript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- bucket_
folder str - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- bucket_
name str - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- case_
sensitive_ boolnames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- comp_
update bool - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- connection_
timeout int - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- date_
format str - The date format that you are using.
- empty_
as_ boolnull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- encryption_
mode str - The type of server-side encryption that you want to use for your data.
- explicit_
ids bool - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- file_
transfer_ intupload_ streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- load_
timeout int - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- map_
boolean_ boolas_ boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- max_
file_ intsize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- remove_
quotes bool - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- replace_
chars str - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- replace_
invalid_ strchars - A list of characters that you want to replace. Use with ReplaceChars.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- server_
side_ strencryption_ kms_ key_ id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- service_
access_ strrole_ arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- time_
format str - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- trim_
blanks bool - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- truncate_
columns bool - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- write_
buffer_ intsize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
- accept
Any BooleanDate - A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error. You can choose true or false (the default).
- after
Connect StringScript - Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
- bucket
Folder String - An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
- bucket
Name String - The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
- case
Sensitive BooleanNames - If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true. The default is false.
- comp
Update Boolean - If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
- connection
Timeout Number - A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
- date
Format String - The date format that you are using.
- empty
As BooleanNull - A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL. A value of true sets empty CHAR and VARCHAR fields to null. The default is false.
- encryption
Mode String - The type of server-side encryption that you want to use for your data.
- explicit
Ids Boolean - This setting is only valid for a full-load migration task. Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false.
- file
Transfer NumberUpload Streams - The number of threads used to upload a single file. This parameter accepts a value from 1 through 64. It defaults to 10.
- load
Timeout Number - The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
- map
Boolean BooleanAs Boolean - When true, lets Redshift migrate the boolean type as boolean. By default, Redshift migrates booleans as varchar(1). You must set this setting on both the source and target endpoints for it to take effect.
- max
File NumberSize - The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).
- remove
Quotes Boolean - A value that specifies to remove surrounding quotation marks from strings in the incoming data.
- replace
Chars String - A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".
- replace
Invalid StringChars - A list of characters that you want to replace. Use with ReplaceChars.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
- server
Side StringEncryption Kms Key Id - The AWS KMS key ID. If you are using SSE_KMS for the EncryptionMode, provide this key ID.
- service
Access StringRole Arn - The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service. The role must allow the iam:PassRole action.
- time
Format String - The time format that you want to use. Valid values are auto (case-sensitive), 'timeformat_string', 'epochsecs', or 'epochmillisecs'.
- trim
Blanks Boolean - A value that specifies to remove the trailing white space characters from a VARCHAR string.
- truncate
Columns Boolean - A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
- write
Buffer NumberSize - The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).
EndpointS3Settings
- Add
Column boolName - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- Add
Trailing boolPadding Character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- Bucket
Folder string - An optional parameter to set a folder name in the S3 bucket.
- Bucket
Name string - The name of the S3 bucket.
- Canned
Acl stringFor Objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- Cdc
Inserts boolAnd Updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- Cdc
Inserts boolOnly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- Cdc
Max intBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- Cdc
Min intFile Size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- Cdc
Path string - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- Compression
Type string - An optional parameter. When set to GZIP it enables the service to compress the target files.
- Csv
Delimiter string - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- Csv
No stringSup Value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- Csv
Null stringValue - An optional parameter that specifies how AWS DMS treats null values.
- Csv
Row stringDelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- Data
Format string - The format of the data that you want to use for output.
- Data
Page intSize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- Date
Partition stringDelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- Date
Partition boolEnabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- Date
Partition stringSequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- Date
Partition stringTimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- Dict
Page intSize Limit - The maximum size of an encoded dictionary page of a column
- Enable
Statistics bool - A value that enables statistics for Parquet pages and row groups.
- Encoding
Type string - The type of encoding that you're using.
- Encryption
Mode string - The type of server-side encryption that you want to use for your data.
- Expected
Bucket stringOwner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- External
Table stringDefinition - The external table definition.
- Glue
Catalog boolGeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- Ignore
Header intRows - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- Include
Op boolFor Full Load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- Max
File intSize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- Parquet
Timestamp boolIn Millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- Parquet
Version string - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- Preserve
Transactions bool - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- Rfc4180 bool
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- Row
Group intLength - The number of rows in a row group.
- Server
Side stringEncryption Kms Key Id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- Service
Access stringRole Arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- Timestamp
Column stringName - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- Use
Csv boolNo Sup Value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- Use
Task boolStart Time For Full Load Timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
- Add
Column boolName - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- Add
Trailing boolPadding Character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- Bucket
Folder string - An optional parameter to set a folder name in the S3 bucket.
- Bucket
Name string - The name of the S3 bucket.
- Canned
Acl stringFor Objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- Cdc
Inserts boolAnd Updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- Cdc
Inserts boolOnly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- Cdc
Max intBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- Cdc
Min intFile Size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- Cdc
Path string - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- Compression
Type string - An optional parameter. When set to GZIP it enables the service to compress the target files.
- Csv
Delimiter string - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- Csv
No stringSup Value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- Csv
Null stringValue - An optional parameter that specifies how AWS DMS treats null values.
- Csv
Row stringDelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- Data
Format string - The format of the data that you want to use for output.
- Data
Page intSize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- Date
Partition stringDelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- Date
Partition boolEnabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- Date
Partition stringSequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- Date
Partition stringTimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- Dict
Page intSize Limit - The maximum size of an encoded dictionary page of a column
- Enable
Statistics bool - A value that enables statistics for Parquet pages and row groups.
- Encoding
Type string - The type of encoding that you're using.
- Encryption
Mode string - The type of server-side encryption that you want to use for your data.
- Expected
Bucket stringOwner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- External
Table stringDefinition - The external table definition.
- Glue
Catalog boolGeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- Ignore
Header intRows - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- Include
Op boolFor Full Load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- Max
File intSize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- Parquet
Timestamp boolIn Millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- Parquet
Version string - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- Preserve
Transactions bool - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- Rfc4180 bool
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- Row
Group intLength - The number of rows in a row group.
- Server
Side stringEncryption Kms Key Id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- Service
Access stringRole Arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- Timestamp
Column stringName - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- Use
Csv boolNo Sup Value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- Use
Task boolStart Time For Full Load Timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
- add_
column_ boolname - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- add_
trailing_ boolpadding_ character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- bucket_
folder string - An optional parameter to set a folder name in the S3 bucket.
- bucket_
name string - The name of the S3 bucket.
- canned_
acl_ stringfor_ objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- cdc_
inserts_ booland_ updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- cdc_
inserts_ boolonly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- cdc_
max_ numberbatch_ interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- cdc_
min_ numberfile_ size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- cdc_
path string - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- compression_
type string - An optional parameter. When set to GZIP it enables the service to compress the target files.
- csv_
delimiter string - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- csv_
no_ stringsup_ value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- csv_
null_ stringvalue - An optional parameter that specifies how AWS DMS treats null values.
- csv_
row_ stringdelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- data_
format string - The format of the data that you want to use for output.
- data_
page_ numbersize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- date_
partition_ stringdelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- date_
partition_ boolenabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- date_
partition_ stringsequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- date_
partition_ stringtimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- dict_
page_ numbersize_ limit - The maximum size of an encoded dictionary page of a column
- enable_
statistics bool - A value that enables statistics for Parquet pages and row groups.
- encoding_
type string - The type of encoding that you're using.
- encryption_
mode string - The type of server-side encryption that you want to use for your data.
- expected_
bucket_ stringowner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- external_
table_ stringdefinition - The external table definition.
- glue_
catalog_ boolgeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- ignore_
header_ numberrows - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- include_
op_ boolfor_ full_ load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- max_
file_ numbersize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- parquet_
timestamp_ boolin_ millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- parquet_
version string - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- preserve_
transactions bool - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- rfc4180 bool
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- row_
group_ numberlength - The number of rows in a row group.
- server_
side_ stringencryption_ kms_ key_ id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- service_
access_ stringrole_ arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- timestamp_
column_ stringname - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- use_
csv_ boolno_ sup_ value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- use_
task_ boolstart_ time_ for_ full_ load_ timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
- add
Column BooleanName - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- add
Trailing BooleanPadding Character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- bucket
Folder String - An optional parameter to set a folder name in the S3 bucket.
- bucket
Name String - The name of the S3 bucket.
- canned
Acl StringFor Objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- cdc
Inserts BooleanAnd Updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- cdc
Inserts BooleanOnly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- cdc
Max IntegerBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- cdc
Min IntegerFile Size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- cdc
Path String - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- compression
Type String - An optional parameter. When set to GZIP it enables the service to compress the target files.
- csv
Delimiter String - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- csv
No StringSup Value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- csv
Null StringValue - An optional parameter that specifies how AWS DMS treats null values.
- csv
Row StringDelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- data
Format String - The format of the data that you want to use for output.
- data
Page IntegerSize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- date
Partition StringDelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- date
Partition BooleanEnabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- date
Partition StringSequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- date
Partition StringTimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- dict
Page IntegerSize Limit - The maximum size of an encoded dictionary page of a column
- enable
Statistics Boolean - A value that enables statistics for Parquet pages and row groups.
- encoding
Type String - The type of encoding that you're using.
- encryption
Mode String - The type of server-side encryption that you want to use for your data.
- expected
Bucket StringOwner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- external
Table StringDefinition - The external table definition.
- glue
Catalog BooleanGeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- ignore
Header IntegerRows - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- include
Op BooleanFor Full Load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- max
File IntegerSize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- parquet
Timestamp BooleanIn Millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- parquet
Version String - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- preserve
Transactions Boolean - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- rfc4180 Boolean
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- row
Group IntegerLength - The number of rows in a row group.
- server
Side StringEncryption Kms Key Id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- service
Access StringRole Arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- timestamp
Column StringName - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv BooleanNo Sup Value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- use
Task BooleanStart Time For Full Load Timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
- add
Column booleanName - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- add
Trailing booleanPadding Character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- bucket
Folder string - An optional parameter to set a folder name in the S3 bucket.
- bucket
Name string - The name of the S3 bucket.
- canned
Acl stringFor Objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- cdc
Inserts booleanAnd Updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- cdc
Inserts booleanOnly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- cdc
Max numberBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- cdc
Min numberFile Size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- cdc
Path string - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- compression
Type string - An optional parameter. When set to GZIP it enables the service to compress the target files.
- csv
Delimiter string - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- csv
No stringSup Value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- csv
Null stringValue - An optional parameter that specifies how AWS DMS treats null values.
- csv
Row stringDelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- data
Format string - The format of the data that you want to use for output.
- data
Page numberSize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- date
Partition stringDelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- date
Partition booleanEnabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- date
Partition stringSequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- date
Partition stringTimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- dict
Page numberSize Limit - The maximum size of an encoded dictionary page of a column
- enable
Statistics boolean - A value that enables statistics for Parquet pages and row groups.
- encoding
Type string - The type of encoding that you're using.
- encryption
Mode string - The type of server-side encryption that you want to use for your data.
- expected
Bucket stringOwner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- external
Table stringDefinition - The external table definition.
- glue
Catalog booleanGeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- ignore
Header numberRows - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- include
Op booleanFor Full Load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- max
File numberSize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- parquet
Timestamp booleanIn Millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- parquet
Version string - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- preserve
Transactions boolean - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- rfc4180 boolean
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- row
Group numberLength - The number of rows in a row group.
- server
Side stringEncryption Kms Key Id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- service
Access stringRole Arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- timestamp
Column stringName - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv booleanNo Sup Value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- use
Task booleanStart Time For Full Load Timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
- add_
column_ boolname - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- add_
trailing_ boolpadding_ character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- bucket_
folder str - An optional parameter to set a folder name in the S3 bucket.
- bucket_
name str - The name of the S3 bucket.
- canned_
acl_ strfor_ objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- cdc_
inserts_ booland_ updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- cdc_
inserts_ boolonly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- cdc_
max_ intbatch_ interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- cdc_
min_ intfile_ size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- cdc_
path str - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- compression_
type str - An optional parameter. When set to GZIP it enables the service to compress the target files.
- csv_
delimiter str - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- csv_
no_ strsup_ value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- csv_
null_ strvalue - An optional parameter that specifies how AWS DMS treats null values.
- csv_
row_ strdelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- data_
format str - The format of the data that you want to use for output.
- data_
page_ intsize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- date_
partition_ strdelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- date_
partition_ boolenabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- date_
partition_ strsequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- date_
partition_ strtimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- dict_
page_ intsize_ limit - The maximum size of an encoded dictionary page of a column
- enable_
statistics bool - A value that enables statistics for Parquet pages and row groups.
- encoding_
type str - The type of encoding that you're using.
- encryption_
mode str - The type of server-side encryption that you want to use for your data.
- expected_
bucket_ strowner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- external_
table_ strdefinition - The external table definition.
- glue_
catalog_ boolgeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- ignore_
header_ introws - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- include_
op_ boolfor_ full_ load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- max_
file_ intsize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- parquet_
timestamp_ boolin_ millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- parquet_
version str - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- preserve_
transactions bool - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- rfc4180 bool
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- row_
group_ intlength - The number of rows in a row group.
- server_
side_ strencryption_ kms_ key_ id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- service_
access_ strrole_ arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- timestamp_
column_ strname - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- use_
csv_ boolno_ sup_ value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- use_
task_ boolstart_ time_ for_ full_ load_ timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
- add
Column BooleanName - An optional parameter that, when set to true or y, you can use to add column name information to the .csv output file.
- add
Trailing BooleanPadding Character - Use the S3 target endpoint setting AddTrailingPaddingCharacter to add padding on string data. The default value is false.
- bucket
Folder String - An optional parameter to set a folder name in the S3 bucket.
- bucket
Name String - The name of the S3 bucket.
- canned
Acl StringFor Objects - A value that enables AWS DMS to specify a predefined (canned) access control list (ACL) for objects created in an Amazon S3 bucket as .csv or .parquet files.
- cdc
Inserts BooleanAnd Updates - A value that enables a change data capture (CDC) load to write INSERT and UPDATE operations to .csv or .parquet (columnar storage) output files.
- cdc
Inserts BooleanOnly - A value that enables a change data capture (CDC) load to write only INSERT operations to .csv or columnar storage (.parquet) output files. By default (the false setting), the first field in a .csv or .parquet record contains the letter I (INSERT), U (UPDATE), or D (DELETE). These values indicate whether the row was inserted, updated, or deleted at the source database for a CDC load to the target.
- cdc
Max NumberBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3.
- cdc
Min NumberFile Size - Minimum file size, defined in kilobytes, to reach for a file output to Amazon S3.
- cdc
Path String - Specifies the folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional.
- compression
Type String - An optional parameter. When set to GZIP it enables the service to compress the target files.
- csv
Delimiter String - The delimiter used to separate columns in the .csv file for both source and target. The default is a comma.
- csv
No StringSup Value - This setting only applies if your Amazon S3 output files during a change data capture (CDC) load are written in .csv format.
- csv
Null StringValue - An optional parameter that specifies how AWS DMS treats null values.
- csv
Row StringDelimiter - The delimiter used to separate rows in the .csv file for both source and target.
- data
Format String - The format of the data that you want to use for output.
- data
Page NumberSize - The size of one data page in bytes. This parameter defaults to 1024 * 1024 bytes (1 MiB). This number is used for .parquet file format only.
- date
Partition StringDelimiter - Specifies a date separating delimiter to use during folder partitioning. The default value is SLASH. Use this parameter when DatePartitionedEnabled is set to true.
- date
Partition BooleanEnabled - When set to true, this parameter partitions S3 bucket folders based on transaction commit dates. The default value is false.
- date
Partition StringSequence - Identifies the sequence of the date format to use during folder partitioning. The default value is YYYYMMDD. Use this parameter when DatePartitionedEnabled is set to true.
- date
Partition StringTimezone - When creating an S3 target endpoint, set DatePartitionTimezone to convert the current UTC time into a specified time zone.
- dict
Page NumberSize Limit - The maximum size of an encoded dictionary page of a column
- enable
Statistics Boolean - A value that enables statistics for Parquet pages and row groups.
- encoding
Type String - The type of encoding that you're using.
- encryption
Mode String - The type of server-side encryption that you want to use for your data.
- expected
Bucket StringOwner - To specify a bucket owner and prevent sniping, you can use the ExpectedBucketOwner endpoint setting.
- external
Table StringDefinition - The external table definition.
- glue
Catalog BooleanGeneration - When true, allows AWS Glue to catalog your S3 bucket. Creating an AWS Glue catalog lets you use Athena to query your data.
- ignore
Header NumberRows - When this value is set to 1, AWS DMS ignores the first row header in a .csv file. A value of 1 turns on the feature; a value of 0 turns off the feature.
- include
Op BooleanFor Full Load - A value that enables a full load to write INSERT operations to the comma-separated value (.csv) output files only to indicate how the rows were added to the source database.
- max
File NumberSize - A value that specifies the maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load.
- parquet
Timestamp BooleanIn Millisecond - A value that specifies the precision of any TIMESTAMP column values that are written to an Amazon S3 object file in .parquet format.
- parquet
Version String - The version of the Apache Parquet format that you want to use: parquet_1_0 (the default) or parquet_2_0.
- preserve
Transactions Boolean - If this setting is set to true, AWS DMS saves the transaction order for a change data capture (CDC) load on the Amazon S3 target specified by CdcPath.
- rfc4180 Boolean
- For an S3 source, when this value is set to true or y, each leading double quotation mark has to be followed by an ending double quotation mark.
- row
Group NumberLength - The number of rows in a row group.
- server
Side StringEncryption Kms Key Id - If you are using SSE_KMS for the EncryptionMode, provide the AWS KMS key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.
- service
Access StringRole Arn - A required parameter that specifies the Amazon Resource Name (ARN) used by the service to access the IAM role.
- timestamp
Column StringName - A value that when nonblank causes AWS DMS to add a column with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv BooleanNo Sup Value - This setting applies if the S3 output files during a change data capture (CDC) load are written in .csv format. If this setting is set to true for columns not included in the supplemental log, AWS DMS uses the value specified by CsvNoSupValue. If this setting isn't set or is set to false, AWS DMS uses the null value for these columns.
- use
Task BooleanStart Time For Full Load Timestamp - When set to true, this parameter uses the task start time as the timestamp column value instead of the time data is written to target
EndpointSybaseSettings
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
- Secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- Secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
- secrets_
manager_ stringaccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets_
manager_ stringsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
- secrets
Manager stringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager stringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
- secrets_
manager_ straccess_ role_ arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets_
manager_ strsecret_ id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
- secrets
Manager StringAccess Role Arn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
- secrets
Manager StringSecret Id - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the SAP SAE endpoint connection details.
Tag
Package Details
- Repository
- AWS Native pulumi/pulumi-aws-native
- License
- Apache-2.0
We recommend new projects start with resources from the AWS provider.
Viewing docs for AWS Cloud Control v1.76.0
published on Monday, Aug 24, 2026 by Pulumi
published on Monday, Aug 24, 2026 by Pulumi