[ 1 Connect JDBC with Devo SOAR ] [ 1.1 Query ] [ 1.1.1 Input Field ] [ 1.1.2 Output ] [ 2 Release Notes ]

Connects to database using JDBC. Supports connection to Postgres via postgreSQL-42.6.0.

Connect JDBC with Devo SOAR

Navigate to Automations > Integrations.
Search for JDBC.
Click Details, then the + icon. Enter the required information in the following fields.
Label: Enter a connection name.
Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
Remote Agent: Run this integration using the Devo SOAR Remote Agent.
Connection String: Connection string for JDBC. Example: 'jdbc:postgresql://1.2.3.4:5432/database?sslmode=allow'.
Username: User to connect to your database instance.
Password: Password for database.
JVM Arguments: Arguments to be passed while starting JVM. Example: '-Doracle.jdbc.javaNetNio=false,-Doracle.jdbc.timezoneAsRegion=false'.
Driver Name: Driver name to be used in JDBC. (Default is 'org.postgresql.Driver').
After you've entered all the details, click Connect.

Query

Query Database

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name	Description	Required

Input Name	Description	Required
Query	Jinja-templated text containing the database query. e.g SELECT * from customers where id={{id_column_name}}	Required

Output

JSON containing the following items:

{json}{ "error":null, "has_error":false, "result":{ "version":"PostgreSQL 10.10 (Debian 10.10-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit" } }

Release Notes

v2.1.0 - Code vulnerability fix by removing usage of static jar
v2.0.0 - Updated architecture to support IO via filesystem
v1.0.0 - Added 1 new action Query.