2025/11/17 - AWS Database Migration Service - 13 updated api methods
Changes This release introduces the SAP ASE(Sybase) Data Provider for AWS Data Migration Service (DMS). In addition, DMS Schema Conversion now supports this provider, enabling customers to migrate SAP ASE(Sybase) databases to Amazon RDS for PostgreSQL or Aurora PostgreSQL seamlessly.
{'Request': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Cancels a single metadata model conversion operation that was started with StartMetadataModelConversion.
See also: AWS API Documentation
Request Syntax
client.cancel_metadata_model_conversion(
MigrationProjectIdentifier='string',
RequestIdentifier='string'
)
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
string
[REQUIRED]
The identifier for the metadata model conversion operation to cancel. This operation was initiated by StartMetadataModelConversion.
dict
Response Syntax
{
'Request': {
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
}
}
Response Structure
(dict) --
Request (dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Request': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Cancels a single metadata model creation operation that was started with StartMetadataModelCreation.
See also: AWS API Documentation
Request Syntax
client.cancel_metadata_model_creation(
MigrationProjectIdentifier='string',
RequestIdentifier='string'
)
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
string
[REQUIRED]
The identifier for the metadata model creation operation to cancel. This operation was initiated by StartMetadataModelCreation.
dict
Response Syntax
{
'Request': {
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
}
}
Response Structure
(dict) --
Request (dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Settings': {'SybaseAseSettings': {'CertificateArn': 'string',
'DatabaseName': 'string',
'EncryptPassword': 'boolean',
'Port': 'integer',
'ServerName': 'string',
'SslMode': 'none | require | verify-ca | '
'verify-full'}}}
Response {'DataProvider': {'Settings': {'SybaseAseSettings': {'CertificateArn': 'string',
'DatabaseName': 'string',
'EncryptPassword': 'boolean',
'Port': 'integer',
'ServerName': 'string',
'SslMode': 'none | '
'require | '
'verify-ca | '
'verify-full'}}}}
Creates a data provider using the provided settings. A data provider stores a data store type and location information about your database.
See also: AWS API Documentation
Request Syntax
client.create_data_provider(
DataProviderName='string',
Description='string',
Engine='string',
Virtual=True|False,
Settings={
'RedshiftSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'PostgreSqlSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MySqlSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'OracleSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AsmServer': 'string',
'SecretsManagerOracleAsmSecretId': 'string',
'SecretsManagerOracleAsmAccessRoleArn': 'string',
'SecretsManagerSecurityDbEncryptionSecretId': 'string',
'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'SybaseAseSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'EncryptPassword': True|False,
'CertificateArn': 'string'
},
'MicrosoftSqlServerSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'DocDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string'
},
'MariaDbSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2LuwSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2zOsSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MongoDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AuthType': 'no'|'password',
'AuthSource': 'string',
'AuthMechanism': 'default'|'mongodb_cr'|'scram_sha_1'
}
},
Tags=[
{
'Key': 'string',
'Value': 'string',
'ResourceArn': 'string'
},
]
)
string
A user-friendly name for the data provider.
string
A user-friendly description of the data provider.
string
[REQUIRED]
The type of database engine for the data provider. Valid values include "aurora", "aurora-postgresql", "mysql", "oracle", "postgres", "sqlserver", redshift, mariadb, mongodb, db2, db2-zos, docdb, and sybase. A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.
boolean
Indicates whether the data provider is virtual.
dict
[REQUIRED]
The settings in JSON format for a data provider.
RedshiftSettings (dict) --
Provides information that defines an Amazon Redshift data provider.
ServerName (string) --
The name of the Amazon Redshift server.
Port (integer) --
The port value for the Amazon Redshift data provider.
DatabaseName (string) --
The database name on the Amazon Redshift data provider.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
PostgreSqlSettings (dict) --
Provides information that defines a PostgreSQL data provider.
ServerName (string) --
The name of the PostgreSQL server.
Port (integer) --
The port value for the PostgreSQL data provider.
DatabaseName (string) --
The database name on the PostgreSQL data provider.
SslMode (string) --
The SSL mode used to connect to the PostgreSQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MySqlSettings (dict) --
Provides information that defines a MySQL data provider.
ServerName (string) --
The name of the MySQL server.
Port (integer) --
The port value for the MySQL data provider.
SslMode (string) --
The SSL mode used to connect to the MySQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
OracleSettings (dict) --
Provides information that defines an Oracle data provider.
ServerName (string) --
The name of the Oracle server.
Port (integer) --
The port value for the Oracle data provider.
DatabaseName (string) --
The database name on the Oracle data provider.
SslMode (string) --
The SSL mode used to connect to the Oracle data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AsmServer (string) --
The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.
SecretsManagerOracleAsmSecretId (string) --
The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.
Required only if your data provider uses the Oracle ASM server.
SecretsManagerOracleAsmAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.
SecretsManagerSecurityDbEncryptionSecretId (string) --
The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.
SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
SybaseAseSettings (dict) --
Provides information that defines an SAP ASE data provider.
ServerName (string) --
The name of the SAP ASE server.
Port (integer) --
The port value for the SAP ASE data provider.
DatabaseName (string) --
The database name on the SAP ASE data provider.
SslMode (string) --
The SSL mode used to connect to the SAP ASE data provider. The default value is none.
EncryptPassword (boolean) --
Specifies whether to encrypt the password when connecting to the Sybase ASE database. When set to true, the connection password is encrypted during transmission. Default is true.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MicrosoftSqlServerSettings (dict) --
Provides information that defines a Microsoft SQL Server data provider.
ServerName (string) --
The name of the Microsoft SQL Server server.
Port (integer) --
The port value for the Microsoft SQL Server data provider.
DatabaseName (string) --
The database name on the Microsoft SQL Server data provider.
SslMode (string) --
The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
DocDbSettings (dict) --
Provides information that defines a DocumentDB data provider.
ServerName (string) --
The name of the source DocumentDB server.
Port (integer) --
The port value for the DocumentDB data provider.
DatabaseName (string) --
The database name on the DocumentDB data provider.
SslMode (string) --
The SSL mode used to connect to the DocumentDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MariaDbSettings (dict) --
Provides information that defines a MariaDB data provider.
ServerName (string) --
The name of the MariaDB server.
Port (integer) --
The port value for the MariaDB data provider
SslMode (string) --
The SSL mode used to connect to the MariaDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2LuwSettings (dict) --
Provides information that defines an IBM DB2 LUW data provider.
ServerName (string) --
The name of the DB2 LUW server.
Port (integer) --
The port value for the DB2 LUW data provider.
DatabaseName (string) --
The database name on the DB2 LUW data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 LUW data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2zOsSettings (dict) --
Provides information that defines an IBM DB2 for z/OS data provider.
ServerName (string) --
The name of the DB2 for z/OS server.
Port (integer) --
The port value for the DB2 for z/OS data provider.
DatabaseName (string) --
The database name on the DB2 for z/OS data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 for z/OS data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MongoDbSettings (dict) --
Provides information that defines a MongoDB data provider.
ServerName (string) --
The name of the MongoDB server.
Port (integer) --
The port value for the MongoDB data provider.
DatabaseName (string) --
The database name on the MongoDB data provider.
SslMode (string) --
The SSL mode used to connect to the MongoDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AuthType (string) --
The authentication type for the database connection. Valid values are PASSWORD or NO.
AuthSource (string) --
The MongoDB database name. This setting isn't used when AuthType is set to "no".
The default is "admin".
AuthMechanism (string) --
The authentication method for connecting to the data provider. Valid values are DEFAULT, MONGODB_CR, or SCRAM_SHA_1.
list
One or more tags to be assigned to the data provider.
(dict) --
A user-defined key-value pair that describes metadata added to an DMS resource and that is used by operations such as the following:
AddTagsToResource
ListTagsForResource
RemoveTagsFromResource
Key (string) --
A key is the required name of the tag. The string value can be 1-128 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").
Value (string) --
A value is the optional value of the tag. The string value can be 1-256 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").
ResourceArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the resource for which the tag is created.
dict
Response Syntax
{
'DataProvider': {
'DataProviderName': 'string',
'DataProviderArn': 'string',
'DataProviderCreationTime': datetime(2015, 1, 1),
'Description': 'string',
'Engine': 'string',
'Virtual': True|False,
'Settings': {
'RedshiftSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'PostgreSqlSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MySqlSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'OracleSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AsmServer': 'string',
'SecretsManagerOracleAsmSecretId': 'string',
'SecretsManagerOracleAsmAccessRoleArn': 'string',
'SecretsManagerSecurityDbEncryptionSecretId': 'string',
'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'SybaseAseSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'EncryptPassword': True|False,
'CertificateArn': 'string'
},
'MicrosoftSqlServerSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'DocDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string'
},
'MariaDbSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2LuwSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2zOsSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MongoDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AuthType': 'no'|'password',
'AuthSource': 'string',
'AuthMechanism': 'default'|'mongodb_cr'|'scram_sha_1'
}
}
}
}
Response Structure
(dict) --
DataProvider (dict) --
The data provider that was created.
DataProviderName (string) --
The name of the data provider.
DataProviderArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the data provider.
DataProviderCreationTime (datetime) --
The time the data provider was created.
Description (string) --
A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.
Engine (string) --
The type of database engine for the data provider. Valid values include "aurora", "aurora-postgresql", "mysql", "oracle", "postgres", "sqlserver", redshift, mariadb, mongodb, db2, db2-zos, docdb, and sybase. A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.
Virtual (boolean) --
Indicates whether the data provider is virtual.
Settings (dict) --
The settings in JSON format for a data provider.
RedshiftSettings (dict) --
Provides information that defines an Amazon Redshift data provider.
ServerName (string) --
The name of the Amazon Redshift server.
Port (integer) --
The port value for the Amazon Redshift data provider.
DatabaseName (string) --
The database name on the Amazon Redshift data provider.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
PostgreSqlSettings (dict) --
Provides information that defines a PostgreSQL data provider.
ServerName (string) --
The name of the PostgreSQL server.
Port (integer) --
The port value for the PostgreSQL data provider.
DatabaseName (string) --
The database name on the PostgreSQL data provider.
SslMode (string) --
The SSL mode used to connect to the PostgreSQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MySqlSettings (dict) --
Provides information that defines a MySQL data provider.
ServerName (string) --
The name of the MySQL server.
Port (integer) --
The port value for the MySQL data provider.
SslMode (string) --
The SSL mode used to connect to the MySQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
OracleSettings (dict) --
Provides information that defines an Oracle data provider.
ServerName (string) --
The name of the Oracle server.
Port (integer) --
The port value for the Oracle data provider.
DatabaseName (string) --
The database name on the Oracle data provider.
SslMode (string) --
The SSL mode used to connect to the Oracle data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AsmServer (string) --
The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.
SecretsManagerOracleAsmSecretId (string) --
The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.
Required only if your data provider uses the Oracle ASM server.
SecretsManagerOracleAsmAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.
SecretsManagerSecurityDbEncryptionSecretId (string) --
The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.
SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
SybaseAseSettings (dict) --
Provides information that defines an SAP ASE data provider.
ServerName (string) --
The name of the SAP ASE server.
Port (integer) --
The port value for the SAP ASE data provider.
DatabaseName (string) --
The database name on the SAP ASE data provider.
SslMode (string) --
The SSL mode used to connect to the SAP ASE data provider. The default value is none.
EncryptPassword (boolean) --
Specifies whether to encrypt the password when connecting to the Sybase ASE database. When set to true, the connection password is encrypted during transmission. Default is true.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MicrosoftSqlServerSettings (dict) --
Provides information that defines a Microsoft SQL Server data provider.
ServerName (string) --
The name of the Microsoft SQL Server server.
Port (integer) --
The port value for the Microsoft SQL Server data provider.
DatabaseName (string) --
The database name on the Microsoft SQL Server data provider.
SslMode (string) --
The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
DocDbSettings (dict) --
Provides information that defines a DocumentDB data provider.
ServerName (string) --
The name of the source DocumentDB server.
Port (integer) --
The port value for the DocumentDB data provider.
DatabaseName (string) --
The database name on the DocumentDB data provider.
SslMode (string) --
The SSL mode used to connect to the DocumentDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MariaDbSettings (dict) --
Provides information that defines a MariaDB data provider.
ServerName (string) --
The name of the MariaDB server.
Port (integer) --
The port value for the MariaDB data provider
SslMode (string) --
The SSL mode used to connect to the MariaDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2LuwSettings (dict) --
Provides information that defines an IBM DB2 LUW data provider.
ServerName (string) --
The name of the DB2 LUW server.
Port (integer) --
The port value for the DB2 LUW data provider.
DatabaseName (string) --
The database name on the DB2 LUW data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 LUW data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2zOsSettings (dict) --
Provides information that defines an IBM DB2 for z/OS data provider.
ServerName (string) --
The name of the DB2 for z/OS server.
Port (integer) --
The port value for the DB2 for z/OS data provider.
DatabaseName (string) --
The database name on the DB2 for z/OS data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 for z/OS data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MongoDbSettings (dict) --
Provides information that defines a MongoDB data provider.
ServerName (string) --
The name of the MongoDB server.
Port (integer) --
The port value for the MongoDB data provider.
DatabaseName (string) --
The database name on the MongoDB data provider.
SslMode (string) --
The SSL mode used to connect to the MongoDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AuthType (string) --
The authentication type for the database connection. Valid values are PASSWORD or NO.
AuthSource (string) --
The MongoDB database name. This setting isn't used when AuthType is set to "no".
The default is "admin".
AuthMechanism (string) --
The authentication method for connecting to the data provider. Valid values are DEFAULT, MONGODB_CR, or SCRAM_SHA_1.
{'DataProvider': {'Settings': {'SybaseAseSettings': {'CertificateArn': 'string',
'DatabaseName': 'string',
'EncryptPassword': 'boolean',
'Port': 'integer',
'ServerName': 'string',
'SslMode': 'none | '
'require | '
'verify-ca | '
'verify-full'}}}}
Deletes the specified data provider.
See also: AWS API Documentation
Request Syntax
client.delete_data_provider(
DataProviderIdentifier='string'
)
string
[REQUIRED]
The identifier of the data provider to delete.
dict
Response Syntax
{
'DataProvider': {
'DataProviderName': 'string',
'DataProviderArn': 'string',
'DataProviderCreationTime': datetime(2015, 1, 1),
'Description': 'string',
'Engine': 'string',
'Virtual': True|False,
'Settings': {
'RedshiftSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'PostgreSqlSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MySqlSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'OracleSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AsmServer': 'string',
'SecretsManagerOracleAsmSecretId': 'string',
'SecretsManagerOracleAsmAccessRoleArn': 'string',
'SecretsManagerSecurityDbEncryptionSecretId': 'string',
'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'SybaseAseSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'EncryptPassword': True|False,
'CertificateArn': 'string'
},
'MicrosoftSqlServerSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'DocDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string'
},
'MariaDbSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2LuwSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2zOsSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MongoDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AuthType': 'no'|'password',
'AuthSource': 'string',
'AuthMechanism': 'default'|'mongodb_cr'|'scram_sha_1'
}
}
}
}
Response Structure
(dict) --
DataProvider (dict) --
The data provider that was deleted.
DataProviderName (string) --
The name of the data provider.
DataProviderArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the data provider.
DataProviderCreationTime (datetime) --
The time the data provider was created.
Description (string) --
A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.
Engine (string) --
The type of database engine for the data provider. Valid values include "aurora", "aurora-postgresql", "mysql", "oracle", "postgres", "sqlserver", redshift, mariadb, mongodb, db2, db2-zos, docdb, and sybase. A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.
Virtual (boolean) --
Indicates whether the data provider is virtual.
Settings (dict) --
The settings in JSON format for a data provider.
RedshiftSettings (dict) --
Provides information that defines an Amazon Redshift data provider.
ServerName (string) --
The name of the Amazon Redshift server.
Port (integer) --
The port value for the Amazon Redshift data provider.
DatabaseName (string) --
The database name on the Amazon Redshift data provider.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
PostgreSqlSettings (dict) --
Provides information that defines a PostgreSQL data provider.
ServerName (string) --
The name of the PostgreSQL server.
Port (integer) --
The port value for the PostgreSQL data provider.
DatabaseName (string) --
The database name on the PostgreSQL data provider.
SslMode (string) --
The SSL mode used to connect to the PostgreSQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MySqlSettings (dict) --
Provides information that defines a MySQL data provider.
ServerName (string) --
The name of the MySQL server.
Port (integer) --
The port value for the MySQL data provider.
SslMode (string) --
The SSL mode used to connect to the MySQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
OracleSettings (dict) --
Provides information that defines an Oracle data provider.
ServerName (string) --
The name of the Oracle server.
Port (integer) --
The port value for the Oracle data provider.
DatabaseName (string) --
The database name on the Oracle data provider.
SslMode (string) --
The SSL mode used to connect to the Oracle data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AsmServer (string) --
The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.
SecretsManagerOracleAsmSecretId (string) --
The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.
Required only if your data provider uses the Oracle ASM server.
SecretsManagerOracleAsmAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.
SecretsManagerSecurityDbEncryptionSecretId (string) --
The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.
SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
SybaseAseSettings (dict) --
Provides information that defines an SAP ASE data provider.
ServerName (string) --
The name of the SAP ASE server.
Port (integer) --
The port value for the SAP ASE data provider.
DatabaseName (string) --
The database name on the SAP ASE data provider.
SslMode (string) --
The SSL mode used to connect to the SAP ASE data provider. The default value is none.
EncryptPassword (boolean) --
Specifies whether to encrypt the password when connecting to the Sybase ASE database. When set to true, the connection password is encrypted during transmission. Default is true.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MicrosoftSqlServerSettings (dict) --
Provides information that defines a Microsoft SQL Server data provider.
ServerName (string) --
The name of the Microsoft SQL Server server.
Port (integer) --
The port value for the Microsoft SQL Server data provider.
DatabaseName (string) --
The database name on the Microsoft SQL Server data provider.
SslMode (string) --
The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
DocDbSettings (dict) --
Provides information that defines a DocumentDB data provider.
ServerName (string) --
The name of the source DocumentDB server.
Port (integer) --
The port value for the DocumentDB data provider.
DatabaseName (string) --
The database name on the DocumentDB data provider.
SslMode (string) --
The SSL mode used to connect to the DocumentDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MariaDbSettings (dict) --
Provides information that defines a MariaDB data provider.
ServerName (string) --
The name of the MariaDB server.
Port (integer) --
The port value for the MariaDB data provider
SslMode (string) --
The SSL mode used to connect to the MariaDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2LuwSettings (dict) --
Provides information that defines an IBM DB2 LUW data provider.
ServerName (string) --
The name of the DB2 LUW server.
Port (integer) --
The port value for the DB2 LUW data provider.
DatabaseName (string) --
The database name on the DB2 LUW data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 LUW data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2zOsSettings (dict) --
Provides information that defines an IBM DB2 for z/OS data provider.
ServerName (string) --
The name of the DB2 for z/OS server.
Port (integer) --
The port value for the DB2 for z/OS data provider.
DatabaseName (string) --
The database name on the DB2 for z/OS data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 for z/OS data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MongoDbSettings (dict) --
Provides information that defines a MongoDB data provider.
ServerName (string) --
The name of the MongoDB server.
Port (integer) --
The port value for the MongoDB data provider.
DatabaseName (string) --
The database name on the MongoDB data provider.
SslMode (string) --
The SSL mode used to connect to the MongoDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AuthType (string) --
The authentication type for the database connection. Valid values are PASSWORD or NO.
AuthSource (string) --
The MongoDB database name. This setting isn't used when AuthType is set to "no".
The default is "admin".
AuthMechanism (string) --
The authentication method for connecting to the data provider. Valid values are DEFAULT, MONGODB_CR, or SCRAM_SHA_1.
{'DataProviders': {'Settings': {'SybaseAseSettings': {'CertificateArn': 'string',
'DatabaseName': 'string',
'EncryptPassword': 'boolean',
'Port': 'integer',
'ServerName': 'string',
'SslMode': 'none | '
'require | '
'verify-ca | '
'verify-full'}}}}
Returns a paginated list of data providers for your account in the current region.
See also: AWS API Documentation
Request Syntax
client.describe_data_providers(
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
MaxRecords=123,
Marker='string'
)
list
Filters applied to the data providers described in the form of key-value pairs.
Valid filter names and values: data-provider-identifier, data provider arn or name
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
dict
Response Syntax
{
'Marker': 'string',
'DataProviders': [
{
'DataProviderName': 'string',
'DataProviderArn': 'string',
'DataProviderCreationTime': datetime(2015, 1, 1),
'Description': 'string',
'Engine': 'string',
'Virtual': True|False,
'Settings': {
'RedshiftSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'PostgreSqlSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MySqlSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'OracleSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AsmServer': 'string',
'SecretsManagerOracleAsmSecretId': 'string',
'SecretsManagerOracleAsmAccessRoleArn': 'string',
'SecretsManagerSecurityDbEncryptionSecretId': 'string',
'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'SybaseAseSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'EncryptPassword': True|False,
'CertificateArn': 'string'
},
'MicrosoftSqlServerSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'DocDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string'
},
'MariaDbSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2LuwSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2zOsSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MongoDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AuthType': 'no'|'password',
'AuthSource': 'string',
'AuthMechanism': 'default'|'mongodb_cr'|'scram_sha_1'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
DataProviders (list) --
A description of data providers.
(dict) --
Provides information that defines a data provider.
DataProviderName (string) --
The name of the data provider.
DataProviderArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the data provider.
DataProviderCreationTime (datetime) --
The time the data provider was created.
Description (string) --
A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.
Engine (string) --
The type of database engine for the data provider. Valid values include "aurora", "aurora-postgresql", "mysql", "oracle", "postgres", "sqlserver", redshift, mariadb, mongodb, db2, db2-zos, docdb, and sybase. A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.
Virtual (boolean) --
Indicates whether the data provider is virtual.
Settings (dict) --
The settings in JSON format for a data provider.
RedshiftSettings (dict) --
Provides information that defines an Amazon Redshift data provider.
ServerName (string) --
The name of the Amazon Redshift server.
Port (integer) --
The port value for the Amazon Redshift data provider.
DatabaseName (string) --
The database name on the Amazon Redshift data provider.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
PostgreSqlSettings (dict) --
Provides information that defines a PostgreSQL data provider.
ServerName (string) --
The name of the PostgreSQL server.
Port (integer) --
The port value for the PostgreSQL data provider.
DatabaseName (string) --
The database name on the PostgreSQL data provider.
SslMode (string) --
The SSL mode used to connect to the PostgreSQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MySqlSettings (dict) --
Provides information that defines a MySQL data provider.
ServerName (string) --
The name of the MySQL server.
Port (integer) --
The port value for the MySQL data provider.
SslMode (string) --
The SSL mode used to connect to the MySQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
OracleSettings (dict) --
Provides information that defines an Oracle data provider.
ServerName (string) --
The name of the Oracle server.
Port (integer) --
The port value for the Oracle data provider.
DatabaseName (string) --
The database name on the Oracle data provider.
SslMode (string) --
The SSL mode used to connect to the Oracle data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AsmServer (string) --
The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.
SecretsManagerOracleAsmSecretId (string) --
The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.
Required only if your data provider uses the Oracle ASM server.
SecretsManagerOracleAsmAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.
SecretsManagerSecurityDbEncryptionSecretId (string) --
The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.
SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
SybaseAseSettings (dict) --
Provides information that defines an SAP ASE data provider.
ServerName (string) --
The name of the SAP ASE server.
Port (integer) --
The port value for the SAP ASE data provider.
DatabaseName (string) --
The database name on the SAP ASE data provider.
SslMode (string) --
The SSL mode used to connect to the SAP ASE data provider. The default value is none.
EncryptPassword (boolean) --
Specifies whether to encrypt the password when connecting to the Sybase ASE database. When set to true, the connection password is encrypted during transmission. Default is true.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MicrosoftSqlServerSettings (dict) --
Provides information that defines a Microsoft SQL Server data provider.
ServerName (string) --
The name of the Microsoft SQL Server server.
Port (integer) --
The port value for the Microsoft SQL Server data provider.
DatabaseName (string) --
The database name on the Microsoft SQL Server data provider.
SslMode (string) --
The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
DocDbSettings (dict) --
Provides information that defines a DocumentDB data provider.
ServerName (string) --
The name of the source DocumentDB server.
Port (integer) --
The port value for the DocumentDB data provider.
DatabaseName (string) --
The database name on the DocumentDB data provider.
SslMode (string) --
The SSL mode used to connect to the DocumentDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MariaDbSettings (dict) --
Provides information that defines a MariaDB data provider.
ServerName (string) --
The name of the MariaDB server.
Port (integer) --
The port value for the MariaDB data provider
SslMode (string) --
The SSL mode used to connect to the MariaDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2LuwSettings (dict) --
Provides information that defines an IBM DB2 LUW data provider.
ServerName (string) --
The name of the DB2 LUW server.
Port (integer) --
The port value for the DB2 LUW data provider.
DatabaseName (string) --
The database name on the DB2 LUW data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 LUW data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2zOsSettings (dict) --
Provides information that defines an IBM DB2 for z/OS data provider.
ServerName (string) --
The name of the DB2 for z/OS server.
Port (integer) --
The port value for the DB2 for z/OS data provider.
DatabaseName (string) --
The database name on the DB2 for z/OS data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 for z/OS data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MongoDbSettings (dict) --
Provides information that defines a MongoDB data provider.
ServerName (string) --
The name of the MongoDB server.
Port (integer) --
The port value for the MongoDB data provider.
DatabaseName (string) --
The database name on the MongoDB data provider.
SslMode (string) --
The SSL mode used to connect to the MongoDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AuthType (string) --
The authentication type for the database connection. Valid values are PASSWORD or NO.
AuthSource (string) --
The MongoDB database name. This setting isn't used when AuthType is set to "no".
The default is "admin".
AuthMechanism (string) --
The authentication method for connecting to the data provider. Valid values are DEFAULT, MONGODB_CR, or SCRAM_SHA_1.
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of extension pack associations for the specified migration project. An extension pack is an add-on module that emulates functions present in a source database that are required when converting objects to the target database.
See also: AWS API Documentation
Request Syntax
client.describe_extension_pack_associations(
MigrationProjectIdentifier='string',
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123
)
string
[REQUIRED]
The name or Amazon Resource Name (ARN) for the migration project.
list
Filters applied to the extension pack associations described in the form of key-value pairs.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
Requests (list) --
A paginated list of extension pack associations for the specified migration project.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of metadata model assessments for your account in the current region.
See also: AWS API Documentation
Request Syntax
client.describe_metadata_model_assessments(
MigrationProjectIdentifier='string',
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123
)
string
[REQUIRED]
The name or Amazon Resource Name (ARN) of the migration project.
list
Filters applied to the metadata model assessments described in the form of key-value pairs.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
Requests (list) --
A paginated list of metadata model assessments for the specified migration project.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of metadata model conversions for a migration project.
See also: AWS API Documentation
Request Syntax
client.describe_metadata_model_conversions(
MigrationProjectIdentifier='string',
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123
)
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
list
Filters applied to the metadata model conversions described in the form of key-value pairs.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
Requests (list) --
A paginated list of metadata model conversions.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of metadata model creation requests for a migration project.
See also: AWS API Documentation
Request Syntax
client.describe_metadata_model_creations(
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123,
MigrationProjectIdentifier='string'
)
list
Filters applied to the metadata model creation requests described in the form of key-value pairs. The supported filters are request-id and status.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of metadata model creation requests. If Marker is returned by a previous response, there are more metadata model creation requests available.
integer
The maximum number of metadata model creation requests to include in the response. If more requests exist than the specified MaxRecords value, a pagination token is provided in the response so that you can retrieve the remaining results.
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of metadata model creation requests. If Marker is returned, there are more metadata model creation requests available.
Requests (list) --
A list of metadata model creation requests. The ExportSqlDetails field will never be populated for the DescribeMetadataModelCreations operation.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of metadata model exports.
See also: AWS API Documentation
Request Syntax
client.describe_metadata_model_exports_as_script(
MigrationProjectIdentifier='string',
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123
)
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
list
Filters applied to the metadata model exports described in the form of key-value pairs.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
Requests (list) --
A paginated list of metadata model exports.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of metadata model exports.
See also: AWS API Documentation
Request Syntax
client.describe_metadata_model_exports_to_target(
MigrationProjectIdentifier='string',
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123
)
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
list
Filters applied to the metadata model exports described in the form of key-value pairs.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
Requests (list) --
A paginated list of metadata model exports.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Requests': {'Progress': {'ProcessedObject': {'EndpointType': 'string',
'Name': 'string',
'Type': 'string'},
'ProgressPercent': 'double',
'ProgressStep': 'string',
'TotalObjects': 'long'}}}
Returns a paginated list of metadata model imports.
See also: AWS API Documentation
Request Syntax
client.describe_metadata_model_imports(
MigrationProjectIdentifier='string',
Filters=[
{
'Name': 'string',
'Values': [
'string',
]
},
],
Marker='string',
MaxRecords=123
)
string
[REQUIRED]
The migration project name or Amazon Resource Name (ARN).
list
Filters applied to the metadata model imports described in the form of key-value pairs.
(dict) --
Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.
Name (string) -- [REQUIRED]
The name of the filter as specified for a Describe* or similar operation.
Values (list) -- [REQUIRED]
The filter value, which can specify one or more values used to narrow the returned results.
(string) --
string
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
integer
A paginated list of metadata model imports.
dict
Response Syntax
{
'Marker': 'string',
'Requests': [
{
'Status': 'string',
'RequestIdentifier': 'string',
'MigrationProjectArn': 'string',
'Error': {
'defaultErrorDetails': {
'Message': 'string'
}
},
'ExportSqlDetails': {
'S3ObjectKey': 'string',
'ObjectURL': 'string'
},
'Progress': {
'ProgressPercent': 123.0,
'TotalObjects': 123,
'ProgressStep': 'string',
'ProcessedObject': {
'Name': 'string',
'Type': 'string',
'EndpointType': 'string'
}
}
},
]
}
Response Structure
(dict) --
Marker (string) --
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.
Requests (list) --
A paginated list of metadata model imports.
(dict) --
Provides information about a schema conversion action.
Status (string) --
The schema conversion action status.
RequestIdentifier (string) --
The identifier for the schema conversion action.
MigrationProjectArn (string) --
The migration project ARN.
Error (dict) --
Provides error information about a project.
defaultErrorDetails (dict) --
Error information about a project.
Message (string) --
The error message.
ExportSqlDetails (dict) --
Provides information about a metadata model assessment exported to SQL.
S3ObjectKey (string) --
The Amazon S3 object key for the object containing the exported metadata model assessment.
ObjectURL (string) --
The URL for the object containing the exported metadata model assessment.
Progress (dict) --
Provides information about the progress of the schema conversion operation.
ProgressPercent (float) --
The percent complete for the current step of the schema conversion operation.
TotalObjects (integer) --
The number of objects in this schema conversion operation.
ProgressStep (string) --
The step of the schema conversion operation. This parameter can store one of the following values:
IN_PROGRESS – The operation is running.
LOADING_METADATA – Loads metadata from the source database.
COUNTING_OBJECTS – Determines the number of objects involved in the operation.
ANALYZING – Analyzes the source database objects.
CONVERTING – Converts the source database objects to a format compatible with the target database.
APPLYING – Applies the converted code to the target database.
FINISHED – The operation completed successfully.
ProcessedObject (dict) --
The name of the database object that the schema conversion operation currently uses.
Name (string) --
The name of the database object.
Type (string) --
The type of the database object. For example, a table, view, procedure, and so on.
EndpointType (string) --
The type of the data provider. This parameter can store one of the following values: "SOURCE" or "TARGET".
{'Settings': {'SybaseAseSettings': {'CertificateArn': 'string',
'DatabaseName': 'string',
'EncryptPassword': 'boolean',
'Port': 'integer',
'ServerName': 'string',
'SslMode': 'none | require | verify-ca | '
'verify-full'}}}
Response {'DataProvider': {'Settings': {'SybaseAseSettings': {'CertificateArn': 'string',
'DatabaseName': 'string',
'EncryptPassword': 'boolean',
'Port': 'integer',
'ServerName': 'string',
'SslMode': 'none | '
'require | '
'verify-ca | '
'verify-full'}}}}
Modifies the specified data provider using the provided settings.
See also: AWS API Documentation
Request Syntax
client.modify_data_provider(
DataProviderIdentifier='string',
DataProviderName='string',
Description='string',
Engine='string',
Virtual=True|False,
ExactSettings=True|False,
Settings={
'RedshiftSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'PostgreSqlSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MySqlSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'OracleSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AsmServer': 'string',
'SecretsManagerOracleAsmSecretId': 'string',
'SecretsManagerOracleAsmAccessRoleArn': 'string',
'SecretsManagerSecurityDbEncryptionSecretId': 'string',
'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'SybaseAseSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'EncryptPassword': True|False,
'CertificateArn': 'string'
},
'MicrosoftSqlServerSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'DocDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string'
},
'MariaDbSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2LuwSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2zOsSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MongoDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AuthType': 'no'|'password',
'AuthSource': 'string',
'AuthMechanism': 'default'|'mongodb_cr'|'scram_sha_1'
}
}
)
string
[REQUIRED]
The identifier of the data provider. 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.
string
The name of the data provider.
string
A user-friendly description of the data provider.
string
The type of database engine for the data provider. Valid values include "aurora", "aurora-postgresql", "mysql", "oracle", "postgres", "sqlserver", redshift, mariadb, mongodb, db2, db2-zos, docdb, and sybase. A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.
boolean
Indicates whether the data provider is virtual.
boolean
If this attribute is Y, the current call to ModifyDataProvider replaces all existing data provider settings with the exact settings that you specify in this call. If this attribute is N, the current call to ModifyDataProvider does two things:
It replaces any data provider settings that already exist with new values, for settings with the same names.
It creates new data provider settings that you specify in the call, for settings with different names.
dict
The settings in JSON format for a data provider.
RedshiftSettings (dict) --
Provides information that defines an Amazon Redshift data provider.
ServerName (string) --
The name of the Amazon Redshift server.
Port (integer) --
The port value for the Amazon Redshift data provider.
DatabaseName (string) --
The database name on the Amazon Redshift data provider.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
PostgreSqlSettings (dict) --
Provides information that defines a PostgreSQL data provider.
ServerName (string) --
The name of the PostgreSQL server.
Port (integer) --
The port value for the PostgreSQL data provider.
DatabaseName (string) --
The database name on the PostgreSQL data provider.
SslMode (string) --
The SSL mode used to connect to the PostgreSQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MySqlSettings (dict) --
Provides information that defines a MySQL data provider.
ServerName (string) --
The name of the MySQL server.
Port (integer) --
The port value for the MySQL data provider.
SslMode (string) --
The SSL mode used to connect to the MySQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
OracleSettings (dict) --
Provides information that defines an Oracle data provider.
ServerName (string) --
The name of the Oracle server.
Port (integer) --
The port value for the Oracle data provider.
DatabaseName (string) --
The database name on the Oracle data provider.
SslMode (string) --
The SSL mode used to connect to the Oracle data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AsmServer (string) --
The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.
SecretsManagerOracleAsmSecretId (string) --
The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.
Required only if your data provider uses the Oracle ASM server.
SecretsManagerOracleAsmAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.
SecretsManagerSecurityDbEncryptionSecretId (string) --
The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.
SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
SybaseAseSettings (dict) --
Provides information that defines an SAP ASE data provider.
ServerName (string) --
The name of the SAP ASE server.
Port (integer) --
The port value for the SAP ASE data provider.
DatabaseName (string) --
The database name on the SAP ASE data provider.
SslMode (string) --
The SSL mode used to connect to the SAP ASE data provider. The default value is none.
EncryptPassword (boolean) --
Specifies whether to encrypt the password when connecting to the Sybase ASE database. When set to true, the connection password is encrypted during transmission. Default is true.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MicrosoftSqlServerSettings (dict) --
Provides information that defines a Microsoft SQL Server data provider.
ServerName (string) --
The name of the Microsoft SQL Server server.
Port (integer) --
The port value for the Microsoft SQL Server data provider.
DatabaseName (string) --
The database name on the Microsoft SQL Server data provider.
SslMode (string) --
The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
DocDbSettings (dict) --
Provides information that defines a DocumentDB data provider.
ServerName (string) --
The name of the source DocumentDB server.
Port (integer) --
The port value for the DocumentDB data provider.
DatabaseName (string) --
The database name on the DocumentDB data provider.
SslMode (string) --
The SSL mode used to connect to the DocumentDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MariaDbSettings (dict) --
Provides information that defines a MariaDB data provider.
ServerName (string) --
The name of the MariaDB server.
Port (integer) --
The port value for the MariaDB data provider
SslMode (string) --
The SSL mode used to connect to the MariaDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2LuwSettings (dict) --
Provides information that defines an IBM DB2 LUW data provider.
ServerName (string) --
The name of the DB2 LUW server.
Port (integer) --
The port value for the DB2 LUW data provider.
DatabaseName (string) --
The database name on the DB2 LUW data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 LUW data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2zOsSettings (dict) --
Provides information that defines an IBM DB2 for z/OS data provider.
ServerName (string) --
The name of the DB2 for z/OS server.
Port (integer) --
The port value for the DB2 for z/OS data provider.
DatabaseName (string) --
The database name on the DB2 for z/OS data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 for z/OS data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MongoDbSettings (dict) --
Provides information that defines a MongoDB data provider.
ServerName (string) --
The name of the MongoDB server.
Port (integer) --
The port value for the MongoDB data provider.
DatabaseName (string) --
The database name on the MongoDB data provider.
SslMode (string) --
The SSL mode used to connect to the MongoDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AuthType (string) --
The authentication type for the database connection. Valid values are PASSWORD or NO.
AuthSource (string) --
The MongoDB database name. This setting isn't used when AuthType is set to "no".
The default is "admin".
AuthMechanism (string) --
The authentication method for connecting to the data provider. Valid values are DEFAULT, MONGODB_CR, or SCRAM_SHA_1.
dict
Response Syntax
{
'DataProvider': {
'DataProviderName': 'string',
'DataProviderArn': 'string',
'DataProviderCreationTime': datetime(2015, 1, 1),
'Description': 'string',
'Engine': 'string',
'Virtual': True|False,
'Settings': {
'RedshiftSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'PostgreSqlSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MySqlSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'OracleSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AsmServer': 'string',
'SecretsManagerOracleAsmSecretId': 'string',
'SecretsManagerOracleAsmAccessRoleArn': 'string',
'SecretsManagerSecurityDbEncryptionSecretId': 'string',
'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'SybaseAseSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'EncryptPassword': True|False,
'CertificateArn': 'string'
},
'MicrosoftSqlServerSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'DocDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string'
},
'MariaDbSettings': {
'ServerName': 'string',
'Port': 123,
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2LuwSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'IbmDb2zOsSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'S3Path': 'string',
'S3AccessRoleArn': 'string'
},
'MongoDbSettings': {
'ServerName': 'string',
'Port': 123,
'DatabaseName': 'string',
'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
'CertificateArn': 'string',
'AuthType': 'no'|'password',
'AuthSource': 'string',
'AuthMechanism': 'default'|'mongodb_cr'|'scram_sha_1'
}
}
}
}
Response Structure
(dict) --
DataProvider (dict) --
The data provider that was modified.
DataProviderName (string) --
The name of the data provider.
DataProviderArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the data provider.
DataProviderCreationTime (datetime) --
The time the data provider was created.
Description (string) --
A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.
Engine (string) --
The type of database engine for the data provider. Valid values include "aurora", "aurora-postgresql", "mysql", "oracle", "postgres", "sqlserver", redshift, mariadb, mongodb, db2, db2-zos, docdb, and sybase. A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.
Virtual (boolean) --
Indicates whether the data provider is virtual.
Settings (dict) --
The settings in JSON format for a data provider.
RedshiftSettings (dict) --
Provides information that defines an Amazon Redshift data provider.
ServerName (string) --
The name of the Amazon Redshift server.
Port (integer) --
The port value for the Amazon Redshift data provider.
DatabaseName (string) --
The database name on the Amazon Redshift data provider.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
PostgreSqlSettings (dict) --
Provides information that defines a PostgreSQL data provider.
ServerName (string) --
The name of the PostgreSQL server.
Port (integer) --
The port value for the PostgreSQL data provider.
DatabaseName (string) --
The database name on the PostgreSQL data provider.
SslMode (string) --
The SSL mode used to connect to the PostgreSQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MySqlSettings (dict) --
Provides information that defines a MySQL data provider.
ServerName (string) --
The name of the MySQL server.
Port (integer) --
The port value for the MySQL data provider.
SslMode (string) --
The SSL mode used to connect to the MySQL data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
OracleSettings (dict) --
Provides information that defines an Oracle data provider.
ServerName (string) --
The name of the Oracle server.
Port (integer) --
The port value for the Oracle data provider.
DatabaseName (string) --
The database name on the Oracle data provider.
SslMode (string) --
The SSL mode used to connect to the Oracle data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AsmServer (string) --
The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.
SecretsManagerOracleAsmSecretId (string) --
The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.
Required only if your data provider uses the Oracle ASM server.
SecretsManagerOracleAsmAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.
SecretsManagerSecurityDbEncryptionSecretId (string) --
The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.
SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --
The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
SybaseAseSettings (dict) --
Provides information that defines an SAP ASE data provider.
ServerName (string) --
The name of the SAP ASE server.
Port (integer) --
The port value for the SAP ASE data provider.
DatabaseName (string) --
The database name on the SAP ASE data provider.
SslMode (string) --
The SSL mode used to connect to the SAP ASE data provider. The default value is none.
EncryptPassword (boolean) --
Specifies whether to encrypt the password when connecting to the Sybase ASE database. When set to true, the connection password is encrypted during transmission. Default is true.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MicrosoftSqlServerSettings (dict) --
Provides information that defines a Microsoft SQL Server data provider.
ServerName (string) --
The name of the Microsoft SQL Server server.
Port (integer) --
The port value for the Microsoft SQL Server data provider.
DatabaseName (string) --
The database name on the Microsoft SQL Server data provider.
SslMode (string) --
The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
DocDbSettings (dict) --
Provides information that defines a DocumentDB data provider.
ServerName (string) --
The name of the source DocumentDB server.
Port (integer) --
The port value for the DocumentDB data provider.
DatabaseName (string) --
The database name on the DocumentDB data provider.
SslMode (string) --
The SSL mode used to connect to the DocumentDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
MariaDbSettings (dict) --
Provides information that defines a MariaDB data provider.
ServerName (string) --
The name of the MariaDB server.
Port (integer) --
The port value for the MariaDB data provider
SslMode (string) --
The SSL mode used to connect to the MariaDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2LuwSettings (dict) --
Provides information that defines an IBM DB2 LUW data provider.
ServerName (string) --
The name of the DB2 LUW server.
Port (integer) --
The port value for the DB2 LUW data provider.
DatabaseName (string) --
The database name on the DB2 LUW data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 LUW data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
IbmDb2zOsSettings (dict) --
Provides information that defines an IBM DB2 for z/OS data provider.
ServerName (string) --
The name of the DB2 for z/OS server.
Port (integer) --
The port value for the DB2 for z/OS data provider.
DatabaseName (string) --
The database name on the DB2 for z/OS data provider.
SslMode (string) --
The SSL mode used to connect to the DB2 for z/OS data provider. The default value is none. Valid Values: none and verify-ca.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
S3Path (string) --
The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.
S3AccessRoleArn (string) --
The ARN for the role the application uses to access its Amazon S3 bucket.
MongoDbSettings (dict) --
Provides information that defines a MongoDB data provider.
ServerName (string) --
The name of the MongoDB server.
Port (integer) --
The port value for the MongoDB data provider.
DatabaseName (string) --
The database name on the MongoDB data provider.
SslMode (string) --
The SSL mode used to connect to the MongoDB data provider. The default value is none.
CertificateArn (string) --
The Amazon Resource Name (ARN) of the certificate used for SSL connection.
AuthType (string) --
The authentication type for the database connection. Valid values are PASSWORD or NO.
AuthSource (string) --
The MongoDB database name. This setting isn't used when AuthType is set to "no".
The default is "admin".
AuthMechanism (string) --
The authentication method for connecting to the data provider. Valid values are DEFAULT, MONGODB_CR, or SCRAM_SHA_1.