Capture Code

After the transformation code is available and target objects have been created in the database, the transformations can be captured in datasqill. To do this, start the client, create a new folder under the transformation tree within Transformations, and create a new worksheet within the folder (right-click > New Folder / Sheet). Then open the worksheet by double-clicking.

A transformation flow can be defined by placing transformations and objects on a worksheet in edit mode. The buttons to start edit mode, save, and cancel are located on the worksheet toolbar (the 3 left buttons). The Edit button locks the worksheet in exclusive mode for the user.

Objects and transformations are placed on the worksheet via drag & drop of elements from the toolbar onto the sheet. The transformation flow in datasqill runs from top to bottom.

A transformation is created by drag & drop of the transformation icon (gear icon) onto the grid of the worksheet. It is often practical to create a source object-transformation-target object combination at once (database-gear-database icon).

Double-clicking on a transformation on the grid opens the Edit Action dialog. The transformation name and transformation type (select from list) must be defined. The transformation type determines the module (see Modules). Depending on the transformation type, different parameters are captured. In the main part of the window (on the right side), the transformation code is entered by the developer. In our concrete case, we want to populate the table using the Upsert/Merge method (see Upsert). The module requires a parameter for the join key, which is set to RL: part_key.