Customer Stories
-
Metcash Limited, one of Australia’s largest distribution and wholesale companies, sits at the center of a sprawling supply chain that spans food, liquor, and hardware. As the backbone behind thousands of retail stores and independent business partners, Metcash’s operations depend on reliable data to track suppliers, manage warehouses, and report across its three major business pillars.
The Blueprint Before the Build
-
John Holland Group, one of the largest infrastructure construction firms in Australia with operations across New Zealand and Singapore, manages over 70 years of historical data. By 2023, the organization faced growing demand for advanced analytics, governance, and reporting to support large-scale infrastructure projects. However, their existing on-premises SQL Server environment was fragmented and not scalable.
John Holland Group Accelerates Cloud Migration and Data Governance with SqlDBM
-
"Once you get your data modeling out of the desktop and into the cloud, everyone can align on a single vision — that's the real power of modeling."
Transforming Healthcare Through Data Modeling in the Cloud
-
Accurate, trusted, and accessible data drives every decision at Pie Insurance, from underwriting to claims management to new business expansion.
Pie Insurance
-
Eon Collective was started with the collaboration of technology visionaries who have worked side by side for over two decades. As experts in data modernization, and a Snowflake Partner, Eon Collective have helped countless organizations accelerate their migration to the cloud. As part of the modernization initiative, Eon Collective uses SqlDBM, an online database modeling tool.
A modern modeling tool for modern data architecture
-
The decision to ditch the former ERD tools for all those involved was not something that needed much thought because of the many benefits that came with SqlDBM. It’s important that we’re talking about SaaS technology here, which is very much needed in the growing cloud environments.
How one of the largiest Slovenian companies benefited from the shift to a new ERD tool
It takes time to understand how things link together. SqlDBM helps speed up operational efficiency and agility, and, at the same time, adds more governance around the way we manage our data.
-
Powdr Solutions are Cloud Data Management experts who help clients establish centralized data platforms which enable enterprise reporting. Whether forging a data strategy from scratch or accelerating a cloud migration from on-premises, Powdr understands that communication and iterative design in the early stages help save fixes and rework down the line.
Goodbye On-Prem Hardware
-
One of our first “all cloud data” adopters is a regional health care and assisted-living provider. They were looking to rapidly deploy a data analytics solution to drive critical KPI reporting across numerous source systems. The customer was eager to adopt Snowflake, Matillion and Thoughtspot as part of a “cloud first” approach. After initial requirements-gathering we were able to discern aconceptual data model and followed it up with a logical one. We then knew that in order to produce an effective physical model, a formal modeling tool needed to be employed.
The end-to-end cloud data warehouse solution
-
#1,000+tables
Contextualize hanging tables through auto-suggested relationships Enrich data discovery and understanding through view lineage and relational diagrams Serve as an all-in-one tool for development, data discovery, governance, and CICD Features used Reverse engineering Forward engineering Git integration Suggested relationships Lineage Documentation Supporting global operations through a shared knowledge repository Les Mills was looking for a modeling tool that could do more than just diagram Snowflake databases. It went beyond just reverse engineering. They needed a lightweight, collaborative tool that would serve as an all-in-one solution for development, data discovery, governance, and CICD. According to Craig Pyper, “Other tools like Erwin wouldn’t cut it because it required us to compromise on usability and maintenance.”
“Les Mills: Bringing order and visibility through shared models”
-
Revcontent is a leading content marketing platform run by a small, tight-knit team out of sunny Sarasota, Florida. They connect advertisers to highly engaged audiences through technology and direct partnerships with the world’s premier digital publishers.
From SQL Server to Snowflake Cloud with SqlDBM
-
#Data Vault 2.0
Migrate SQL Server source models into Snowflake Facilitate discussions between the engineering team and the analytics team Keep everyone informed on the model details via the data dictionary Features used Direct connection Deployments Model consumption Documentation Snowflake tags Concurrent working Leading the data warehouse initiative at Higginbotham Having used several modeling tools in the past, David closely understood the alternatives. “If we didn’t have a data modeling tool, I’d likely be doing something with a powerpoint with just simple block notation to represent these types of relationships.” However, the Higginbotham team uses conceptual and physical models to visualize their schemas at a better level. At the same time, Using simple, easy-to-read diagrams has provided a common understanding of the project at hand so that the engineering team could begin building out their warehouse in Snowflake.
Higginbotham’s Underwriting Efficacy Starts with Data Modeling
-
#Data observability
Sophos is a worldwide leader and innovator of advanced cybersecurity solutions, including Managed Detection and Response (MDR) and incident response services and a broad portfolio of endpoint, network, email, and cloud security technologies that help organizations defeat cyberattacks.
Increasing database efficiencies with SqlDBM and Snowflake
It takes time to understand how things link together. SqlDBM helps speed up operational efficiency and agility, and, at the same time, adds more governance around the way we manage our data.
-
#DB migrations
IT engineers onboard and understand client database landscapes in a fraction of the time Keep a distributed team connected across various client engagements and projects Provided a collaborative canvas to collect requirements that made it easier to communicate with stakeholders Features used Reverse engineering Forward engineering Team communication Suggested relationships Documentation Data Ops SqlDBM cuts our modeling time by twenty-five percent by saving us much of the manual and repetitive labor Midhun Paul, Senior Director
How PwC assist client data migrations with the help of SqlDBM
-
#Model Governance
Understand the organization's current database environment Establish a modeling framework from design to implementation Share models with internal consumers and contributors with little overhead Features used API Snowflake tags Masking policies Row-level policies Data catalog Tasks Establishing a modeling practice When Galen College onboarded SqlDBM, they were able to quickly extract value from the product. Previously, their data team did not officially use any relational database modeling software, resulting in database architecture ambiguity and technical debt. For Jacob DeMoor, the team’s Data Warehouse Lead, it was paramount that his team at least start to adopt modeling. He views the database model as a “architecture map of a given system”.
How Galen College Uses Modeling as a Competitive Advantage