Details
Performs advanced ETL (extraction, transformation, loading) on MySQL database. Using this plugin, we can extract data from a MySQL database, transform the data using JavaScript, and load the transformed data into MySQL database, and set it to a workflow variable. The configuration properties available in Enterprise MySQL Plugin are:
- MySQL Host Address (origin)
- Username
- Password
- Port
- Database
- SQL Query (for data extraction)
- Transformation Expression
- MySQL Host Address (destination)
- Username
- Password
- Port
- Database
- SQL Query (for data loading)
- Workflow Variable Name
- Workflow Variable Value
Plugin type: Application Plugin
Plugin version: v1.0.4, compatible with Joget Workflow v1.x.x and v2.0.x
Download includes: plugin

