EDB Postgres in Public Sector

EDB Postgres in Public Sector

• 1.
  Fatherly advice & OpenSource Software Joost Wasser March 29, 2022
• 2.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Agenda • One; the rise of Open Source • Two; how to select the right application • Three; Smals, NFI, RvIG
• 3.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Fatherly advice • Test a relationship • Sailing adventure; SanDiego - Costa Rica • Low budget, looking for navigation sources • Sailing community • Open Sea • Page visit Navtronics • How I got in contact with Open Source Software 3
• 4.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Covid and Open Source Software • Trustworthy • Transparency • Open • Available for everyone: https://github.com/minvws • Case study: https://www.ict-reuse.be/nl/case-study/reus e-in-de-strijd-tegen-covid-19 4
• 5.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Rise of Open Source Software; other driving forces 5 • EU Commision • OPEN SOURCE SOFTWARE STRATEGY 2020 – 2023 Think Open • Vision; less dependency on Closed Source • Upward trend in adoption of Open Source Software • Open Data, Open Standards • Shorter Adoption circle • Use - re use- alternate for specific use case- share • Examples of Open Data: https://data.gov.be/nl https://data.overheid.nl/
• 6.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved How to select the right application [Guidelines] • Example; Dutch Police • Advice 2016; stop spending on legacy software • LCM • https://www.digitaleoverheid.nl/document/ha ndreiking-verantwoord-vernieuwen/ • Gartner TIME • Bollenplaat 6
• 7.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Where are we today? • Smals • Fed Police • Infrabel • Digipolis • euLISA • Smals Member List • Smals Lastenboek / Framework agreement • All Smals members can benefit from • Contract won by Kangaroot 7
• 8.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Predominantly looking for Open Source Solutions • It is paid by, built by, built for the Belgium Taxpayer [give back] be smarter • PostgreSQL as default choice • Migrations from Oracle, DB2, Sybase • EDB Migration Portal 8
• 9.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Use case NFI 9 • Believe it or not we do have criminals • Once arrested by the Police an investigation starts on banking/web traffic/location/DNA/ contacts etc Application developed by NFI and landed on a Oracle Database • Investigated on Oracle Compatibility, EDB Assessment Migration Portal PoC 1 on Application PoC 2 on Hardware PoC 3 on user experience, automated with EDB MTK
• 10.
  2021 Copyright ©EnterpriseDB Corporation All Rights Reserved Use case RvIG • 17.5 Mil Dutch Passports/ Identity cards • Low Ingest Database • System of Record • HA SetUp multiple Governmental Data Centers broke away from Proprietary software and hardware • Lastenboek changed from specific requirements to the biggest bang for the buck in off the shelf commodity hardware. 10
• 11.
  So challenge yourselfon your status quo database choice Investigate the alternative Kangaroot and EDB can help ..and my girlfriend and I are still together…