TIBCO Data Virtualization Overview The Promise of Digital

TIBCO Data Virtualization Overview

The Promise of Digital Transformation As Data Grows, Leading Businesses Use It To Drive Better Outcomes and Beat Their Competition Business Outcomes Business Leaders Business Outcomes Other Businesses Data • • • Customer Profitability Faster Time to Market Cost Reduction Risk Management Compliance Overall Agility

The meaning(s) of Digital Transformation Democratization. Authorization Control Creativity Curation Consistency Disruption Federation Protection Business IT

Traditional Data Warehouse Business Intelligence • One Place to Go for Data • Business View of Data Warehouses & Marts Operational Stores Transactional Applications

Challenges • Accelerating Business Demand Self-Service Analytics Business Intelligence Dashboard, Portals • Proliferation of Distributed Silos • Many Different Access Protocols Data Warehouses & Marts Operational Stores “Big Data” & No. SQL Analytic Stores Transactional Applications Saa. S Applications Web Services

Analytic Stores “Big Data” & No. SQL Transactional Applications Self-Service Analytics Business Intelligence Data Warehouses Saa. S Applications Operational Stores Executive Dashboard Data Marts Web Services

Challenges • • Growing Complexity Increasing Cost Lack of Agility Stale Data

Logical Data Access Layer • One Logical Place to Go for Data Self-Service Analytics • Business View of Data Analytic Stores Dashboard, Portals Cisco Data Virtualization Abstract “Big Data” & No. SQL Business Intelligence Operational Stores Federate Data Warehouses & Marts Cache Transactional Applications Saa. S Applications Web Services

Challenges • • Growing Complexity Increasing Cost Lack of Agility Stale Data DV Solution • • Simple architecture Flexible software solution Agile change management Near-real-time data

The meaning(s) of Digital Transformation Democratization. Authorization Control Creativity Curation Consistency Disruption Federation Protection Business IT

Five Data Virtualization Value Drivers Business Value Acceleration • • • Derive initial business value sooner on implementation Derive ongoing value as changes are implemented faster Leverage the value of “right now” data Project Cost Avoidance • • • DV less costly to implement (versus ETL alternative) Faster and cheaper than manual federation, spreadmarts, etc. Reuse less costly than first time build Capital Expense Reduction or Avoidance • Infrastructure cost, licenses, depreciation, etc. Risk Reduction • Quicker user validation improves accuracy and avoids rework or failure Operating Expense Reduction • Lower ongoing support and maintenance costs

Data Virtualization Adoption Patterns Virtual Marts/ ODS Data Warehouse Extension Data Services Architecture

Data Virtualization Adoption Pattern Federation for Business Intelligence Project Manager Use Cases Virtual Marts/ ODS “My application requires data from multiple incompatible sources. ” • • • Federated views Data Services Data mash-ups Caches Virtual data marts Virtual operational stores

Data Virtualization Adoption Pattern Data Warehouse Extension for 360° View Data Warehouse Owner Use Cases Data Warehouse Extension “My data warehouse does not contain all the data required for the reports we need to build. ” • Data Warehouse Augmentation • MDM Hub Extension – 360 o View • Data Warehouse Federation • Hub and Virtual Spoke • Enterprise Architecture • Complementary ETL • Data Warehouse Prototyping • Data Warehouse Migration

Data Virtualization Adoption Pattern Data Services Architecture for Business & IT Agility Use Cases • • IT Director • • Data Services Architecture • • “How do I build an agile data layer for easy data access and delivery. • • Data Abstraction Layer Standards-compliant Data Services Layer Globally-distributed Data Virtualization Layer Forrester Information-asa-Service Forrester Data Architecture Reference Model Gartner Data Services Layer Bloor Informationoriented Architecture Rick van der Lans Data Delivery Platform

What is TIBCO DV? © Copyright 2000 -2017 TIBCO Software Inc. 17

Data Virtualization Runtime Production Steps 1. Application invokes request 2. Optimized query (single statement) executes 3. Deliver data in proper form TIBCO Information Server Optimizer Benefits • Low latency data • Optimized performance • Less replication required

Data Virtualization Runtime with Caching Production Steps 1. Cache data objects 2. Application invokes request 3. Optimized query (leveraging cached data) executes TIBCO Information Server 4. Deliver data in proper form Optimizer Benefits • Boosts performance • Avoids network constraints • Mitigates source system constraints Cache

Data Virtualization Architectural Overview TIBCO Data Virtualization Platform Front-end Applications Development Environment Management Environment TIBCO Information Server Business Directory Discovery SQL (ODBC, JDBC, ADO. NET) Web Services (HTTP, REST, SOAP, JSON, OData) Messaging (JMS) Manager Hadoop (Input Format) Security Views, SQLScript (Database Centric) Deployment Manager Metadata Federated Query Optimization Studio Caching Monitor Data Source Capabilities Security Adapters SQL (ODBC, JDBC) Web Services (REST, SOAP) Messaging (JMS) URI Hadoop Java MF Adapter Application APIs Active Cluster XML Applications Big Data Stores Excel Files Flat Files Mainframes Cloud Messages XML Docs RDBMS Web Services

Why TIBCO? © Copyright 2000 -2017 TIBCO Software Inc. 22

Why TIBCO? The best product Analytics Self-Service Development Environment Business Intelligence Transactional Apps Management Environment Run Time Environment Web Services SQL Business Directory Federation Engine Discovery Messaging (HTTP, REST, SOAP, JSON, OData) (ODBC, JDBC, ADO. NET) Cost-based Optimizer Rules-based Optimizer Object Repository Manager (JMS) Deployment Manager Security (SQL, SQL Script, Java, XQuery, XSLT) Monitor Studio Caching Adapters SQL (ODBC, JDBC) Governance Quality Web Services (REST, SOAP) Messaging (JMS) Hadoop Java Mainframe Active Cluster Application APIs XML Packaged Apps RDBMS Excel Files Data Warehouse OLAP Cubes Hadoop/Big Data XML Docs Flat Files Web Services

Why TIBCO? The most complete solution Proven at Top Financial Services, Communications, Energy, Healthcare and Manufacturing enterprises globally Strongest customer base and most active community Most complete solution + Advanced Services Customer Advisory Program Technical Support Knowledgebase Training Market Leadership

Why TIBCO? dvknowledge. com

Why TIBCO? Market leader with over 350 customers 60% Reduction in Infrastructure Costs $21 Million Increase in Revenue 60% Reduction in R&D Project Delays $1. 7 MM Reduction in Cost $9 Million in Revenue Acceleration

Here’s my problem… My Analytics users need a unified view of customer activity. Customer data resides in a MS SQL database Order data resides in a Postgres database Product data resides in an XML catalog document. XML Requirements • Fastest possible time -to-solution • Agility in response to future change • Low start-up costs • Low operational costs • Data freshness © 2017 Cisco and/or its affiliates. All rights reserved. Cisco Confidential 32

Data Abstraction Reference Architecture BI Server ESB/BPM EMEA Customer US Customer App Server Catalog Order Customer Purchase Orders Active Customer Online Orders Details Products XML Customers DB Purchasing DB Orders DB Application Layer Business Layer Orders Data Consumers Product Catalog Physical Layer Data Sources Data Abstraction |----- TIBCO Data Virtualization -----| Layered Architecture View