RESEARCH

RESOURCES / RESEARCH

Helping Different Companies With Information Management

McKnight Consulting Group (MCG)’s 2nd Edition of the Data Integration Enterprise Contribution Ranking Report®

March 7, 2024

McKnight Consulting Group (MCG)’s 2nd Edition of the Data Integration Enterprise Contribution Ranking Report® has been published. An Enterprise Contribution Ranking Report is the most detailed report on the market. It provides a comprehensive study on the offerings in significant enterprise data technology topics.

The study examines market preferences and priorities for data integration platforms including Data Transformation, Data Security and Access Control, Data Quality and Data Governance, Workflow Automation and Orchestration, Analytics, Automation, and AI. The reports also addresses Seamless Integration with BI and Analytics Tools, Data Cataloging and Metadata Management, Enterprise Scaling with Performance, Ecosystem Compatibility and Platform Versatility, as well as Financial Operations, Compliance, and Data Auditing. These are essential key areas for successful enterprise data integration implementations.

McKnight Enterprise Contribution Ranking Reports offer a thorough analysis of enterprise data technology offerings, focusing on the value of product capabilities to the enterprise. The reports emphasize the importance of AI, including Generative AI, in future-proofing technology. Market leaders are evaluated based on their critical capabilities, which include both currently available features and upcoming realistic capabilities. Ratings are assigned to vendors based on expert-opinion assessments by analyst-practitioners, resulting in Advanced, Skilled, Partial, or Beginner capabilities ratings.

Vendors are also plotted on a quadrant based on Project Scope Complexity and Project Technical Environment Complexity. These reports are written by hands-on Data Engineers.   

Get the report here.

High-Volume Data Replication: Evaluating Fivetran HVR and Qlik Replicate

March 7, 2024

Whether for operational or analytical purposes – databases are the backbone of how many businesses run; from collecting consumer behavior on your website to processing IOT data across your supply chain and so much more. Accessing and replicating massive volumes of database content is key to business success and the responsibility of managing this crucial element of your infrastructure falls to data leaders and their teams.

In this study, we found significant differences in replication latency and total cost of ownership between Fivetran HVR and Qlik Replicate.

Contact us for the report.

Data Fabric Field Test: SAP vs. DIY

March 7, 2024

Interest in building a data fabric is very high, and for good reason. By enabling real-time, trustworthy data across multiple clouds, you can expedite the migration of analytics to the cloud, guarantee security and governance, and quickly generate business value. A data fabric provides a semantic layer that enables a map of your metadata, unifying data based on its meaning, rather than just its location, and preserving the business context and logic of that data across the fabric.

In this report, we introduce SAP Datasphere. We compare the task of creating, integrating, distributing, and managing a data fabric with a common DIY set to SAP. Looking across all organization sizes, we found that a DIY data fabric deployment over three years cost 2.4x more than SAP Datasphere. These sharp cost advantages played out across all aspects of adoption—data fabric infrastructure, initial migration/build, CI/CD, and administration.

Contact us for the report.

Elevate your data strategy with AI-powered MDM

February 19, 2024

Unlock the full potential of your data with cloud-native, AI-powered master data management. Our innovative data management solutions not only streamline data processes but also deliver new insights, driving your business forward with confidence and precision.

Discover the future of data in this comprehensive report, where advanced analytics meet unparalleled accuracy, as well as:

  • Explore the impact of AI on master data reliability and decision-making
  • Uncover new best practices for AI-enhanced data analysis and operational efficiency
  • Discover how AI fuels continuous innovation and a competitive edge

Get the report here.

Vector Databases Compared: Evaluating DataStax Astra DB Serverless (Vector) and Pinecone Vector Database

February 19, 2024

The study found that Astra DB significantly outperformed Pinecone p2x8 in ingesting and indexing data, performing six times faster and with a low relative variance, making the ingest workflow more predictable. Astra DB also showed faster response times during active indexing and produced recall ranging from 90% to 94% versus Pinecone’s recall in the range of 75% to 87%. For larger datasets, Astra DB showed better recall and low variance, demonstrating accuracy and consistency. Finally, our testing and configuration pricing revealed that Pinecone’s TCO was 2.2 to 4.9 times greater than Astra DB, making it significantly more expensive to operate.

Contact us for the report.

Costs and Benefits of .NET Application Migration to the Cloud

February 19, 2024

The field study examines the process of migrating .NET applications and data from on-premises deployment to both Microsoft Azure and Amazon Web Service (AWS) PaaS offerings. Our testing showed that both cloud providers have a strong value proposition for migrating on-premises workloads. Companies can take advantage of Azure Hybrid Benefit, a licensing offer that helps you save up to 85% of the overall cost of SQL workloads in the cloud. This can fundamentally alter the economics behind a data- or transaction-based business model.

Contact us for the report.

MCG Data Pipeline Performance Testing

January 10, 2024

To be agile and resilient in the modern world, an organization’s data infrastructure maturity must be in harmony with its business goals. Limited data capabilities could hinder or even derail all efforts. For a data management plan to be successful in an environment that is changing quickly, adaptability is also necessary.

Our scenario assessed the speed of syncing a 1TB data set between a source PostgreSQL database and a target Snowflake data warehouse. We tested total throughput, cost and total cost of ownership.

Airbyte is a data integration platform that offers a comprehensive catalog of connectors for structured data, including databases and files. Airbyte offers a cloud-hosted solution and a self-hosted one. It supports a large range of data sources and all major databases, and it can connect to over 50 destinations, including databases, data warehouses, data lakes, and vector databases.

Get the report here.

iPaaS Tools Evaluation: Security and Governance Report: Evaluating Workato and Boomi

December 14, 2023

We evaluated two leading iPaaS tools—Workato and Boomi—specifically across the top tasks a business would perform with the tools for governance and data security. Both Workato and Boomi offer robust features in these areas. Workato provides a user-friendly interface that allows businesses to easily manage user permissions and access controls, ensuring that sensitive data is only accessible to authorized individuals. Additionally, Workato offers advanced security measures such as encryption and multi-factor authentication to protect data from unauthorized access. On the other hand, Boomi provides a comprehensive set of tools for data governance and compliance, allowing businesses to define and enforce data security policies across their organization.

Contact us for the report.

Benchmark Report: Containerized SQL Server Performance Testing

December 14, 2023

Diamanti’s customers have voiced their need for a solution to best deploy containerized Microsoft SQL Server across hybrid cloud. As part of this effort, we’ve commissioned the McKnight Group, an independent consulting firm, to conduct an unbiased benchmark study of SQL Server 2019 running on the most promising Kubernetes platforms available on the market today. Our goal is to help each customer determine the best-suited platform to run Microsoft SQL Server based on their individual requirements.

Read the full benchmark report, which provides insight to help IT professionals, DevOps engineers, platform architects and information security practitioners evaluate a Kubernetes platform optimal for running I/O intensive Microsoft SQL Server applications.

Get the report here.

TCO for Data Masking and TDM Solutions

October 27, 2023

The increasingly complex landscape of data management for enterprises has brought to light the need for tools to manage diverse platforms and provide overall management. These tools focus on efficient test data management; integration, lifecycle management, security, compliance, and storage optimization. We determined that for the equivalent usage (consisting of typical deployment, provisioning, and masking activities), IBM Optim would result in labor and infrastructure costs of $109,300 compared to $75,164 for Delphix over the first year (one setup), a difference of 31%.

Contact us for the report.