SQL Server Destination Connector
The SQL Server destination connector in DataSync lets you write extracted and transformed data into Microsoft SQL Server. This connector supports integration into on‑premises or cloud‑hosted SQL Server databases for storage, reporting, and analytics. After creating all required destination connections, create your extraction.
Create a destination connection in DataSync
- Log in to DataSync.
- From the welcome screen, select Connections.
- Next to Destination Connections, click New.
- Select SQL Server.
- 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.
- Click Save.
Parameters
Connection properties
| Parameter | Description |
|---|---|
| Description | Unique name for the connection. Example: SQL Server. |
| Server | Fully qualified server name or IP address where the SQL Server database is hosted. Example: SQLSERVER01\MAIN or 192.168.1.50,1433 |
| Database | Name of the SQL Server database to connect to. Example: SalesDB |
| Username | Login account for accessing the 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. |
| Encrypt | SSL encryption option for securing the SQL Server connection and reducing data loss risk even if access controls are bypassed. |
| Trust Server Certificate | SSL trust override option that bypasses certificate chain validation while maintaining encryption. |
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. |