Solution Centric Architectural Presentation - Implementing a Logical Data Warehouse

Dec 22, 20210 likes121 views

Watch full webinar here: https://bit.ly/3H5AYZf Implementing a logical data fabric as an architecture makes absolute sense when you have data spread across various sources in the cloud, including data warehouses, data lakes and even realtime data. In this session our customer will discuss the ways in which they implemented Denodo as a logical data fabric and how it helped them reduce risk and speed up time to access data.

Logical Data Fabric: The Future of Data
Management and Analytics

#DenodoDataFest
Implementing a Logical Data Warehouse
Data Architect, Sharp Healthcare
Holly Burch

Solution Centric Architectural Presentation - Implementing a Logical Data Warehouse

Introduction:
Holly Burch
• Primary Denodo architect and platform administrator
Denodo Journey
• Jon McManus, new VP Enterprise Analytics, arrives Oct 2018 with the vision of
implementing a Logical Data Warehouse
• Began implementing Denodo platform Summer 2019
• Currently at more than 100 data sources from more than 40 source systems
• Denodo 8.0 platform currently on-premise and planning to move it to the cloud

Vision:
Logical Data Warehouse
• Apply an architectural approach that enables access to multiple, diverse data
sources (both on premise and multi-cloud) while appearing as one “logical” data
source to users.
Data Marketplace
• Provide a single place to browse, consume, and create consumable content.

Frustrations:
• 30 projects/year
• Process = Slow grind
• New Source
• 2 – 3 months
• Enhancement
• 2 – 3 weeks
• Limited access for
end-users
• Hard to blend data
AGILE? NO

Transformation:
• Centers of Excellence
• Process = Agile teams
• New source: 2 – 3 weeks
• Enhancement: 2 – 3 days
• Easy to blend/enrich data
• Navigate EMR and ERP system
changes
• Back-end migrations with no
impact to end-users
• Marketplace access
• Many ways to deliver
AGILE? YES
Logical Data Warehouse

Use Case: Migration off Cloudera Impala to Snowflake
Cloudera Impala
• Real-Time streaming of HL7 messages – Lab orders/results, Scheduling
• Real-Time streaming of Electronic Medical Record data
• Denodo views of Lab data feeding to critical covid dashboards
• Denodo views of Scheduling data exported hourly for patient feedback
Snowflake Migration
• Migrated storage of data from Impala to Snowflake
• Brought in new Snowflake base views to Denodo
• Updated existing integration layer views to source from Snowflake base views instead
of Impala base views.
• 3 - 4 weeks to fully test and implement in Denodo

Summary:
Logical Data Warehouse with Denodo as a key component allows us to:
• Create a Data Marketplace for client consumption
• Bring on-prem and cloud-based data together to appear as one “logical” source
• Blend/enrich data between sources
• Navigate major EMR and ERP platform changes
• Migrate back-end sources without impacting end users
• Support agile workflows

© Copyright Denodo Technologies. All rights reserved
Unless otherwise specified, no part of this PDF file may be reproduced or utilized in
any for or by any means, electronic or mechanical, including photocopying and
microfilm, without prior the written authorization from Denodo Technologies.
Thank You!

This document summarizes a webinar on data virtualization and Denodo's data catalog. The webinar covers the challenges of self-service data strategies, how a data catalog can help address these challenges by providing a single source of truth and improving discoverability, collaboration and understanding of data. It also provides best practices for data catalog implementation and customer stories of how Indiana University has used Denodo's data catalog for decision support.

Analyst Keynote: Forrester: Data Fabric Strategy is Vital for Business Innova...Denodo

Self Service Analytics enabled by Data Virtualization from DenodoDenodo

Watch full webinar here: https://bit.ly/39U9qY8 Self-service Analytics BI is often quoted by many - ie, allow users to discover and access data without having to ask IT to create a data mart, or by allowing users to directly export/copy the data from the data sources themselves into their analytics tools and systems. The challenge is not just to provide access to the data – even from Excel this can be done - but to do this in real time without creating processing overhead, while getting trusted data, with the best response time possible, in a managed, governed and secure way in order for these users to trust the output of the analysis. Data Virtualization provides a data access platform that allows users to access the data they need from multiple data sources, when they need it, and with the best possible response time. In addition, a Data Marketplace built on top of this proven technology enables Self Service Analytics by exposing consistent and governed data sets to be discovered by users, providing the trusted foundation for a successful Self-Service Analytics initiative.

GDPR Noncompliance: Avoid the Risk with Data VirtualizationDenodo

