AWS dms: DMS offline source adds Oracle engine and clarifies Virtual Mode secrets
Summary
Documents that offline source data providers now support Oracle in addition to SQL Server, generalizes the engine settings object (MicrosoftSqlServerSettings/OracleSettings), updates port examples, and adds a note that the Secrets Manager secret and IAM role are optional for Virtual Mode data providers.
Security assessment
The change is primarily a feature/engine-support update, but it also documents credential handling (Secrets Manager secret and IAM role) for Virtual Mode data providers, noting they are optional and must meet secret requirements. This is security-adjacent guidance rather than a fix for a specific vulnerability.
Evidence
The AWS Secrets Manager secret and IAM role are optional for a data provider in **Virtual Mode** when you later use it in a migration project. If you choose to provide a secret, it must meet the requirements in [Create Secrets Manager secrets](./set-up.html#set-up-secrets).
Diff
diff --git a/dms/latest/userguide/getting-started-data-providers.md b/dms/latest/userguide/getting-started-data-providers.md index 842d15a..ca8e48a 100644 --- a//dms/latest/userguide/getting-started-data-providers.md +++ b//dms/latest/userguide/getting-started-data-providers.md @@ -30 +30 @@ There are two use cases where **Virtual Mode** applies: - * Offline source – Convert schemas from exported script files without connecting to the source database. Offline source is currently available for Microsoft SQL Server. + * Offline source – Convert schemas from exported script files without connecting to the source database. Offline source is currently available for Microsoft SQL Server and Oracle. @@ -88 +88 @@ Replace the following: -To create an offline source data provider, use the [create-data-provider](https://docs.aws.amazon.com/cli/latest/reference/dms/create-data-provider.html) command with the `--virtual` flag and the S3 settings in the engine configuration. +To create an offline source data provider, use the [create-data-provider](https://docs.aws.amazon.com/cli/latest/reference/dms/create-data-provider.html) command with the `--virtual` flag and the S3 settings in the engine configuration. Offline source supports `sqlserver` and `oracle` engines. For the engine-specific settings object, use `MicrosoftSqlServerSettings` or `OracleSettings`. @@ -93,5 +93,5 @@ To create an offline source data provider, use the [create-data-provider](https: - --engine sqlserver \ - --settings '{"MicrosoftSqlServerSettings": - {"ServerName": "my-source-server", - "Port": 1433, - "DatabaseName": "MyDatabase", + --engine engine-type \ + --settings '{"EngineSettings":{ + "ServerName":"my-source-server", + "Port":port, + "DatabaseName":"database-name", @@ -100 +100,2 @@ To create an offline source data provider, use the [create-data-provider](https: - "S3AccessRoleArn": "arn:aws:iam::111122223333:role/my-s3-read-role"}}' \ + "S3AccessRoleArn":"arn:aws:iam::111122223333:role/my-s3-read-role" + }}' \ @@ -106,0 +108 @@ Offline source settings Setting | Required | Description +`EngineSettings`| Yes| The engine-specific settings object. Allowed values for offline source: `MicrosoftSqlServerSettings`, `OracleSettings`. @@ -108 +110 @@ Offline source settings Setting | Required | Description -`Port`| Yes| Standard port for the engine (1433 for SQL Server). No connection is made. +`Port`| Yes| Standard port for the engine (1433 for SQL Server, 1521 for Oracle). No connection is made. @@ -143,0 +146,4 @@ For more information about virtual mode, see [Virtual target](./virtual-data-pro +###### Note + +The AWS Secrets Manager secret and IAM role are optional for a data provider in **Virtual Mode** when you later use it in a migration project. If you choose to provide a secret, it must meet the requirements in [Create Secrets Manager secrets](./set-up.html#set-up-secrets). +