David Menninger's Analyst Perspectives

NOVEMBER 16, 2021

Talend is a data integration and management software company that offers applications for cloud computing, big data integration, application integration, data quality and master data management. Its code generation architecture uses a visual interface to create Java or SQL code.

Management 311

Management Data Warehouse Data Quality Data Integration 311

Data Virtualization

OCTOBER 5, 2022

For this reason, organizations must periodically revisit their data architectures, to ensure that they are aligned with current business goals.

Data Lake 52

Data Lake Data Architecture Data Integration Management 52

Data Virtualization

FEBRUARY 22, 2023

Reading Time: 2 minutes The data lakehouse attempts to combine the best parts of the data warehouse with the best parts of data lakes while avoiding all of the problems inherent in both. However, the data lakehouse is not the last word in data.

Data Lake 52

Data Lake Data Warehouse Data Integration Management 52

Data Virtualization

FEBRUARY 22, 2023

Reading Time: 2 minutes The data lakehouse attempts to combine the best parts of the data warehouse with the best parts of data lakes while avoiding all of the problems inherent in both. However, the data lakehouse is not the last word in data.

Data Lake 52

Data Lake Data Warehouse Data Integration Management 52

Data Virtualization

JANUARY 19, 2023

Reading Time: 2 minutes Today, many businesses are modernizing their on-premises data warehouses or cloud-based data lakes using Microsoft Azure Synapse Analytics. Unfortunately, with data spread.

Data Analytics 52

Data Analytics Data Lake Data Warehouse Analytics 52

Ontotext

APRIL 10, 2024

Data Lakes, Data Catalogs, and Findability Organizations approach data lakes as cheap storage. They move data to data lakes creating another copy – the mantra being – “ Lets move the data to a data lake and then we will figure out what to do with it”.

Metadata 52

Metadata Data Lake Data Warehouse Data Quality 52

BizAcuity

NOVEMBER 22, 2022

This typically requires a data warehouse for analytics needs that is able to ingest and handle real time data of huge volumes. Snowflake is a cloud-native platform that eliminates the need for separate data warehouses, data lakes, and data marts allowing secure data sharing across the organization.

Data Warehouse 98

Data Warehouse Cost-Benefit Data Lake Internet of Things 98

In(tegrate) the Clouds

JUNE 23, 2016

This week SnapLogic posted a presentation of the 10 Modern Data Integration Platform Requirements on the company’s blog. They are: Application integration is done primarily through REST & SOAP services. Large-volume data integration is available to Hadoop-based data lakes or cloud-based data warehouses.

Data Integration 49

Data Integration Data Lake Data Warehouse Data-driven 49

AWS Big Data

OCTOBER 19, 2023

Data lakes and data warehouses are two of the most important data storage and management technologies in a modern data architecture. Data lakes store all of an organization’s data, regardless of its format or structure.

Data Lake 110

Data Lake Data Warehouse Visualization Snapshot 110

AWS Big Data

NOVEMBER 10, 2023

This integration expands the possibilities for AWS analytics and machine learning (ML) solutions, making the data warehouse accessible to a broader range of applications. These tables are then joined with tables from the Enterprise Data Lake (EDL) at runtime. options(**read_config).option("query", cast("string")).dropDuplicates())

Data Processing 91

Data Processing Data Lake Data Warehouse Optimization 91

AWS Big Data

OCTOBER 20, 2023

Today, we are pleased to announce new AWS Glue connectors for Azure Blob Storage and Azure Data Lake Storage that allow you to move data bi-directionally between Azure Blob Storage, Azure Data Lake Storage, and Amazon Simple Storage Service (Amazon S3). option("header","true").load("wasbs://yourblob@youraccountname.blob.core.windows.net/loadingtest-input/100mb")

Data Lake 82

Data Lake Big Data Consulting Data Warehouse 82

AWS Big Data

FEBRUARY 29, 2024

However, enterprise data generated from siloed sources combined with the lack of a data integration strategy creates challenges for provisioning the data for generative AI applications. As part of the transformation, the objects need to be treated to ensure data privacy (for example, PII redaction).

Data Governance 93

Data Governance Unstructured Data Metadata Data Lake 93

AWS Big Data

DECEMBER 21, 2023