The document discusses how data virtualization can help organizations comply with the General Data Protection Regulation (GDPR). It provides an overview of GDPR requirements and outlines how data virtualization addresses three pillars of compliance: providing a complete view of data subjects, enabling self-service data catalogs, and designing for privacy and responsibility. Specifically, data virtualization can give a single, real-time view of customer data across systems, allow discovery and access to curated data, and ensure consistent security, governance and auditability of personal data.

Big Data Fabric: A Necessity For Any Successful Big Data InitiativeDenodo

Watch this webinar in full here: https://buff.ly/2IxM8Iy Watch all webinars from the Denodo Packed Lunch webinar series here: https://buff.ly/2IR3q6w While big data initiatives have become necessary for any business to generate actionable insights, big data fabric has become a necessity for any successful big data initiative. The best of breed big data fabrics should deliver actionable insights to the business users with minimal effort, provide end-to-end security to the entire enterprise data platform and provide real-time data integration, while delivering self-service data platform to business users. Attend this session to learn how big data fabric enabled by data virtualization: • Provides lightning fast self-service data access to business users • Centralizes data security, governance and data privacy • Fulfills the promise of data lakes to provide actionable insights

Data Services and the Modern Data Ecosystem (Middle East)Denodo

Watch full webinar here: https://bit.ly/3xdSTIU Digital Transformation has changed IT the way information services are delivered. The pace of business engagement, the rise of Digital IT (formerly known as “Shadow IT), has also increased demands on IT, especially in the area of Data Management. Data Services exploits widely adopted interoperability standards, providing a strong framework for information exchange but also has enabled a growth of robust systems of engagement that can now exploit information that was normally locked away in some internal silo. Join us for our upcoming Middle East Webinar series episode, “Data Services and the Modern Data Ecosystem,” presented by Chief Evangelist MEA, Alexey Sidorov. Tune-in as we explore how a business can easily support and manage a Data Service ecosystem, providing a more flexible approach for information sharing supporting an ever diverse community of consumers. Watch on-demand this webinar to learn: - Why Data Services are a critical part of a modern data ecosystem - How IT teams can manage Data Services and the increasing demand by businesses - How Digital IT can benefit from Data Services and how this can support the need for rapid prototyping allowing businesses to experiment with data and fail fast where necessary. - How a good Data Virtualization platform can encourage a culture of Data amongst business consumers (internally and externally)

A Logical Architecture is Always a Flexible Architecture (ASEAN)Denodo

Watch full webinar here: https://bit.ly/3joZa0a The current data landscape is fragmented, not just in location but also in terms of processing paradigms: data lakes, IoT architectures, NoSQL, and graph data stores, SaaS applications, etc. are found coexisting with relational databases to fuel the needs of modern analytics, ML, and AI. The physical consolidation of enterprise data into a central repository, although possible, is both expensive and time-consuming. A logical data warehouse is a modern data architecture that allows organizations to leverage all of their data irrespective of where the data is stored, what format it is stored in, and what technologies or protocols are used to store and access the data. Watch this session to understand: - What is a logical data warehouse and how to architect one - The benefits of logical data warehouse – speed with agility - Customer use case depicting logical architecture implementation

A Successful Data Strategy for Insurers in Volatile Times (ASEAN)Denodo

Watch full webinar here: https://bit.ly/3rpr4La Data is an insurer’s most valuable asset. Capitalizing on all of that stored and incoming data to draw valuable insights for business decisions is what ultimately makes a competitive difference. But, insurers face challenges when it comes to modernizing and digitizing their data architectures. Most organizations rely on traditional systems and data integration processes that are time consuming and slow. In addition, as many adopt cloud strategies, these traditional approaches fill the cloud modernization process with downtime and end user frustration. This is why insurers need a flexible and easily adaptable data integration technology that allows them to keep up with the ever-changing and growing data environment. Data virtualization is that modern data integration technology. It can support insurers not only on their journey to digitization, but also on their future infrastructure changes and innovations, adding agility, flexibility and efficiency to data architectures. Data virtualization can help insurance companies create 360° views of deals and claims processes as well as gather quick social media or sensor data for on-the-go risk profiling. Join this on-demand webinar to: - Find out why data virtualization should be a part of your enterprise data strategy - See how this technology can help you capitalize on your data - Hear how many of your peers are already leveraging the Denodo Platform for Data Virtualization and the benefits they’re observing

Data Virtualization - Enabling Next Generation AnalyticsDenodo

