Working with AWS DMS Endpoints
An endpoint provides connection, data store type, and location information about your data store. AWS Database Migration Service uses this information to connect to a data store and migrate data from a source endpoint to a target endpoint. You can specify additional connection attributes for an endpoint by using extra connection attributes. These attributes can control logging, file size, and other parameters; for more information about extra connection attributes, see the documentation section for your data store.
Following, you can find out more details about endpoints.
Creating Source and Target Endpoints
You can create source and target endpoints when you create your replication instance or you can create endpoints after your replication instance is created. The source and target data stores can be on an Amazon Elastic Compute Cloud (Amazon EC2) instance, an Amazon Relational Database Service (Amazon RDS) DB instance, or an on-premises database.
The procedure following assumes that you have chosen the AWS DMS console wizard. Note that you can also do this step by selecting Endpoints from the AWS DMS console's navigation pane and then selecting Create endpoint. When using the console wizard, you create both the source and target endpoints on the same page. When not using the console wizard, you create each endpoint separately.
To specify source or target database endpoints using the AWS console
-
On the Connect source and target database endpoints page, specify your connection information for the source or target database. The following table describes the settings.
For This Option Do This Endpoint type
Choose whether this endpoint is the source or target endpoint.
Select RDS DB Instance
Choose this option if the endpoint is an Amazon RDS DB instance.
Endpoint identifier
Type the name you want to use to identify the endpoint. You might want to include in the name the type of endpoint, such as
oracle-sourceorPostgreSQL-target. The name must be unique for all replication instances.Source engine and Target engine
Choose the type of database engine that is the endpoint.
Server name
Type the server name. For an on-premises database, this can be the IP address or the public hostname. For an Amazon RDS DB instance, this can be the endpoint (also called the DNS name) for the DB instance, such as
mysqlsrvinst.abcd12345678.us-west-2.rds.amazonaws.com.Port
Type the port used by the database.
SSL mode
Choose an SSL mode if you want to enable connection encryption for this endpoint. Depending on the mode you select, you might be asked to provide certificate and server certificate information.
User name
Type the user name with the permissions required to allow data migration. For information on the permissions required, see the security section for the source or target database engine in this user guide.
Password
Type the password for the account with the required permissions. If you want to use special characters in your password, such as "+" or "&", enclose the entire password in curly braces "{}".
Database name
The name of the database you want to use as the endpoint.
-
Choose the Advanced tab, shown following, to set values for connection string and encryption key if you need them. You can test the endpoint connection by choosing Run test.
For This Option Do This Extra connection attributes
Type any additional connection parameters here. For more information about extra connection attributes, see the documentation section for your data store.
KMS master key
Choose the encryption key to use to encrypt replication storage and connection information. If you choose (Default) aws/dms, the default AWS Key Management Service (AWS KMS) key associated with your account and region is used. For more information on using the encryption key, see Setting an Encryption Key and Specifying KMS Permissions.
Test endpoint connection (optional)
Add the VPC and replication instance name. To test the connection, choose Run test.