flowground for Business Customers
Database
Connector for

Database

The database connector works with object-relational database management systems. Database is a generic connector for multiple databases that you can connect to, such as MySQL, PostgreSQL, or Oracle. It supports both trigger and action functionalities, i.e. You can use it either to run or act on a specific event, such as creating or updating records.

Functions and use cases

Integration of database queries in an integration workflow

As the developer of an integration workflow, I would like to access specific data in a database in order to use it in the rest of the workflow. Essentially, simple select statements are available for this purpose.

Specifications
  • Category: Developer Tools
  • Provider: elastic.io GmbH
  • Used API: Oracle
  • Managed: -
  • License: Proprietär
  • Programmed with: java
Prices

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

Prices and Editions
Changelog

Revision: Version number: 7

Last change 09/12/2018

Technical Specifications

getRowsPolling

Führt eine Operation aus, die potenziell mehrere Zeilen aus der Datenbank aus dem letzten Zeitstempel-Snapshot abfragt.

OnInit
io.elastic.jdbc.triggers.GetRowsPollingTrigger
OnStartup
-
OnClose
-

Attributes

-

selectTrigger

Führt eine SELECT-Anweisung aus, die potenziell mehrere Zeilen aus der Datenbank holt.

OnInit
io.elastic.jdbc.triggers.SelectTrigger
OnStartup
-
OnClose
-

Attributes

-

lookupRowByPrimaryKey

Führt eine Operation aus, die genau eine Zeile nach Primärschlüssel von der Datenbank holen soll.

OnInit
io.elastic.jdbc.actions.LookupRowByPrimaryKey
OnStartup
-
OnClose
-

Attributes

-

upsertRowByPrimaryKey

Führt das Upsert nach Primärschlüssel durch.

OnInit
io.elastic.jdbc.actions.UpsertRowByPrimaryKey
OnStartup
-
OnClose
-

Attributes

-

deleteRowByPrimaryKey

Führt eine Operation aus, die genau eine Zeile nach Primärschlüssel aus der Datenbank entfernen soll.

OnInit
io.elastic.jdbc.actions.DeleteRowByPrimaryKey
OnStartup
-
OnClose
-

Attributes

-

selectAction

Führt eine SELECT-Anweisung aus, die potenziell mehrere Zeilen aus der Datenbank holt.

OnInit
io.elastic.jdbc.actions.SelectAction
OnStartup
-
OnClose
-

Attributes

-

No data available for terms

No data available for environment