Watch full webinar here: https://goo.gl/3gNMXX Webinar featuring guest speaker Boris Evelson, Vice President, Principal Analyst at Forrester Research and Lakshmi Randall, Director of Product Marketing, Denodo. Majority of enterprises today are data-aware. Being data-aware, or even data-driven, however, is not enough. Are your data-driven applications providing contextual and actionable insight? Are your analytics applications driving tangible business outcomes? Are you deriving insights from all the enterprise data? Enter Systems Of Insight (SOI), Forrester's latest analytical framework for insights-driven businesses. In this webinar you will learn about the key principles that differentiate data-aware or data-driven businesses from their insights-driven peers and competitors. Specifically the webinar will explore roles data virtualization (aka Data Fabric) plays in modern SOI architectures such as: • A single virtual catalog / view on all enterprise data sources including data lakes. • A more agile and flexible virtual enterprise data warehouse. • A common semantic layer for business intelligence (BI) and analytical applications (aka BI Fabric).

SAP Analytics Cloud: Haben Sie schon alle Datenquellen im Live-Zugriff?Denodo

Watch full webinar here: https://bit.ly/3hfEO6d Die SAP Analytics Cloud (kurz "SAC" genannt) ist ein Service in der Cloud, der umfangreiche Analysefunktionen für Benutzer in einem Produkt bereit stellt. Wie immer bei der SAP ist auch die SAC technologisch gut integriert in die Welt der SAP Systeme. Doch die Daten, die Unternehmen heutzutage analysieren möchten, befinden sich sehr häufig in den unterschiedlichsten Datenquellen: In relationalen Datenbanken, in Data Lakes, in Webservices, in Dateien, in NoSQL Datenbanken,... Und so stellt sich zwangsläufig die Frage, wie Sie aus der SAC heraus alle Daten konnektieren, transformieren und kombinieren können. Und das möglichst live, d.h. mit Abfragen auf Echtzeit-Daten! Hier kommt die Datenvirtualisierung ins Spiel: Sie bietet Anwendungen (so auch der SAC) einen einheitlichen, integrierten und performanten Zugriff auf SAP Daten und non-SAP Daten. Erfahren Sie in diesem Webcast: - Wie die Datenvirtualisierung funktioniert (in a Nutshell) - Wie Sie aus der SAC heraus auf alle ihre Daten in Echtzeit zugreifen können ("Live Data Connection" genannt) - Wie die Datenvirtualisierung die Performance auch für Abfragen auf grossen Datenmengen optimiert

Customer Keynote: Data Service and Security at an Enterprise Scale with Logic...Denodo

Watch full webinar here: https://bit.ly/3xepiQa Denodo customer McCormick created a logical data fabric (LDF) with data virtualization, to create Enterprise Data Service (EDS) for self-service analytics, integration, web and mobile applications. Listen to this presentation to learn how McCormick uses LDF for better business decisions and strategic planning via democratized information assets and in the process minimize information consumption risks via centralized security model.

Discover how Covid-19 is accelerating the need for healthcare interoperabilit...Denodo

Watch full webinar here: https://bit.ly/3cZDAvo As COVID -19 continues to challenge entire healthcare ecosystems and forcing healthcare organizations to pivot without much notice, patient information interoperability and data transparency are increasingly taking center stage among healthcare stakeholders. This year, a new set of federal guidelines giving patients more access to their data goes into effect, improving interoperability. Even without this, most healthcare stakeholders would agree that better, and mobile, access, and interoperability of information could improve care and save time and lives. Watch on-demand this webinar to learn: - How health IT interoperability can help your healthcare organization move forward to better health reporting, patient matching and care coordination in 2021 and beyond. - How to set up your healthcare organization for success through more information transparency, how this can help your healthcare stakeholders. - COVID 19 has given federal agencies a lot of momentum to move even more quickly regarding implementing interoperability rules, what does this mean for your organization?

KASHTECH AND DENODO: ROI and Economic Value of Data VirtualizationDenodo

Watch full webinar here: https://bit.ly/3sumuL5 Join KashTech and Denodo to discover how Data Virtualization can help accelerate your time-to-value from data while reducing the costs at the same time. Gartner has predicted that organizations using Data Virtualization will spend 40% less on data integration than those using traditional technologies. Denodo customers have experienced time-to-deliver improvements of up to 90% within their data provisioning processes and cost savings of 50% or more. As Rod Tidwell (Cuba Gooding Jr.) said in the movie 'Jerry Maguire', "Show me the money!" Register to attend and learn how Data Virtualization can: - Accelerate the delivery of data to users - Drive digital transformation initiatives - Reduce project costs and timelines - Quickly deliver value to your organization

How Data Virtualization Puts Machine Learning into Production (APAC)Denodo

