SQL Server
DLH.io documentation for SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
DLH.io synchronizes SQL Server databases to Snowflake better than other platforms because we're experts in SQL Server technology as well, so we've baked-in features like the ability to:
- Toggle the requirement for using or not using Primary Keys on tables
- This is a differentiator that you will NOT find in any other replication tool in the world today including the companies funded with $100s of millions of dollars
- Leverage timestamps for tracking changes
- Use Change Tracking or Change Data Capture (CDC)
Documentation Available for Integrating SQL Server with DLH.io:
- Basic SQL Server Setup: Basic SQL Server Setup
- Change Log: (see change log)
Setup Instructions
Follow the setup steps guide for configuring your SQL Server connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.