Menu
AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

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

  1. 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.

    
                                 Advanced section
  2. Wait for the status to say Replication instance created successfully..

  3. To test the source and target connections, choose Run Test for the source and target connections.

  4. Choose Next.