| Connector Attributes | Details |
|---|
| Name | Microsoft SQL Server |
| Description | Microsoft SQL Server is a comprehensive relational database management system (RDBMS) renowned for its performance, security, and scalability. Offering a range of editions tailored to various needs, SQL Server caters to small businesses, enterprises, and cloud-based applications alike. With features like Always On availability groups for high availability, Transparent Data Encryption (TDE) for data security, and column store indexes for analytical processing, SQL Server provides robust solutions for mission-critical workloads. Its integration with Azure services enables hybrid and cloud-native deployments, while tools like SQL Server Management Studio (SSMS) streamline database administration tasks. With continuous updates and advancements, Microsoft SQL Server remains a top choice for organizations seeking a reliable and feature-rich database solution. |
| Connector Type | Class A |
| Feature Name | Feature Details |
|---|
| Load Strategies | Full Load, Incremental Load |
| Metadata Extraction | Supported |
| Data Acquisition | Supported |
| Data Publishing | Not Supported |
| Automated Schema Drift Handling | Supported |
| Connection Parameters | Data Type | Example |
|---|
| Connection Name | String | SQLServerConnection |
| Server Name | String | sqlserver.example.com |
| Database Name | String | mydatabase |
| User Name | String | myuser |
| Password | String | mypassword |
| Always Encrypted | Boolean | True or False |
| Trust Server Certificate | Boolean | True or False |
| Connection Timeout | Numeric | 30 |
| Encrypt | Boolean | True or False |
| Persist Security Info | Boolean | True or False |
| Bronze Schema (Optional) | String | |
| Silver Schema (Optional) | String | |
- Trust Server Certificate = False is the default value, if Trust Server Certificate is not defined
- Persist Security Info=False is the default value, if Persist Security Info is not defined
- Connection Timeout=30 is the default value, if Connection Timeout is not defined
- Encrypt = True is the default value, if Encrypt is not defined
- SQL Server connector has optional values such as Bronze Schema and Silver Schema
Updated about 2 months ago
