PostgreSQL

Versions

This connector can be used to get data from local or remote PostgreSQL Server installations with the following version :

• Postgre15 and later

Selecting Connection Type

In the “Create Connection” dialog, change the Connection “Type” by selecting “Postgre” :

Connection Parameters

Server

This is the address of the Postgre Server instance you need to access. Possible values are :

(local) or localhost : local server

< IPv4Address > : server accessible through a IP v4 address
< IPv6Address > : server accessible through a IP v6 address
< server address >\< instance name > : connect to a specific instance.

Be aware that when searching for a server instance, Alpana waits for a response. If the server instance doesn’t respond, there is a rather long timeout.

Authentication Mode

“Postgre” : will use Postgre Server authentication with “User name” and “Password”.

Database

The name of the database to connect to.

Detection
This lets you select the database name from the list of databases.

*Tip : After changing credentials, you can fetch again a new list of database names, by clicking the refresh icon.

Manual
This lets you write the database name as free text.

This is useful for creating a connection to a database which you cannot access while in the Designer.
For example when the database name is different in the production environment.

Test Connection

To test the connection for validity, click “Test Connection” button. The following confirmation message will confirm its validity.

Connection Schema
The SQL Server Connector fetches the following object types in the database schema :

Tables
Views
Functions

Data refresh and Buffer
The Postgre Connector is not bufferized by default.

However, when data is joined with another Alpana Connection (including another SQL Connection), data is bufferized or we can manually force it to be bufferized.

If you need to get new data, see Chapter The data Buffer

Code192 2020 All rights reserved