Azure SQL Server
Connector Details
| Connector Attributes | Details |
|---|---|
| Name | Azure SQL Server |
| Description | Azure 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 Type | Class A |
Features
| Feature Name | Feature Details |
|---|---|
| Load Strategies | Full Load, Incremental Load |
| Metadata Extraction | Supported |
| Data Acquisition | Supported |
| Data Publishing | Supported |
| Automated Schema Drift Handling | Supported |
Source Connection Attributes
| Connection Parameters | Data Type | Example |
|---|---|---|
| Connection Name | String | AzureSQLConnection |
| Server Name | String | myazuresqlserver.database.windows.net |
| Database Name | String | mydatabase |
| User Name | String | myuser@myazuresqlserver |
| 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 |
Connector Specific Configuration Details
- 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
Screenshot To Use Connector
Updated 8 months ago