Watch full webinar here: https://bit.ly/3mJJ4w9 Advanced data science techniques, like machine learning, have proven an extremely useful tool to derive valuable insights from existing data. Platforms like Spark, and complex libraries for R, Python and Scala put advanced techniques at the fingertips of the data scientists. However, these data scientists spend most of their time looking for the right data and massaging it into a usable format. Data virtualization offers a new alternative to address these issues in a more efficient and agile way. Attend this session to learn how companies can use data virtualization to: - Create a logical architecture to make all enterprise data available for advanced analytics exercise - Accelerate data acquisition and massaging, providing the data scientist with a powerful tool to complement their practice - Integrate popular tools from the data science ecosystem: Spark, Python, Zeppelin, Jupyter, etc

Applying Big Data Superpowers to HealthcarePaul Boal

Agile Data Management with Enterprise Data Fabric (ASEAN)Denodo

Watch full webinar here: https://bit.ly/3juxqaw In a world where machine learning and artificial intelligence are changing our everyday lives, digital transformation tops the strategic agenda in many private and government organizations. Data is becoming the lifeblood of a company, flowing seamlessly through it to enable deep business insights, create new opportunities, and optimize operations. Chief Data Officers and Data Architects are under continuous pressure to find the best ways to manage the overwhelming volumes of the data that tend to become more and more distributed and diverse. Moving data physically to a single location for reporting and analytics is not an option anymore – this is the fact accepted by the majority of the data professionals. Join us for this webinar to know about the modern virtual data landscapes including: - Virtual Data Fabric - Data Mesh - Multi-Cloud Hybrid architecture - and to learn how to leverage the Denodo Data Virtualization platform to implement these modern data architectures.

Data Virtualization enabled Data Fabric: Operationalize the Data Lake (APAC)Denodo

Watch full webinar here: https://bit.ly/3aIofv9 The best of breed big data fabrics should deliver actionable insights to the business users with minimal effort, provide end-to-end security to the entire enterprise data platform and provide real-time data integration, while delivering self-service data platform to business users. While big data initiatives have become necessary for any business to generate actionable insights, big data fabric has become a necessity for any successful big data initiative. The best of breed big data fabrics should deliver actionable insights to the business users with minimal effort, provide end-to-end security to the entire enterprise data platform and provide real-time data integration, while delivering self-service data platform to business users. Attend this session to learn how big data fabric enabled by data virtualization: - Provides lightning fast self-service data access to business users - Centralizes data security, governance and data privacy - Fulfills the promise of data lakes to provide actionable insights

Denodo DataFest 2016: Data Science: Operationalizing Analytical Models in Rea...Denodo

Watch the full session: Denodo DataFest 2016 sessions: https://goo.gl/yVJnti Data virtualization starts with democratizing data access for business users, but goes well beyond to enable entire analytics life cycle. This session will discuss the critical role of data virtualization in the four key phases of big data analytics: Discovery of raw and enriched data, Analytic Exploration, Real-time Operationalization, and Predictive Intervention. In this session, you will learn: • Design of advanced analytics with view towards business goal realization • The role of data virtualization in enabling analytics through four key phases • How to exploit product capabilities relevant to each stage • Creating a system of governed self-service and collaborative analytics This session is part of the Denodo DataFest 2016 event. You can also watch more Denodo DataFest sessions on demand here: https://goo.gl/VXb6M6

Logical Data Fabric: Architectural ComponentsDenodo

Analyst Keynote: TDWI: Data Virtualization as a Data Management Strategy for ...Denodo

Denodo DataFest 2017: Company Leadership from Data LeadershipDenodo

Watch the live session on-demand here: https://goo.gl/Sc6JNG An increase in data leadership correlates to an increase in business success. Every single item on a company mission statement relates to data at some level. It is from the position of data expertise that the mission will be executed and company leadership will emerge. The data professional is absolutely sitting on the performance of the company in this information economy and has an obligation to demonstrate the possibilities and originate the architecture, data and projects that will deliver. After all, no matter what business you’re in, you’re in the business of information. The data leader will anticipate the need -- the voracious need -- for data. If the need does not seem to exist, that is where to start. Commit to growing the data science at your organization. It's simply not enough to be responsive to urgent requests and be the data leader that companies need. The speaker will share from experience some of the hallmarks of mature, leading data environments that leaders will be guiding their data environments towards in the next few years, with the goal of helping true data leadership emerge.

A Successful Data Strategy for Insurers in Volatile Times (EMEA)Denodo

