WebsiteBlogLogin

Send data to your databases

Most recent version: v0.0.1

See the changelog of this Data sink type here.

Overview

Onum supports integration with your relational databases.

A relational database is a type of database that organizes data into tables with predefined relationships between them, making it easier to manage and access information.

Onum Setup

1

Log in to your Onum tenant and click Data Sinks> New Data sink.

2

Double-click the Relational Databases Sink.

3

Enter a Name for the new Data Sink. Optionally, add a Description and some Tags to identify the Sink.

4

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

5

Database Type*

Onum supports four types of databases:

  • MySql

  • PostgresSql

  • Oracle

  • SqlServer

6

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

  • User*

  • Add the Password* from your list of Secrets or create one.

  • The Host* URL for the database.

  • The Port* to connect to.

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

7

In the Secrets area, New secret to create a new one:

  • Give the secret a Name.

  • Turn off the Expiration date option.

  • Click Add new value and paste the corresponding value.

  • Click Save.

Learn more about secrets in Onum in this article.

You can now select the created secrets in the configuration.

8

Specify the Maximum requests per second*. The minimum value is 1, and the maximum value is 100.

9

Connection Pool Configuration

  • 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. Your new Data sink will appear in the Data sinks area list.

Pipeline 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.

Output configuration

SQL sentence to execute

Parameters
Description

Table*

Enter the name of the table you'll use to build the SQL sentence to be executed.

Column/Value pairs

Define the table to be sent to your database. 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 field that contains the value to sent.

Click Save to save your configuration.

PreviousSend data to TwilioNextSend data via email

Last updated

Was this helpful?