# Step 4: Test the Connectivity to the Amazon Redshift Database
<a name="chap-rdsoracle2redshift.steps.connectredshift"></a>

Next, test your connection to your Amazon Redshift database.

1. In SQL Workbench/J, choose **File**, then choose **Connect window**. Choose the **Create a new connection profile** icon. Connect to the Amazon Redshift database in SQL Workbench/J by using the information shown following.


<table>
<thead>
  <tr><th>Parameter</th><th>Action</th></tr>
</thead>
<tbody>
  <tr><td> <b>New profile</b> name</td><td>Enter <code>RedshiftConnection</code>.</td></tr>
  <tr><td> <b>Driver</b> </td><td>Choose <code>Redshift (com.amazon.redshift.jdbc42.Driver)</code>.</td></tr>
  <tr><td> <b>URL</b> </td><td>Use the <b>RedshiftJDBCConnectionString</b> value you recorded when you examined the output details of the DMSdemo stack in a previous step.</td></tr>
  <tr><td> <b>Username</b> </td><td>Enter <code>redshiftadmin</code>.</td></tr>
  <tr><td> <b>Password</b> </td><td>Enter <code>Redshift#123</code>.</td></tr>
</tbody>
</table>


1. Test the connection by choosing **Test**. Choose **OK** to close the dialog box, then choose **OK** to create the connection profile.  
![Connecting to the Amazon Redshift DB instance](https://docs.aws.amazon.com/dms/latest/sbs/images/sbs-rdsor2redshift10.png)
**Note**  
If your connection is unsuccessful, ensure that the IP address you assigned when creating the AWS CloudFormation template is the one you are attempting to connect from. This issue is the most common one when trying to connect to an instance.

1. Verify your connectivity to the Amazon Redshift DB instance by running a sample SQL command, such as `select current_date;`.