MariaDB SQL Query

Executes SQL queries against a MariaDB database and returns the result set as a JSON object.

Revision History

1.0.0.0 Initial release

Properties

Connection

Server
Type: String
The name or IP address of the server hosting the MariaDB server instance. Specify a DropPoint if you need to access an instance that is not publically exposed.

Database
Type: String
The name of the database to connect to.

UserName
Type: String
The username to be used for the connection

Password
Type: Password
The password to be used for the connection

DatabasePort
Type: Number
The port on which the MariaDB server is running

UseSsl
Type: Boolean
Whether SSL should be used when making a connecting to the database

Query

Type: Multiline Text Input
The SQL query text

Result

Type: Json Output
The results of the query

RowsAffected

Type: Int32 Output
The amount of rows affected by the query

Remarks

Use this connector to execute SQL queries against a MariaDB database.

SQL Parameters via Custom Properties

Flowgear Custom Properties can be added to this Node to make SQL parameters available in the Query Property. Use of a Custom Property is shown in the linked example workflow (see Examples below).

Other Nodes for SQL databases

If you are updating values in a table based on keys, consider using Snowflake SQL Table Update instead of crafting update statements.

If you need to integrate with a non-Microsoft SQL database, refer to Integrating with SQL Databases for additional information and connection strings.