SQL Server

Connector Details

Connector AttributesDetails
NameMicrosoft SQL Server
DescriptionMicrosoft 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 TypeClass A


Feature NameFeature Details
Load StrategiesFull Load, Incremental Load
Metadata ExtractionSupported
Data AcquisitionSupported
Data PublishingNot Supported
Automated Schema Drift HandlingSupported

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringSQLServerConnection
Server NameStringsqlserver.example.com
Database NameStringmydatabase
User NameStringmyuser
Always EncryptedBooleanTrue or False
Trust Server CertificateBooleanTrue or False
Connection TimeoutNumeric30
EncryptBooleanTrue or False
Persist Security InfoBooleanTrue or False
Bronze Schema (Optional)String
Silver Schema (Optional)String

Connector Specific Configuration Details

  1. Trust Server Certificate = False is the default value, if Trust Server Certificate is not defined
  2. Persist Security Info=False is the default value, if Persist Security Info is not defined
  3. Connection Timeout=30 is the default value, if Connection Timeout is not defined
  4. Encrypt = True is the default value, if Encrypt is not defined
  5. SQL Server connector has optional values such as Bronze Schema and Silver Schema

Screenshot To Use Connector