Follow

Data Source - PostgreSQL Database

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 LinuxFreeBSDOpenBSD, and Windows.

PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable viewsmaterialized viewstriggers, 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”.

DataSources-ConnectPostgreSQLDB.png

To successfully retrieve data from a PostgreSQL Database data source, the following properties need to be set.

DataSources-PostgreSQLDBProperties.png

  • Name (String)
Name to identify the data source.
  • Server (String)
Location of the Oracle Database (Server Name or IP Address).
  • Database (String)
Name of the Database to connect to.
  • Port (Int)
The port number the PostgreSQL instance is running on.
  • Username (String)
MySQL authentication username. If left blank, Windows authentication will be used.
  • Password (String)
MySQL authentication password. If left blank, Windows authentication will be used.
  • Timeout (Int)
Timeout for SQL queries. The default is 15 seconds.
  • Definition (File location. JSON formatted file)
Definition settings to create a custom namespace as per your database schema.
  • Maximum Concurrent (Int)
Maximum pooling count size for the MySQL connection. The default is 100.
   
Note: The PostgreSQL data source connector also supports the use of a custom namespace by means of a definition file. Also, refer to the Microsoft SQL Data Source for sample queries.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments