Azure PostgreSQL

Connector Details

Connector AttributesDetails
NameAzure PostgreSQL
DescriptionAzure 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 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
Database NameStringmydatabase
User IDStringmyuser@myazurepg-server
SSL ModeListRequired
Bronze Schema (Optional)String
Silver Schema (Optional)String

Connector Specific Configuration Details

  1. SSL Mode = Required is the default value, if SSL Mode is not defined
  2. Azure PostgreSQL connector has optional values such as Bronze Schema and Silver Schema

Screenshot To Use Connector