Relational Databases
Most recent version: v0.0.1
Last updated
Was this helpful?
Most recent version: v0.0.1
Last updated
Was this helpful?
The Relational Databases Data sink lets you send SQL sentences to your desired database.
Now you need to specify how and where to send the data, and how to establish a connection with your database.
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 Sink. Hit the Enter key after you define each tag.
Decide whether or not to include this Data sink info in the metrics and graphs of the Home area.
Now add the configuration to establish the connection.
Database Type*
Onum supports four types of databases:
MySql
PostgresSql
Oracle
SqlServer
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.
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.
These are the parameters to build the SQL sentence that will be executed.
Table*
Enter the name of the table to be used.
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 event that contains the value to send.
