# | Function/Panel | Description |
---|---|---|
1. | Navigation menu | The buttons here enable you to save, publish and delete a transformation flow. |
2. | Steps | The different types of transformation steps can be selected from the buttons. There are three main types:
These are connected to one another by connectors. |
3. | Middle header menu |
|
4. | Configuration panel | Used to configure a selected step or the overall flow. The tabs in this panel will vary according to the selected step or main flow. |
5. | Data preview panel | This shows the extracted and/or transformed data. Every time a change is made, it can instantly be viewed here. |
6. | Transformation builder canvas | This canvas is used to create the transformation flow. Drag items here to include them in the flow. |
7. | Canvas positioner | The map view can be used to move the canvas around - this is useful when there are large numbers of steps on the canvas. You can also use this to re-centre the canvas. |
Include an input step to define where to extract your data from. The following types can be used: Input Step Types
Input step functionsOnce an input step is added to the canvas, right click on it to see the functions that can be performed on it. These are explained below:
|
Use a transformation step to transform or convert the connected data.
Transformation Step Types
|
Output step
Save the transformed data into a database using an output step.
Icon | Transformation type | Description |
SQL Database | This outputs data to a selected writeable data source. There are multiple options to create and manage tables and indexes, and to insert or update data. |
Connectors
Connectors are used to join steps together and create a relationship between them. Data will flow from one step to another step. Click on a step to reveal its connecting points. These points are then used to connect one step to another. The flow of a connector is represented with an arrowhead at the end of it.
Connection rules (running left to right):
Breaking a connection:
Once a connection is created between two steps, it can be broken or deleted. Simply right-click on one of the steps, and click on Break Connections. This will break all the connections associated with that step.
Alternatively right-click on the connector itself and select Break connections.
---------------------------------------------------------------------------------------------------------
Configuration panel
Click here learn more about this panel.
Data preview panel
Click here learn more about this panel.