Step 8: Create AWS DMS Source and Target Endpoints
While your replication instance is being created, you can specify the source and target database endpoints using the AWS Management Console. However, you can only test connectivity after the replication instance has been created, because the replication instance is used in the connection.
To specify source or target database endpoints using the AWS console
-
Specify your connection information for the source Oracle database and the target Amazon Redshift database. The following table describes the source settings.
For This Parameter Do This Endpoint Identifier
Type
Orasource
(the Amazon RDS Oracle endpoint).Source Engine
Choose oracle.
Server name
Provide the Oracle DB instance name. This name is the Server name value that you used for AWS SCT, such as "abc123567.abc87654321.us-west-2.rds.amazonaws.com".
Port
Type
1521
.SSL mode
Choose None.
Username
Type oraadmin
.Password
Type
oraadmin123
.SID
Type
ORCL
.The following table describes the target settings.
For This Parameter Do This Endpoint Identifier
Type
Redshifttarget
(the Amazon Redshift endpoint).Target Engine
Choose redshift.
Servername
Provide the Amazon Redshift DB instance name. This name is the Server name value that you used for AWS SCT, such as
."oracletoredshiftdwusingdms-redshiftcluster-abc123567.abc87654321.us-west-2.redshift.amazonaws.com"
.Port
Type
5439
.SSL mode
Choose None.
Username
Type
redshiftadmin
.Password
Type
Redshift#123
.Database name
Type
test
.The completed page should look like the following.
-
Wait for the status to say Replication instance created successfully..
-
To test the source and target connections, choose Run Test for the source and target connections.
-
Choose Next.