SQL Server Destination Connector
The SQL Server destination connector writes extracted and transformed data from DataSync into a Microsoft SQL Server database, whether hosted on-premises or in the cloud. It serves as the storage destination for your reporting and analytics. Once your destination connections is ready, create your extraction to define what data gets loaded and how.
Create the destination connection in DataSync
- Log in to DataSync.
- From the welcome screen, select Connections.
- Next to Destination Connections, click New.
- Select SQL Server.
- Enter all required connection properties.
- (Optional) In the Additional Connection Properties panel, click Add property and enter any advanced parameters.
- Click Save.
Connection properties
| Property | What to enter |
|---|---|
| Description | Unique name for the connection. Example: SQL Server. |
| Server | Server name or IP address of the SQL Server database. 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 database. Example: dbadmin. |
| Password | Password for this account. |
| Timeout | Time in seconds to wait before a connection attempt or query execution times out. |
| Encrypt | Enables SSL encryption for the connection. Recommended when data security is a priority. |
| Trust Server Certificate | Bypasses SSL certificate validation. Enable only if your server uses a self-signed certificate. |
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. |