SQL RDS Source Connector
The SQL RDS source connector in DataSync lets you retrieve data from an Amazon Relational Database Service (RDS) SQL Server instance for loading or synchronizing in your data warehouse. After creating all required source connections, configure your destination source to complete the connection setup.
Create source connections in DataSync
- Log in to DataSync.
- From the welcome screen, select Connections.
- Next to Source Connections, click New.
- Select SQL RDS.
- In the Connection Properties panel, enter the connection properties.
- (Optional) In the Additional Connection Properties panel, select Add property and enter the parameters for each property.
- In the Advanced Settings panel, configure the settings, including the Tracking Type and other values according to your requirements.
- Click Save.
Parameters
Connection properties
| Parameter | Description |
|---|---|
| Description | Unique name for the connection. Example: SQL RDS. |
| Server | Fully qualified domain name (FQDN) 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 SQL Server instance. Example: SalesDB |
| Username | Login account for accessing the RDS SQL Server database. Example: dbadmin |
| Password | Password for the specified username. |
| Timeout | Time in seconds to wait for connection opening and query execution before timeout. |
Additional connection properties
Additional connection string properties not specified in the Connection Properties panel. For each property added, you can choose Visible or Encrypted. Selecting Encrypted hides the value from the interface and stores it encrypted in the back end, such as when defining passwords.
| Parameter | Description |
|---|---|
| Property | Connection string property that defines the action or behavior. Example: ReadOnly |
| Value | Value for the property. Example: True |
| Type | Visibility of the property: Visible or Encrypted. |
Advanced settings
Advanced settings control how the SQL RDS connector tracks changes, handles regional and time configuration, and processes data batches during extraction. These options allow fine‑tuning for performance and accuracy, and should be configured according to your system environment and operational requirements.
| Setting | Description |
|---|---|
| Tracking Type | Method for tracking changes: None or Date. |
| Region | Region setting for the connector, if required by your setup. |
| Time Zone | Time zone matching the SQL RDS application server. |
| Time Offset | Refresh offset in seconds to compensate for timing issues in record selection. Minimum value is 0; maximum is 3600 seconds. |
| Batch Size | Quantity of records processed in each batch during extraction. Larger batch sizes increase memory usage but can improve performance up to a point. The default value is 2000 and the maximum should not exceed 10000 records. Adjust according to your network speed and disk performance; in most cases the default (2000) works best. |