https://owl.unipharm.com/mediawiki/index.php?action=history&feed=atom&title=Information_Systems%3AAzure_for_Web_Orders 2026-09-01T14:36:15Z Revision history for this page on the wiki MediaWiki 1.35.4 https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Azure_for_Web_Orders&diff=14733&oldid=prev 2025-03-20T07:33:56Z

<p><span dir="auto"><span class="autocomment">Databases</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:33, 20 March 2025</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 16:</td> <td colspan="2" class="diff-lineno">Line 16:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Databases===</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Databases===</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Azure SQL (SQL Server) is used for the database(s). Currently, there is a single instance '''uwdintdb''' of Azure SQL that hosts multiple databases that share an elastic pool (for compute).</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Azure SQL (SQL Server) is used for the database(s). Currently, there is a single instance '''uwdintdb''' of Azure SQL that hosts multiple databases that share an elastic pool (for compute).</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>====Connectivity====</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Direct connection (e.g. port 1433) to uwdintdb is allowed through firewall rules (IP whitelist) which can be administered in Azure. Connectivity from applications, such as Synapse and Web Orders itself, is done through Private Endpoint.</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>====Administration====</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====Access====</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====Access====</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Database access is available via direct connection (port 3306). Access is IP-restricted for security reasons. </div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Database access is available via direct connection (port 3306). Access is IP-restricted for security reasons. </div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Source Control and DevOps===</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Source Control and DevOps===</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Azure DevOps is used for both git / source control (using Azure Repos), and CI/CD (build pipelines).</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Azure DevOps is used for both git / source control (using Azure Repos), and CI/CD (build pipelines).</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-14732:rev-14733:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Azure_for_Web_Orders&diff=14732&oldid=prev 2025-03-20T07:20:45Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:20, 20 March 2025</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 14:</td> <td colspan="2" class="diff-lineno">Line 14:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Deployment slots allow for dev, test, and prod instances of the application. </div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Deployment slots allow for dev, test, and prod instances of the application. </div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>===<del class="diffchange diffchange-inline">Database</del>===</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===<ins class="diffchange diffchange-inline">Databases</ins>===</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Azure SQL (SQL Server) is used for the database(s). Currently, there is a single instance '''uwdintdb''' of Azure SQL that hosts multiple databases that share an elastic pool (for compute).</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The database uses Azure MySQL Flexible Server, which is a serverless database MySQL instance.</div></td> <td colspan="2" class="diff-empty">&#160;</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====Access====</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====Access====</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-14730:rev-14732:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Azure_for_Web_Orders&diff=14730&oldid=prev 2025-03-20T07:16:55Z

<p>Norwinu moved page <a href="/mediawiki/index.php/Information_Systems:Azure_Resources" class="mw-redirect" title="Information Systems:Azure Resources">Information Systems:Azure Resources</a> to <a href="/mediawiki/index.php/Information_Systems:Azure_for_Web_Orders" title="Information Systems:Azure for Web Orders">Information Systems:Azure for Web Orders</a> over redirect</p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:16, 20 March 2025</td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-14728:rev-14730:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Azure_for_Web_Orders&diff=14728&oldid=prev 2025-03-20T07:16:17Z

<p>Norwinu moved page <a href="/mediawiki/index.php/Information_Systems:Azure_for_Web_Orders" title="Information Systems:Azure for Web Orders">Information Systems:Azure for Web Orders</a> to <a href="/mediawiki/index.php/Information_Systems:Azure_Resources" class="mw-redirect" title="Information Systems:Azure Resources">Information Systems:Azure Resources</a></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:16, 20 March 2025</td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-14666:rev-14728:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Azure_for_Web_Orders&diff=14666&oldid=prev 2024-03-24T07:44:49Z

<p>Norwinu moved page <a href="/mediawiki/index.php?title=Azure_for_Web_Orders&amp;action=edit&amp;redlink=1" class="new" title="Azure for Web Orders (page does not exist)">Azure for Web Orders</a> to <a href="/mediawiki/index.php/Information_Systems:Azure_for_Web_Orders" title="Information Systems:Azure for Web Orders">Information Systems:Azure for Web Orders</a> without leaving a redirect</p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:44, 24 March 2024</td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-14665:rev-14666:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Azure_for_Web_Orders&diff=14665&oldid=prev 2024-03-24T07:43:31Z

<p>Created page with &quot;==Summary== The new Web Orders site is hosted on Azure. The resources are grouped in the Resource Group &#039;&#039;&#039;rg-weborders&#039;&#039;&#039;, within the &#039;&#039;&#039;Azure PAYG Subscription 1&#039;&#039;&#039; subscri...&quot;</p> <p><b>New page</b></p><div>==Summary==<br /> <br /> The new Web Orders site is hosted on Azure. The resources are grouped in the Resource Group '''rg-weborders''', within the '''Azure PAYG Subscription 1''' subscription.<br /> <br /> ==Components==<br /> <br /> ===Web Application===<br /> The web application is hosted using Azure App Service, which is a serverless service that provides web runtimes e.g. PHP-CGI (PHP), WSGI (Python), to run web applications without having to maintain a server/VM.<br /> <br /> ====Code deployment and administration====<br /> While there is no actual server/VM to administer, App Service allows for shell-like access and FTP/SFTP to enable some administrative tasks (although deployment through CI/CD is the better practice). Shell access is available via Kudu SCM.<br /> <br /> ====Deployment Slots====<br /> Deployment slots allow for dev, test, and prod instances of the application. <br /> <br /> ===Database===<br /> The database uses Azure MySQL Flexible Server, which is a serverless database MySQL instance.<br /> <br /> ====Access====<br /> Database access is available via direct connection (port 3306). Access is IP-restricted for security reasons. <br />  <br /> ===Source Control and DevOps===<br /> Azure DevOps is used for both git / source control (using Azure Repos), and CI/CD (build pipelines).<br /> <br /> There are two repos in the project, one each for the back-end and front-end.<br /> <br /> <br /> ===Integration with D365===<br /> The integration between Web Orders and D365 occurs via 2 main patterns/methods:<br /> # Through a dedicated integration/middleware database that is written to with D365 data and read by Web Orders. This database is found in the same MySQL instance as the one for the application (it is just a separate schema). <br /> # Through REST API endpoints that allow Web Orders to POST data e.g. orders into D365. There are no Azure components for this on the Web Orders side, as API consumption is done in code.<br /> <br /> <br /> [[Category: Web Orders]]<br /> [[Category: Dynamics 365 Integrations]]</div>

Norwinu