flowground for Business Customers
PostgreSQL
Connector for

PostgreSQL

Simple SQL query against PostgreSQL. The PostgreSQL connector works with the PostgreSQL database and also works with AWS Redshift. It supports both trigger and action functionalities, i.e. You can respond to a specific event or run a specific event.

Functions and use cases

PostgreSQL Select Statements in an integration workflow

As a developer of an integration workflow, I want to specifically access certain data from a PostgreSQL database for further workflow use. The query results are made available as input to the next connector in the workflow.

Changes to PostgreSQL databases in an integration workflow

As a developer of an integration workflow, I want to perform database operations such as INSERT, UPDATE, or DELETE on a PostgreSQL database to create data between different systems to keep it consistent.

Specifications
  • Category: Developer Tools
  • Provider: elastic.io GmbH
  • Used API: telekom
  • Managed: -
  • License: Apache 2.0
  • Programmed with: javascript
Prices

For productive use you need a project room, which is subject to a fee.

Prices and Editions
Changelog

Revision: Version number: 1

Last change 09/11/2018

Technical Specifications

sqlQuery

Ausführen eines Querys

OnInit
./lib/actions/sqlQuery.js
OnStartup
-
OnClose
-

Attributes

-

selectTrigger

Auswahl eines Triggers, z.B. SELECT * FROM films WHERE title LIKE ${'%' + query + '%'}

OnInit
./lib/actions/select.js
OnStartup
-
OnClose
-

Attributes

-

insert

Einfügen, z.B. INSERT INTO films (code,title,kind) VALUES (${code},${title},${kind})

OnInit
./lib/actions/insert.js
OnStartup
-
OnClose
-

Attributes

-

selectAction

OnInit
./lib/actions/select.js
OnStartup
-
OnClose
-

Attributes

-

No data available for terms

No data available for environment