This webinar discusses how data virtualization can help insurance companies address challenges from trends like digital disruption and mergers and acquisitions. It provides examples of how Denodo has helped customers like AXA XL and Prudential Financial improve data access, consistency, and governance through a data fabric architecture built on data virtualization. Key benefits highlighted include reduced data replication, increased data accuracy and reliability, role-based access controls, and more agile use of data to support initiatives like analytics and regulatory reporting.

Analyst Webinar: Best Practices In Enabling Data-Driven Decision MakingDenodo

Watch full webinar here: https://bit.ly/37YkgN4 This presentation looks at the trends that are emerging from companies on their journeys to becoming data-driven enterprises. These trends are taken from a survey of 500 companies and highlight critical success factors, what companies are doing, their progress so far and their plans going forward. It also looks at the role that data virtualization has within the data driven enterprise. During the session we'll address: - What is a data-driven enterprise? - What are the critical success factors? - What are companies doing to create a data-driven enterprise and why? - What progress are they making? - What are the plans on people, process and technologies? - Why is data virtualization central to provisioning and accessing data in a data-driven enterprise? - How should you get started?

Logical Data Warehouse: The Foundation of Modern Data and AnalyticsDenodo

The document discusses the benefits of a logical data warehouse architecture. It notes that a logical data warehouse provides a flexible architecture that can accommodate shifts in analytical technologies. In contrast to a physical data warehouse, a logical data warehouse easily incorporates new technologies without impacting business users. Key benefits include fulfilling data warehousing goals of analyzing enterprise data from all sources, democratizing data consumption, and centralizing business definitions to avoid replication across reporting tools.

Why Data Virtualization? An Introduction.Denodo

Watch full webinar here: https://bit.ly/3dhbZTK What started to evolve as the most agile and real-time enterprise data fabric, data virtualization is proving to go beyond its initial promise and is becoming one of the most important enterprise big data fabrics. Watch this session to learn: - What data virtualization really is. - How it differs from other enterprise data integration technologies. - Why data virtualization is finding enterprise-wide deployment inside some of the largest organizations.

Driving Datascience at scale using Postgresql, Greenplum and Dataiku - Greenp...VMware Tanzu

This document discusses using Dataiku as an end-to-end enterprise AI platform to drive data science at scale using PostgreSQL, Greenplum, and Dataiku. It highlights how Dataiku allows business analysts, data engineers, and data scientists to collaborate on a single platform for data preparation, machine learning modeling, and model deployment. It also provides examples of how customers like a major software company have leveraged Dataiku to automate the deployment of over 12,000 predictive models.

Logical Data Warehouse: The Foundation of Modern Data and Analytics (APAC)Denodo

Watch full webinar here: https://bit.ly/3bBArAc Companies are investing in data warehouse modernization and data lake projects for descriptive and advanced analytics; however, for the analysis to be holistic, today’s architects weave disparate data streams together, not only from these analytical sources, but also from operational, third party, and streaming data sources. Logical data warehouse is a modern architectural methodology that virtually combines all the data across the enterprise and makes it available to analytical and visualization tools that facilitate timely, insightful, and impactful decisions throughout the enterprise. In this session, you will learn: - What is logical data warehouse and how to architect one - The benefits of logical data warehouse – speed with agility

Data Lake Acceleration vs. Data Virtualization - What’s the difference?Denodo

Watch full webinar here: https://bit.ly/3hgOSwm Data Lake technologies have been in constant evolution in recent years, with each iteration primising to fix what previous ones failed to accomplish. Several data lake engines are hitting the market with better ingestion, governance, and acceleration capabilities that aim to create the ultimate data repository. But isn't that the promise of a logical architecture with data virtualization too? So, what’s the difference between the two technologies? Are they friends or foes? This session will explore the details.

Use Cases from Batch to Streaming, MapReduce to Spark, Mainframe to Cloud: To...Precisely

This document discusses how Syncsort helps companies access and integrate data from various sources to power analytics. It provides examples of how Syncsort has helped companies in insurance, media, and hotels easily onboard and integrate both historical and streaming data from multiple sources like mainframes, databases, and IoT devices. This allows for faster insights, increased productivity, cost savings, and helps future proof applications.

Moving data to the cloud BY CESAR ROJAS from PivotalVMware Tanzu Korea

This document discusses moving data warehousing to the cloud with Pivotal Greenplum. It recommends obeying the laws of data gravity by leaving data where it is generated, adopting a software data warehouse that can run anywhere, and separating compute and storage. It positions Greenplum as a massively parallel, open source data warehouse that can run on-premises, in the cloud, or in hybrid environments with real separation of compute and storage. The document provides examples of customers successfully using Greenplum in the cloud at AWS for analytics, reporting, and migrating workloads from legacy data warehouses.

More Related Content

What's hot (20)