Azure SQL Server

Connector Details

Connector AttributesDetails
NameAzure SQL Server
DescriptionAzure SQL Database is a fully managed relational database service provided by Microsoft Azure, offering developers a scalable and cost-effective platform to build cloud-native applications. With features like automatic tuning, built-in high availability, and advanced security capabilities, Azure SQL Database simplifies database management tasks, enabling developers to focus on application development. Its compatibility with SQL Server and seamless integration with other Azure services facilitate hybrid and cloud-native deployments, while intelligent optimization capabilities ensure optimal performance and resource utilization. Whether for small-scale applications or enterprise workloads, Azure SQL Database offers a flexible and reliable solution for hosting SQL Server databases in the cloud, backed by Microsoft's commitment to innovation and customer support.
Connector TypeClass A


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

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringAzureSQLConnection
Database NameStringmydatabase
User NameStringmyuser@myazuresqlserver
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

Screenshot To Use Connector