Skip to Content
Last modified by Erik Bakker on 2024/08/26 12:37
From version 50.1
edited by Erik Bakker
on 2022/10/31 15:24
Change comment: There is no comment for this version
To version 28.2
edited by Erik Bakker
on 2022/06/10 13:13
Change comment: Update document after refactoring.

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Volume Mapping (On-premise)
1 +novice-file-based-connectivity-processing-a-file-per-line
Default language
... ... @@ -1,1 +1,0 @@
1 -en
Content
... ... @@ -1,13 +1,11 @@
1 1  {{container}}{{container layoutStyle="columns"}}(((
2 +In this microlearning, we will learn how you can define a header line in which you specify the naming of the various columns. Some external systems require a header line when you supply them with data via a flat file that is placed somewhere.
2 2  
3 -{{warning}}
4 -Please note that this microlearning is for the new monitoring stack only.
5 -{{/warning}}
6 -
7 -When you need to read and write files from an on-premise disk, you need to know the path in which the data is stored and make sure that the docker container in your runtime(s) running has access to this path. There are several ways of dealing with this challenge. First, this microlearning will discuss the various alternatives and best approaches in these scenarios.
8 -
9 9  Should you have any questions, please contact [[academy@emagiz.com>>mailto:academy@emagiz.com]].
10 10  
6 +* Last update: May 28th, 2021
7 +* Required reading time: 5 minutes
8 +
11 11  == 1. Prerequisites ==
12 12  
13 13  * Basic knowledge of the eMagiz platform
... ... @@ -14,108 +14,59 @@
14 14  
15 15  == 2. Key concepts ==
16 16  
17 -This microlearning centers around learning how to set up your volume mapping correctly so you can exchange file-based data on-premise.
15 +This microlearning centers around learning how to place a header line on a flat-file output.
18 18  
19 -By volume mapping, we mean: Creating a configuration through which the docker container can read and write data on a specific path on an on-premise machine.
17 +By header line we mean: A line in the output that defines the naming of the various columns
20 20  
21 -There are several options for volume mapping for your on-premise machine.
22 -* Volume
23 -* Bind mount
24 -* Temporary file system
25 -* Named pipe
19 +Some external parties require that the first line in the flat file output (i.e. CSV) is filled with column names (i.e. headers). In eMagiz, we call this line a header line.
26 26  
27 -== 3. Volume Mapping (On-premise) ==
21 +== 3. Header line ==
28 28  
29 -When you need to read and write files from an on-premise disk, you need to know the path in which the data is stored and make sure that the docker container in your runtime(s) running has access to this path. There are several ways of dealing with this challenge. First, this microlearning will discuss the various alternatives and best approaches in these scenarios.
23 +In this microlearning, we will learn how you can define a header line in which you specify the naming of the various columns. Some external systems require a header line when you supply them with data via a flat file that is placed somewhere. The header line is the first line in the flat file output. Within this line, the various column names are specified for clarity.
30 30  
31 -There are several options for volume mapping for your on-premise machine.
32 -* Volume
33 -* Bind mount
34 -* Temporary file system
35 -* Named pipe
25 +To add such a header line in eMagiz you need to navigate to the Create phase of eMagiz and open the exit flow in which you want to drop the file to a certain location. Within the context of this flow, we need to add functionality that will ensure that a header line is written to the output before any functional lines are added. To do so first enter "Start Editing" mode on flow level. After you have done so please add a file outbound channel adapter to the flow including an input channel. We will use this component to write our header line to the flat file output.
36 36  
37 -Below we will explain the differences between the various options available for your volume mapping. But before we do, we first explain how to set up this configuration within eMagiz. Then, you must navigate to Deploy -> Architecture on the model level. In this overview, you can access the Volume mapping per runtime deployed on-premise. To do so, you can right-click on the runtime to access the context menu.
27 +Ensure that the directory to which you reference is the same as in your functional file outbound channel adapter.
38 38  
39 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--volume-option-context-menu.png]]
29 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--file-outbound-channel-header-line.png]]
40 40  
41 -When you click this option, you will see the following pop-up. In this pop-up, you can define the machine-level and runtime-level volumes. More on that later. This is the starting point for configuring your volume mapping. We will walk through each available option and explain how they work and should be configured.
31 +Now it is time to turn our attention to the Advanced tab. For the Mode select Ignore. Select this option to ensure that the header line is only written down once when there is no output created yet and not somewhere in the middle, in the end, or every time. Furthermore, select the option Append New Line to ensure that the remainder of the information is not appended to the same line.
42 42  
43 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--volume-mapping-pop-up.png]]
33 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--file-outbound-channel-header-line-advanced.png]]
44 44  
45 -{{info}}Note that you should be in "Start editing" mode to make any changes to the configuration of your volume mapping.{{/info}}
35 +After you have done so we need to add a standard transformer that defines the various column names to be written to the flat file output. To do so add the standard transformer component to the canvas including an input channel. After you have done so define the relevant SpEL expression. In this case, we advise using a property value that represents a string of column names. The value of the property should be something as follows:
46 46  
47 -=== 3.1 Volume ===
37 +'Header1;Header2;Header3;Header4'
48 48  
49 -The first Type available to you is Volume. With this option, you create one or more folders on Docker relevant to that runtime to read and write **persistent** data. To configure this Type, you need to link the runtime volume to a machine volume you can create within the same pop-up. This means you can re-use a "Machine volume" over multiple runtimes (i.e., containers).
39 +Do note that the separator, in this case, needs to match the requirements of the external system. At the flow configuration level, the standard transformer should look as follows.
50 50  
51 -So, we first open the tab called "Machine volume." Then, by pressing the "New" button, we can define a new "Machine volume." In the pop-up that follows, we can specify the name of a machine volume and tell whether the Volume already exists on your docker installation or not.
41 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--define-columns-names.png]]
52 52  
53 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--machine-volumes-configuration.png]]
43 +Our last step is to ensure that this piece of logic is tied to the main flow and is executed before writing the functional line(s) to the output file. To make that happen we need to add a wiretap to the flow. With the help of this functionality, you can define which part of the logic takes precedence over another part of the logic. To do so double click on the channel on which you want to place a wiretap, select the option wiretap and select the correct wiretap channel. After you have done this the result should be something as follows:
54 54  
55 -Once you have done so, we press "Save" and switch back to the "Runtime volumes" tab. Then, we push the "New" button to create a new "Runtime volume." In the following pop-up, we first need to select the Type we want to use. For this example, we use the Type called "Volume." Based on your selection, the relevant input fields will change.
45 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--wiretap-result.png]]
56 56  
57 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--runtime-volumes-configuration-type-volume.png]]
47 +With these couple of steps, you have now successfully added logic to your flow that will ensure that a header line is added before any functional line(s) are written to the output file.
58 58  
59 -The first thing we need to select is the "Machine volume." Once we have chosen our "Machine volume," we must set the Target specific for this runtime. This target defines the second part of the path to which the runtime will gain access. For example, when you fill in "/target", we can combine this with the "Machine volume" name to arrive at the correct directory from which eMagiz needs to read data (or write data to). So in our case, this would be "/file-directory/target."
60 -
61 -The last setting we need to configure is to define which rights we will grant our runtime on the Volume we are creating. The default setting is read/write rights for the runtime, which is sufficient in most cases. The result of following these steps will be the following.
62 -
63 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--runtime-volumes-configuration-type-volume-filled-in.png]]
64 -
65 -{{warning}}Note that when you use the Volume option, the external system with which you exchange data on-premise via a file-based method needs to be able to write or read the data from the Volume (i.e., directory) you have configured in Docker. Should this be a problem, the Bind mount alternative discussed below should be considered.{{/warning}}
66 -
67 -=== 3.2 Bind mount ===
68 -
69 -An alternative option to read and write **persistent** data is to use the "Bind mount" option. In general, we advise using the "Volume" option because they have better performance, and bind mounts depend on the host machine's directory structure and OS. However, only some external systems can adapt to this that easily. For example, the "Bind mount" option can interest your use case.
70 -
71 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--runtime-volumes-configuration-type-bind-mount.png]]
72 -
73 -To configure a "Bind mount," you need to define a source and a target directory linked to each other. The source directory represents the directory on your local system (that might already be used currently to exchange files). The target directory defines a directory on your docker installation that the runtime can access.
74 -
75 -{{warning}}Note that when the source directory does not exist, the runtimes cannot be deployed correctly.{{/warning}}
76 -
77 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--runtime-volumes-configuration-type-bind-mount-filled-in.png]]
78 -
79 -{{info}}Note that when you use this option, your directory reference in your flow should refer to the "target" directory configured here.{{/info}}
80 -
81 -=== 3.3 Temporary file system ===
82 -
83 -The temporary file system option is for you if you do not want to work with **persistent** data but require **non-persistent** data. This way, you can increase the container's performance by avoiding writing into the container's writable layer.
84 -
85 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--runtime-volumes-configuration-type-temp-file-storage.png]]
86 -
87 -To configure this option, you need a target location. On top of that, you can define the maximum size of the temporary file system.
88 -
89 -[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-volume-mapping-on-premise--runtime-volumes-configuration-type-temp-file-storage-filled-in.png]]
90 -
91 -{{warning}}We strongly advise you to define this number so that you can limit the potential impact this solution can have on the stability of your machine.{{/warning}}
92 -
93 -=== 3.4 Named pipe ===
94 -
95 -The named pipe option can be selected, but we yet have to see a valid use case within the context of eMagiz for using this option. Therefore we won't discuss this option further in this microlearning.
96 -
97 97  == 4. Assignment ==
98 98  
99 -Navigate to Deploy -> Architecture and look at the Volume mapping options, read the help texts, and play around with the settings (if it is not a customer environment).
100 -This assignment can be completed with the help of the (Academy) project you created/used in the previous assignment.
51 +Configure an exit in which you define and write a header line to a flat-file output before adding functional lines.
52 +This assignment can be completed with the help of the (Academy) project that you have created/used in the previous assignment.
101 101  
102 102  == 5. Key takeaways ==
103 103  
104 -* File-based communication on-premise changes in the new runtime architecture
105 -* There are two ways to store **persistent** data
106 - ** Volume
107 - ** Bind mount
108 -* The Volume option is considered the best alternative because they have better performance, and bind mounts are dependent on the directory structure and OS of the host machine
109 -* When you want to deal with **non-persistent** data, the Temporary file storage option is the way to go.
56 +* The header line contains the names of the columns of the flat file output
57 +* Use the Ignore mode to ensure the header line is created once
58 +* Use the wiretap to ensure the header line is created first
110 110  
111 111  == 6. Suggested Additional Readings ==
112 112  
113 -If you are interested in this topic and want more information, please read the help text provided by eMagiz.
62 +There are no suggested additional readings on this topic
114 114  
115 115  == 7. Silent demonstration video ==
116 116  
117 -This video demonstrates how you could have handled the assignment and gives context to what you have just learned.
66 +This video demonstrates how you could have handled the assignment and gives you some context on what you have just learned.
118 118  
119 -TBA
68 +{{video attachment="novice-file-based-connectivity-header-line.mp4" reference="Main.Videos.Microlearning.WebHome"/}}
120 120  
121 121  )))((({{toc/}}))){{/container}}{{/container}}