Component Database

The Database component is represented by the icon: and enables operations in a MySQL database.

To modify the behavior of a Database component, double click on the component name located in the central workspace, it opens a popup window called "Component Configuration Window". The following figure shows the window for the component:

The first field of the window shown in the figure above is a field called "Name Component", in this you can enter a name for the component. Then there are a number of fields described below.

• Host: Name or IP address of the server hosting the service MySQL.
• Username: Username with the necessary permissions to execute commands in MySQL.
• Password: Password of MySQL service.
• Database: Name of the database in which we want to work (must be created first).
• SQL: SQL statement to be executed.
• Name output: output name to be added to the $ data_flow variable.

At the bottom of the window are three buttons appear: Save, Apply, Cancel. The Save button: Saves the changes made to the component and close the window. The Apply button: Saves the changes made to the component without closing the window. The Cancel button: Closes the window without saving changes to the component.