PostgreSQL
Connector Details
| 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 |
Features
| 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 |
Source Connection Attributes
| 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 |
Connector Specific Configuration Details
- 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
Screenshot To Use Connector
Updated 20 days ago