| Connector Attributes | Details |
|---|
| Name | Azure PostgreSQL |
| Description | Azure Database for PostgreSQL is a fully managed database service provided by Microsoft Azure, offering developers a reliable platform to build modern applications. Leveraging the capabilities of PostgreSQL, Azure provides features such as automated backups, high availability, and security enhancements, reducing the administrative burden on developers and enabling them to focus on application development. With support for popular PostgreSQL extensions and seamless integration with other Azure services, developers can leverage familiar tools and frameworks while benefiting from Azure's scalability and global presence. Whether for small-scale applications or enterprise workloads, Azure PostgreSQL offers a flexible and cost-effective solution for hosting PostgreSQL databases in the cloud, backed by Microsoft's commitment to reliability and innovation. |
| 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 |
|---|
| Server Name | String | myazurepg-server.postgres.database.azure.com |
| Database Name | String | mydatabase |
| Port | Numeric | 5432 |
| User ID | String | myuser@myazurepg-server |
| Password | String | mypassword |
| SSL Mode | List | Required |
| Bronze Schema (Optional) | String | |
| Silver Schema (Optional) | String | |
- SSL Mode = Required is the default value, if SSL Mode is not defined
- Azure PostgreSQL connector has optional values such as Bronze Schema and Silver Schema
Updated about 2 months ago
