Many organizations have developed their own custom solutions to meet their business needs. These solutions may have worked for them for a number of years, but their effectiveness may diminish as the organization grows or changes. There is a correlation between the success of an organization and the enterprise architectural strategy that has been implemented.

Posh Informatics was hired by an engineering consulting firm to help assess the current state of all systems, and to provide a strategy that would allow a smooth transition from the client’s current architectural state to a new and improved future state, with minimal documentation.

We took on the modernization of this organization’s technology infrastructure, which in some cases hadn’t changed in 20 years. Within a few months, we performed a detailed evaluation of all systems and developed a strategic plan to stabilize their current systems. This firm also will be receiving the prototype of EDB Central, which will assist with monitoring company-wide database systems. The result of implementing these recommendations and product deliverables will save resources while also creating a new standard well-suited for their organizational needs from technical standpoints to streamline internal technological efforts. Lastly, their business intelligence architecture will be revamped, and will include new and accurate data science implementations.

The only requirement to get started on this project was asking the client for the necessary access to servers and database instances. From there, a general architecture was mapped out using a variety of scripts. This network diagram, seen on the left, represents the general architecture based on connections to database instances within their network. This visualization can be updated to reflect connections in real time. Once the general architecture was understood, the potential issues the client had encountered could be narrowed down simply by reviewing this visualization in detail to understand the patterns and general frameworks used, and communicating conclusions based on database design principles.

To see how this model works, explore the visual on the left-hand side of this page. Hover over nodes to see the name of the server. To see direct connections, double-click on a particular node. These features help determine patterns, which allowed Posh Informatics to move forward strategically with respect to the stabilization of existing systems.