Although PlantUML does not useĪny programming language to create the diagrams, it uses plain text to construct the commands which can then be However, there is also a way to programmatically create these sequence diagrams and that is by using Plant UML.Ĭreating the diagram programmatically has a few advantages over the other techniques. Either way, you get a fixed set of drawing elements from which you can dragĪnd drop components to a canvas and prepare the diagram. You can use any drawing tool available online like Draw.io or dedicated desktop tools like Microsoft Visio.
#Create sequence diagram in draw io how to
Now that we have some idea about what a sequence diagram is all about, let us learn how to create it from scratch. Status such as success or failed, which helps the parent package to decide the execution control flow based on theįigure 6 – Return Message in Sequence Diagram ( Source) Creating the Sequence Diagram Return Message – A return message is passed from the child package to the parent package with its However, in ETL, it is the initiation of the phases within the package.įigure 5 – Call message in Sequence Diagram ( Source) In the programming world, it can be the methods of the classes which can be used to initiate a
If you refer to Figure 1, you can see that theĪctivation boxes are highlighted in colored boxes for each of the phases.įigure 4 – Activation Box in Sequence Diagrams ( Source)Ĭall Message – A call message is the initiation or start of execution of specific phases within the Placing small rectangular boxes within the lifeline. Like extraction, validation, or processing within each SSIS package. This can be the duration of execution for the individual phases It is just the extension of the package that is being executed.įigure 3 – Lifeline in Sequence Diagram ( Source)Īctivation – It is the specific duration of time during which the object is activated and staysĪctive during an operation is being performed by it. It is depicted by usingĭotted or dashed lines. Lifeline – A lifeline is the representation of an object in the diagram. The SSIS packages, this can either be the developer or a DBA, or even a scheduled SQL Agent Job that triggers theįigure 2 – Actor in Sequence Diagram ( Source) These actors are not a part of the internal workflow and can live outside it. In addition to these dimensions, few other notations are usedĪctor – An actor is usually a person or an external device or program which has the capacity to In the case of SSIS packages, the objects can be replaced with child packages which canĪct as objects when executed from the master package. These dimensions are plotted in the diagram in the horizontal and the vertical axes and then the objects are addedĪlong the horizontal axis. This can be the execution time being taken by the SSIS project to complete Time Dimension – This is the vertical axis which represents the time of action during which the.This can be done by placing the individual SSIS packages as objects in Interact at last are placed on the right. Simpler, the objects are arranged in a way that the ones used earlier are kept on the left and the ones which Object Dimension – This is defined by the objects on the horizontal axis.At the very basic level,Ī sequence diagram consists of two dimensions as follows. To begin with, we should have a common understanding of how a sequence diagram is created. This isĪlso helpful in controlling which child package would you like to execute or not based on a simple configuration in Packages are composed of a single master package that controls the execution of multiple child packages. As explained in the previous article already, the SSIS This might look a bit complex in the first step, but if we start with the basics, the concept of drawing suchĭiagrams is simple which we will see later in this article. The various components in the system in a chronological manner.įigure 1 – Documenting SSIS Packages using Sequence DiagramsĪs you can see in the figure above, this is how an SSIS package can be documented as a sequence diagram. Sequence diagrams are also a part of the broader UML Diagrams which define the interaction between Also, I have talked about modular ETL architecture and how to create such a modular
In my previous article, I have talked about the various UML Diagrams that are being used to document various
#Create sequence diagram in draw io software
Importance of these diagrams in the field of software engineering, no matter which programming language are you In this article, I am going to explain in detail how to document SSIS packages using Sequence Diagrams and the
0 kommentar(er)
