SQL RDS Destination Connector

The SQL RDS destination connector writes extracted and transformed data from DataSync into a Microsoft SQL Server instance hosted on Amazon RDS. It serves as the storage destination for your reporting and analytics. Once your destination connection is ready, create your extraction to define what data gets loaded and how.

Create the destination connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Destination Connections, click New.
4. Select SQL RDS.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any advanced parameters.
7. Click Save.

Connection properties

Property	What to enter
Description	Unique name for the connection. Example: SQL RDS.
Server	Domain name of the Amazon RDS SQL Server instance. Example: mydbinstance.abcdefg12345.us-east-1.rds.amazonaws.com.
Database	Name of the database hosted on the RDS instance. Example: SalesDB.
Username	Login account for accessing the database. Example: dbadmin.
Password	Password for this account.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
Property	Connection string property that defines the action or behavior. Example: ReadOnly.
Value	Value for the property. Example: True.
Type	Visibility settings: Visible or Encrypted.