PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows.
PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors.
To create a connection to the PostgreSQL Database Data Source, right-click on the Data Sources group, click “Postgres”, and then select “PostgreSQL Database”.
To successfully retrieve data from a PostgreSQL Database data source, the following properties need to be set.
|
Name to identify the data source. |
|
Location of the Oracle Database (Server Name or IP Address). |
|
Name of the Database to connect to. |
|
The port number the PostgreSQL instance is running on. |
|
MySQL authentication username. If left blank, Windows authentication will be used. |
|
MySQL authentication password. If left blank, Windows authentication will be used. |
|
Timeout for SQL queries. The default is 15 seconds. |
|
Definition settings to create a custom namespace as per your database schema. |
|
Maximum pooling count size for the MySQL connection. The default is 100. |