Research

MCG Enterprise Contribution Ranking Report for Cloud Data Management and Integration for Cloud Data Warehouses and Data Lakes

In this paper, we have undertaken an ambitious goal of evaluating the current vendor landscape and assessing which tools and platforms have made, or are in the process of making, the leap to this new generation of data management and integration capabilities.

The vendors/products chosen were:

AWS (Glue)

Azure (Azure Data Factory)

Cloudera (Cloudera Replication Manager)

Fivetran

Google (Alooma)

IBM

Informatica

Matillion

Oracle

SAP

Talend

Available here.

High Performance Application Security Testing, Product Evaluation: NGINX App Protect vs. ModSecurity (plus AWS Web Application Firewall)

Data, web, and application security has evolved dramatically over the past few years. Just as new threats abound, the architecture of applications—how we build and deploy them—has changed. We’ve traded monolithic applications for microservices running in containers and communicating via application programming interfaces (APIs)—and all of it deployed through automated continuous integration/continuous deployment (CI/CD) pipelines. The frameworks we have established to build and deploy applications are optimized for time to market—yet security remains of utmost importance.

Our focus is specifically on approaches to securing apps, APIs, and microservices that are tuned for high performance and availability. We define “high performance” as companies that experience workloads of more than 1,000 transactions per second (tps) and require a maximum latency below 30 milliseconds across the landscape.

Link to report (fee)

HIGH PERFORMANCE CLOUD DATA WAREHOUSE VENDOR EVALUATION

This authoritative report from GigaOm Research, a respected independent industry analyst firm, details the key performance and cost criteria to guide your cloud data warehouse selection.

“Price and performance are critical points of interest…our analysis reveals Avalanche to be the industry leader on this criterion.”

Highlights from the report:

  • Key factors to consider when evaluating a hybrid cloud data warehouse
  • Head-on vendor comparisons across performance and cost using industry standard TPC-H benchmark
  • Vendors analyzed include Actian Avalanche, Snowflake, Amazon Redshift, Microsoft Azure Synapse and Google BigQuery
  • Assessment of single user and multiple concurrent users scenarios

Link to report.

Cloud Database Performance – McKnight Benchmark Report

This third-party report from McKnight Consulting Group uses industry-standard benchmark principles to evaluate the performance of three cloud-optimized analytical platforms architected for the separation of compute and storage – Vertica in Eon Mode, Amazon Redshift, and an unnamed cloud data platform.

Link to report.

Data Pipeline Platform Comparison

In this report, we compare the three major data pipeline platforms: Matillion, Stitch, and Fivetran; and run them through a series of selected tests that highlight their degree of automation, ease of setup, and documentation. We evaluated aspects that include the time and effort required to set up a source-destination connection, the degree of automation throughout the process, and the quality of documentation to support the effort. These areas address the three major “humps of work” we have encountered in our field work with data pipelines.

Link to report.

Price Performance In Modern Cloud Database Management Systems

The pace of relational analytical databases deploying in the cloud are at an all-time high. The goal of this paper is to provide information to help a customer make the best decision, looking at factors in cloud data platform pricing – such as scope, scale, deployment, etc. – and how to determine the ultimate success metric when it comes to making a decision on a cloud data warehouse deployment – price-performance.

Link to report.

High Performance API Management Testing

Application programming interfaces, or APIs, are now a ubiquitous method and de facto standard of communication among modern information technology applications. Large companies and complex organizations have turned to APIs for exchanging data to knit these heterogeneous systems together and turn data into a service. In this paper, we reveal the results of performance testing we completed with four full-lifecycle API management platforms.

Link to report.

Enterprise Analytic Solutions

This report is the third in a series of enterprise roadmaps addressing cloud analytic databases. The last two reports focused on comparing vendors on key decision criteria that were targeted primarily at cloud integration. This report is an update to the 2019 Enterprise Roadmap: Cloud Analytic Databases. However, this time around we have new vendors and a new name. We’ve reviewed and adjusted our inclusion criteria. We’re now targeting the technologies that tackle the objectives of an analytics program, as opposed to the means by which they are achieving these objectives.

Link to report (GigaOm membership/fee required for full report).

Empowering Users to Mine the Data Lake, Energize a Data Catalog and Return Big ROI

In this Business Technology Impact report, we take a look at a large multi-national firm and its implementation of a data lake and data catalog. Within the company, a small team worked to transform the data lake from an underutilized, misunderstood ‘white elephant’ into a resource that drove the company’s growth and innovation.

Link to report.

SQL Transaction Processing, Price-Performance Testing

This report details the results of a Transactional Field Test, derived from the industry-standard TPC Benchmark™ E (TPC-E), compared:

  • Microsoft SQL Server 2019 on an Amazon Web Services (AWS) r5a.8xlarge Elastic Cloud Compute (EC2) instance with General Purpose (gp2) volumes
  • Microsoft SQL Server 2019 on an Azure E32as_v4 Virtual Machine (VM) with P30 Premium Storage drives

Link to report.