Relational Databases
Most recent version: v0.0.1
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.
Select Relational Databases from the list of Data sink types and click Configuration to start.
Data sink 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.
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 Data sink. Hit the Enter key after you define each tag.
Metrics display
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.
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.
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
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
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.
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
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.
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.
Last updated
Was this helpful?