As the volume and complexity of analytics workloads continue to grow, customers are looking for more efficient and cost-effective ways to ingest and analyse data. OpenSearch Service is used for multiple purposes, such as observability, search analytics, consolidation, cost savings, compliance, and integration.

Analytics 94

Analytics IT Data Lake Visualization 94

AWS Big Data

APRIL 30, 2024

Today, we’re excited to announce general availability of Amazon Q data integration in AWS Glue. Amazon Q data integration, a new generative AI-powered capability of Amazon Q Developer , enables you to build data integration pipelines using natural language.

Data Integration 101

Data Integration Data Lake Data Warehouse Software 101

CIO Business Intelligence

APRIL 25, 2022

The data lakehouse is a relatively new data architecture concept, first championed by Cloudera, which offers both storage and analytics capabilities as part of the same solution, in contrast to the concepts for data lake and data warehouse which, respectively, store data in native format, and structured data, often in SQL format.

Recreation/Entertainment 119

Recreation/Entertainment Data Lake Data Warehouse Unstructured Data 119

BizAcuity

APRIL 1, 2023

This typically requires a data warehouse for analytics needs that is able to ingest and handle real time data of huge volumes. Snowflake is a cloud-native platform that eliminates the need for separate data warehouses, data lakes, and data marts allowing secure data sharing across the organization.

Data Warehouse 52

Data Warehouse Cost-Benefit Data Lake Internet of Things 52

CIO Business Intelligence

FEBRUARY 16, 2023

Selling the value of data transformation Iyengar and his team are 18 months into a three- to five-year journey that started by building out the data layer — corralling data sources such as ERP, CRM, and legacy databases into data warehouses for structured data and data lakes for unstructured data.

Unstructured Data 105

Unstructured Data Data Lake Prescriptive Analytics Digital Transformation 105

Cloudera

JUNE 2, 2022

What is less frequently mentioned is that during this same time we have also seen a rapid increase of cloud services where data needs to be delivered (data lakes, lakehouses, cloud warehouses, cloud streaming systems, cloud business processes, etc.).

Enterprise 98

Enterprise Data Lake Data Collection Data-driven 98

CIO Business Intelligence

JULY 13, 2022

What is less frequently mentioned is that during this same time we have also seen a rapid increase of cloud services where data needs to be delivered (data lakes, lakehouses, cloud warehouses, cloud streaming systems, cloud business processes, etc.).

Enterprise 88

Enterprise Data Lake Data Collection Data-driven 88

AWS Big Data

JUNE 28, 2023

Another example of AWS’s investment in zero-ETL is providing the ability to query a variety of data sources without having to worry about data movement. Data analysts and data engineers can use familiar SQL commands to join data across several data sources for quick analysis, and store the results in Amazon S3 for subsequent use.

Analytics 68

Analytics Data Warehouse Data Lake Data-driven 68

AWS Big Data

NOVEMBER 20, 2023

For any modern data-driven company, having smooth data integration pipelines is crucial. These pipelines pull data from various sources, transform it, and load it into destination systems for analytics and reporting. When running properly, it provides timely and trustworthy information.

Metrics 93

Metrics Data Lake Cost-Benefit Dashboards 93

AWS Big Data

AUGUST 31, 2023

Amazon Redshift is a fast, fully managed petabyte-scale cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing business intelligence (BI) tools. Amazon Redshift also supports querying nested data with complex data types such as struct, array, and map.

Data Lake 91

Data Lake Data Warehouse Metadata Data Architecture 91

AWS Big Data

JUNE 6, 2023

We are excited to announce the General Availability of AWS Glue Data Quality. Our journey started by working backward from our customers who create, manage, and operate data lakes and data warehouses for analytics and machine learning. Brian Ross is a Senior Software Development Manager at AWS.

Data Quality 93

Data Quality Statistics Data Lake Visualization 93

IBM Big Data Hub

JANUARY 5, 2023

The right data architecture can help your organization improve data quality because it provides the framework that determines how data is collected, transported, stored, secured, used and shared for business intelligence and data science use cases.

Data Quality 52

Data Quality Data Architecture Strategy Data Lake 52

Data Virtualization

APRIL 7, 2022

As far back as 2011 Gartner proposed the concept of a logical data warehouse as a way to overcome some of the challenges organizations. The post Does Data Always Need to End Up in a Centralized Repository? Reading Time: 3 minutes This is an age-old question, and one that has been asked many times over the years.

