Amazon Schema Conversion Tool Connection error with Redshift as target database

0

I have selected Oracle DB as my source database and AWS Redshift as target in Schema Conversion Tool. Connection to source is successful though while connecting to Redshift I am getting an error. Where can I find the server name in Redshift service dashboard ?

Server port - 5439 Database - dev Connection name - Redshift

1 réponse
0

Hi,

The Server Name for Redshift in the AWS Schema Conversion Tool is usually the Redshift endpoint without the port number and the database name.

The endpoint can be found on the Redshift console => clusters => click on the appropriate cluster => General Information => Endpoint.

Also make sure that the Redshift Security Group accepts the necessary connections (inbound rules).

You can find on the following link the Step-by-Step migration process https://docs.aws.amazon.com/dms/latest/sbs/chap-rdsoracle2redshift.steps.html

Thanks.

AWS
EXPERT
Ziad
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions