Skip to Content

Changes for page Database connectivity

Last modified by Erik Bakker on 2024/09/24 16:20
From version 20.1
edited by Erik Bakker
on 2022/05/03 12:19
Change comment: There is no comment for this version
To version 60.1
edited by Erik Bakker
on 2024/07/01 15:08
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Solution Architecture
1 +Database connectivity
Parent
... ... @@ -1,1 +1,1 @@
1 -Main.eMagiz Academy.Microlearnings.Expert Level.WebHome
1 +Main.eMagiz Academy.Microlearnings.Intermediate Level.WebHome
Content
... ... @@ -1,18 +1,10 @@
1 -In this course, we will zoom in on various critical parts of the solution architecture. Among others, we will take a look at how you can best determine the needed memory to correctly run your eMagiz solution.
1 +{{velocity}}
2 +#set ($discard = $xwiki.ssx.use('Main.Extensions.ContainerSizingCoursePage.WebHome'))
3 +{{/velocity}}
2 2  
3 -This first part of the course is split up into four microlearnings. At first, we look at how you can determine, regardless of where the runtime is running, how much memory each runtime and therefore each machine needs. On top of that, we learn how we can configure these calculated memory settings per runtime for each of the options where you can run your eMagiz solution on:
5 +{{container}}{{container layoutStyle="columns"}}(((In this course, we will focus on databases and how to properly connect to them with the help of the eMagiz platform. This course is introductory in nature. It focuses on the connection between the platform and databases. In other classes, we will expand on this knowledge.)))((({{html}}<div class="strip__attribute" style="text-align:center"><table><tr><td><img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/></td></tr><tr><td><div class="strip__attribute-label">20-30 minutes</div></td></tr></table></div>{{/html}}))){{/container}}{{/container}}
4 4  
5 -* eMagiz Cloud
6 -* On-premise Windows
7 -* On-premise Linux
8 8  
9 -In the second part of our course, we will learn how our actions and configurations in Create can impact the message size and therefore the performance of the solution.
10 -
11 -In the third part of our course, we will look at some specific implementations that you might need when implementing very specific use cases
12 -
13 -* **Total time:** between 40 and 60 minutes
14 -
15 -
16 16  (% style="border-color:#10137e" %)
17 17  ----
18 18  {{html}}
... ... @@ -21,82 +21,89 @@
21 21   <main class="master">
22 22   <ul class="strip-container">
23 23   <li class="strip">
24 - <a href="../../docs/microlearning/expert-solution-architecture-determining-needed-memory" class="strip__link">
25 - <label for="" class="strip__label">
26 - <span>400</span>
27 - Determining Needed Memory
16 + <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-available-options" target="_blank" class="strip__link">
17 + <div class="strip__attribute__new__stack">
18 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
19 + </div>
20 + <label for="" class="strip__label">
21 + <span>226</span>
22 + Available Options
28 28   </label>
29 29   <div class="strip__attribute">
30 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="../../img/microlearning/academy_index/icon-duration32.svg"/>
31 - <div class="strip__attribute-label">13 minutes</div>
25 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
26 + <div class="strip__attribute-label">4 minutes</div>
32 32   </div>
33 33   <div class="strip__attribute">
34 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="../../img/microlearning/academy_index/icon-roles32.svg"/>
29 + <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
35 35   <div class="strip__attribute-label">Developer</div>
36 36   </div>
37 - <div class="strip__attribute">
38 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="../../img/microlearning/academy_index/icon-roles32.svg"/>
39 - <div class="strip__attribute-label">Architect</div>
40 - </div>
41 41   </a>
42 42   </li>
43 - <li class="strip">
44 - <a href="../../docs/microlearning/expert-solution-architecture-configure-needed-memory-cloud" class="strip__link">
45 - <label for="" class="strip__label">
46 - <span>400</span>
47 - Configure Needed Memory - Cloud
34 + <li class="strip">
35 + <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-driver" target="_blank" class="strip__link">
36 + <div class="strip__attribute__new__stack">
37 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
38 + </div>
39 + <label for="" class="strip__label">
40 + <span>226</span>
41 + Driver
48 48   </label>
49 49   <div class="strip__attribute">
50 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="../../img/microlearning/academy_index/icon-duration32.svg"/>
51 - <div class="strip__attribute-label">5 minutes</div>
44 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
45 + <div class="strip__attribute-label">4 minutes</div>
52 52   </div>
53 53   <div class="strip__attribute">
54 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="../../img/microlearning/academy_index/icon-roles32.svg"/>
55 - <div class="strip__attribute-label">All</div>
48 + <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
49 + <div class="strip__attribute-label">Developer</div>
56 56   </div>
57 57   </a>
58 58   </li>
59 - <li class="strip">
60 - <a href="../../docs/microlearning/expert-solution-architecture-impact-message-history-on-message-size" class="strip__link">
61 - <label for="" class="strip__label">
62 - <span>400</span>
63 - Impact Message History on Message Size
53 + <li class="strip">
54 + <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-sql-query" target="_blank" class="strip__link">
55 + <div class="strip__attribute__new__stack">
56 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
57 + </div>
58 + <label for="" class="strip__label">
59 + <span>226</span>
60 + SQL Query
64 64   </label>
65 65   <div class="strip__attribute">
66 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="../../img/microlearning/academy_index/icon-duration32.svg"/>
63 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
67 67   <div class="strip__attribute-label">6 minutes</div>
68 68   </div>
69 69   <div class="strip__attribute">
70 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="../../img/microlearning/academy_index/icon-roles32.svg"/>
67 + <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
71 71   <div class="strip__attribute-label">Developer</div>
72 72   </div>
73 73   </a>
74 74   </li>
75 75   <li class="strip">
76 - <a href="../../docs/microlearning/expert-solution-architecture-h2-database-for-other-applications" class="strip__link">
77 - <label for="" class="strip__label">
78 - <span>400</span>
79 - H2 Database for other applications
73 + <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-update-database-after-retrieval" target="_blank" class="strip__link">
74 + <div class="strip__attribute__new__stack">
75 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
76 + </div>
77 + <label for="" class="strip__label">
78 + <span>226</span>
79 + Update database after retrieval
80 80   </label>
81 81   <div class="strip__attribute">
82 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="../../img/microlearning/academy_index/icon-duration32.svg"/>
83 - <div class="strip__attribute-label">8 minutes</div>
82 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
83 + <div class="strip__attribute-label">4 minutes</div>
84 84   </div>
85 85   <div class="strip__attribute">
86 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="../../img/microlearning/academy_index/icon-roles32.svg"/>
86 + <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
87 87   <div class="strip__attribute-label">Developer</div>
88 88   </div>
89 - <div class="strip__attribute">
90 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="../../img/microlearning/academy_index/icon-roles32.svg"/>
91 - <div class="strip__attribute-label">Architect</div>
92 - </div>
93 93   </a>
94 94   </li>
95 95   <li class="strip">
96 - <a href="../../docs/microlearning/expert-solution-architecture-aws-direct-connect" class="strip__link">
97 - <label for="" class="strip__label">
98 - <span>400</span>
99 - AWS Direct Connect
92 + <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-configuration" target="_blank" class="strip__link">
93 + <div class="strip__attribute__new__stack">
94 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
95 + </div>
96 + <label for="" class="strip__label">
97 + <span>226</span>
98 + Connectivity Configuration Example
100 100   </label>
101 101   <div class="strip__attribute">
102 102   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
... ... @@ -106,53 +106,28 @@
106 106   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
107 107   <div class="strip__attribute-label">Developer</div>
108 108   </div>
108 + </a>
109 + </li>
110 + <li class="strip">
111 + <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-database-operations" target="_blank" class="strip__link">
112 + <div class="strip__attribute__new__stack">
113 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-exercises32.svg"/>
114 + </div>
115 + <label for="" class="strip__label">
116 + <span>226</span>
117 + Database operations
118 + </label>
109 109   <div class="strip__attribute">
120 + <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
121 + <div class="strip__attribute-label">6 minutes</div>
122 + </div>
123 + <div class="strip__attribute">
110 110   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
111 - <div class="strip__attribute-label">Architect</div>
125 + <div class="strip__attribute-label">Developer</div>
112 112   </div>
113 113   </a>
114 114   </li>
115 - <li class="strip">
116 - <a href="../../docs/microlearning/expert-platform-deploy-install-local-connector-windows" class="strip__link">
117 - <label for="" class="strip__label">
118 - <span>400</span>
119 - Install Magiz runtime for Windows
120 - </label>
121 - <div class="strip__attribute">
122 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
123 - <div class="strip__attribute-label">5 minutes</div>
124 - </div>
125 - <div class="strip__attribute">
126 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
127 - <div class="strip__attribute-label">Developer</div>
128 - </div>
129 - <div class="strip__attribute">
130 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
131 - <div class="strip__attribute-label">Architect</div>
132 - </div>
133 - </a>
134 - </li>
135 - <li class="strip">
136 - <a href="../../docs/microlearning/expert-platform-deploy-install-local-connector-linux" class="strip__link">
137 - <label for="" class="strip__label">
138 - <span>400</span>
139 - Install Magiz runtime for Linux
140 - </label>
141 - <div class="strip__attribute">
142 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
143 - <div class="strip__attribute-label">5 minutes</div>
144 - </div>
145 - <div class="strip__attribute">
146 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
147 - <div class="strip__attribute-label">Developer</div>
148 - </div>
149 - <div class="strip__attribute">
150 - <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
151 - <div class="strip__attribute-label">Architect</div>
152 - </div>
153 - </a>
154 - </li>
155 - </ul>
129 + </ul>
156 156   </main>
157 157   </div>
158 158  </div>