Create MySQL plugin procedures

1 minute readExtensibilityDeveloper productivity
On this page

Plugin procedures can be used in procedure steps, process steps, and pipeline tasks, allowing you to orchestrate third-party tools at the appropriate time in your component, application process, or pipeline.

ExecuteSQL

Creates and executes a command line from the parameters that you specify in the procedure.

Input parameters

Table 1. ExecuteSQL input parameters
Parameter Description

Configuration name

Required. The previously defined configuration for the plugin.

mysql command line utility

Required. Absolute path to the mysql command line tool.

Database name

Required. Name of the database.

Server

Required. The name or IP address of the server you want to connect to.

Port

Required. Database port. The default value is 3306.

Connection encoding

Connection encoding. Unicode by default.

Output format

Required. Choose the output display format.

Report name

The name of the report that is created after running the query without an extension.

SQL file path

Provide the absolute path to an SQL file that you want to run.

Query

Provide any query you want to run against the database.

Additional commands

Additional commands to be entered.

Working directory

The directory where the job is executed.

Result output property path

The property name used to store the result of queries.