Commands

The command is used to address different functionalities in a module. Currently there are two commands:

• Run - Execution of the module data transformation
• Validate - Validation of the transformation (including graphical model)

The method is selected via a corresponding input parameter of the module.

Run

The Run command starts the data transformation through the module. Using the transformation instruction and the attributes, the module reads data from the sources and writes the result to the target(s).

Typical module classes could be

• Transformation of data from source tables to a target table within a database
• Transformation of data between tables in different databases
• Call of a web service and storage of the received data in a database table
• Generation of an Excel report with data from report tables
• Sending a report by email

The open architecture of datasqill allows its users to develop and use new module classes. Any languages such as Java, Javascript, Python, Perl, or Lua can be used for programming.

Validate

The Validate command triggers the verification of the parameters set by the datasqill developer. This includes

• the transformation instruction (e.g. SQL) and
• the connected sources (from the graphical model)

Ideally, the Validate method returns the error position when there are errors with the transformation instruction to facilitate troubleshooting. Furthermore, the source objects used by the transformation instruction are returned so that the GUI can compare them with the model.