Devart MySql Source is a data flow component that makes data from MySQL available to other data flow components. It provides a convenient editor dialog box, which allows you to easily define which data to load.

To call the Devart MySql Source Editor, double-click the Devart MySql Source data flow object.

This dialog box has the following components:

• The Tables area allows you to view the existing MySQL tables, expand their nodes to view columns, and drag them from this area to the Query area.

  • The Show all schemas button enables displaying all the objects of the selected connection; otherwise, only the objects of the default schema for the connection are displayed.
  • The Refresh Objects button updates the list of MySQL tables.
• The Variables area allows you to view the system and user variables grouped in the corresponding nodes, and if necessary, drag them to the Query area.

• The Query area is intended for creating a query to be executed against the MySQL database. You can drag the required MySQL tables and variables to this area, or write the query yourself.

  • The Preview Data button calls the Preview Data window that displays the query execution result.
• The Properties area displays properties of the currently selected MySQL table, column or variable.
• The MySql Connection drop-down list is intended for selecting the corresponding Devart MySql Connection Manager.