Connector Attributes | Details |
---|
Name | PostgreSQL |
Description | PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and advanced features. It offers ACID compliance, concurrency control, and support for complex data types, making it suitable for a wide range of applications, from small projects to large-scale enterprise systems. With features like table inheritance, full-text search, and JSON support, PostgreSQL provides developers with flexibility and versatility in designing data models and querying data. Its active community, regular updates, and extensive documentation ensure ongoing support and innovation, making PostgreSQL a popular choice for businesses and developers seeking a reliable and feature-rich database solution. |
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 | mypostgres-server.example.com |
Database Name | String | mydatabase |
Port | Numeric | 5432 |
User ID | String | myuser |
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
- PostgreSQL connector has optional values such as Bronze Schema and Silver Schema
Updated about 2 months ago