Relational Databases

Most recent version: v0.0.1

See the changelog of this Data sink type here.

Overview

The Relational Databases Data sink lets you send SQL sentences to your desired database.

Configuration

Now you need to specify how and where to send the data, and how to establish a connection with your database.

Metadata

Enter the basic information for the new Data sink.

Parameters
Description

Name*

Enter a name for the new Data Sink.

Description

Optionally, enter a description for the Data Sink.

Tags

Add tags to easily identify your Sink. Hit the Enter key after you define each tag.


Metrics

Decide whether or not to include this Data sink info in the metrics and graphs of the Home area.


Configuration

Now add the configuration to establish the connection.

Parameter
Description

Database Type*

Onum supports four types of databases:

  • MySql

  • PostgresSql

  • Oracle

  • SqlServer

Connection parameters

Specify where in this database to connect to and who to connect.

Parameters
Description

User*

The user to connect.

Password*

Add the password from your list of Secrets or create one.

Host*

The host URL for the database.

Port*

The port to connect to.

Database name*

The name of the database you wish to store the results in.

Rate limit

Parameters
Description

Maximum requests per second

Establish a limit for the amount of requests to be launched per second. The minimum value is 1 and the maximum value is 100.

Connection Pool Configuration

Parameters
Description

Max Open Connections

Enter a maximum for how many connections may be open at once (0-unlimited).

Max Idle Connections

Enter a maximum for how many connections may be idle at once (0-unlimited).

Connection Max Idle Time

Enter how many seconds a connection may be idle for (0-unlimited).

Connection Max Lifetime

Add a limit to the connection lifetime (0-unlimited).

Click Finish when complete.

Output configuration

When it comes to using this Data sink in a Pipeline, you must configure the following output parameters. To do it, simply click the Data sink on the canvas and select Configuration.

SQL sentence to execute

These are the parameters to build the SQL sentence that will be executed.

Parameters
Description

Table*

Enter the name of the table to be used.

Column/Value pairs

Click Add Element to add as many pairs as needed.

Parameters
Description

Column

Enter a name for the column that will appear in your database.

Value

Select the incoming event that contains the value to send.

Last updated

Was this helpful?