Data Warehouse 52

Data Warehouse Data Integration Management Data Lake 52

AWS Big Data

DECEMBER 13, 2023

A CDC-based approach captures the data changes and makes them available in data warehouses for further analytics in real-time. usually a data warehouse) needs to reflect those changes in near real-time. This post showcases how to use streaming ingestion to bring data to Amazon Redshift.

Data Warehouse 96

Data Warehouse Snapshot Data Processing Management 96

BizAcuity

MAY 16, 2022

So, make sure you have a data strategy in place. Data Integration. The easiest way to tap into data is integrating all your data to get a detailed understanding of your operations and your customers. Data mining. Despite being more complex, the output is delivered in record time.

Business Intelligence 52

Business Intelligence Data mining Visualization Data Lake 52

Data Virtualization

JULY 8, 2020

In my last post, I covered some of the latest best practices for enhancing data management capabilities in the cloud. Despite the increasing popularity of cloud services, enterprises continue to struggle with creating and implementing a comprehensive cloud strategy that.

Data Integration 52

Data Integration Strategy Enterprise Management 52

AWS Big Data

MAY 18, 2023

It’s even harder when your organization is dealing with silos that impede data access across different data stores. Seamless data integration is a key requirement in a modern data architecture to break down data silos. AWS Glue released version 4.0 runtime ( 3.5 AWS Glue released version 4.0 runtime ( 3.5

Testing 75

Testing Data Lake Cost-Benefit Data Integration 75

AWS Big Data

MARCH 29, 2024

You can slice data by different dimensions like job name, see anomalies, and share reports securely across your organization. With these insights, teams have the visibility to make data integration pipelines more efficient. Solution overview The following architecture diagram illustrates the workflow to implement the solution.

Metrics 103

Metrics Visualization Dashboards Interactive 103

Jet Global

OCTOBER 7, 2020

Confusing matters further, Microsoft has also created something called the Data Entity Store, which serves a different purpose and functions independently of data entities. The Data Entity Store is an internal data warehouse that is only available to embedded Power BI reports (not the full version of Power BI).

Data Warehouse 90

Data Warehouse OLAP Reporting Finance 90

Data Virtualization

MARCH 7, 2024

One thing is clear; if data-centric organizations want to succeed in. The post Data Management Predictions for 2024: Five Trends appeared first on Data Management Blog - Data Integration and Modern Data Management Articles, Analysis and Information.

Management 59

Management Data Integration Strategy Data Lake 59

AWS Big Data

FEBRUARY 8, 2023

Vyaire developed a custom data integration platform, iDataHub, powered by AWS services such as AWS Glue , AWS Lambda , and Amazon API Gateway. In this post, we share how we extracted data from SAP ERP using AWS Glue and the SAP SDK. Prahalathan M is the Data Integration Architect at Vyaire Medical Inc.

Testing 71

Testing Data Integration Data Lake Enterprise 71

Data Virtualization

JANUARY 25, 2024

One thing is clear; if data-centric organizations want to succeed in 2024, The post Data Management Predictions for 2024: Five Trends appeared first on Data Management Blog - Data Integration and Modern Data Management Articles, Analysis and Information.

Management 59

Management Data Integration Strategy Data Lake 59

In(tegrate) the Clouds

AUGUST 4, 2016

In my last post, I wrote about the new data integration requirements. In this post I wanted to share a few points made recently in a TDWI institute interview with SnapLogic founder and CEO Gaurav Dhillon when he was asked: What are some of the most interesting trends you’re seeing in the BI, analytics, and data warehousing space?

IoT 45

IoT Internet of Things Data Lake Data Warehouse 45

Data Virtualization

MAY 19, 2023

Reading Time: 11 minutes The post Data Strategies for Getting Greater Business Value from Distributed Data appeared first on Data Management Blog - Data Integration and Modern Data Management Articles, Analysis and Information.

Data Strategy 52

Data Strategy Strategy Data Integration Management 52

Data Virtualization

FEBRUARY 17, 2022

The post What is Data Virtualization? Understanding the Concept and its Advantages appeared first on Data Virtualization blog - Data Integration and Modern Data Management Articles, Analysis and Information. However, every day, companies generate.

IT 81

IT Data Integration Management Data Lake 81