Innovative Data Integration - PowerPoint PPT Presentation

About This Presentation
Title:

Innovative Data Integration

Description:

Innovative Data Integration Foundation to Business Intelligence Tiara USA (San Ramon, CA) | India (Chennai) | Singapore www.tiaraconsulting.com India Market ... – PowerPoint PPT presentation

Number of Views:322
Avg rating:3.0/5.0
Slides: 22
Provided by: TiaraVe
Category:

less

Transcript and Presenter's Notes

Title: Innovative Data Integration


1
Innovative Data Integration
  • Foundation to Business Intelligence

Tiara USA (San Ramon, CA) India (Chennai)
Singapore www.tiaraconsulting.com India Market
Development Partner Pervasive Software
Business Intelligence Conference, Mumbai April
16, 2011
2
Agenda
  • Introduction
  • BI Building Blocks
  • Data Integration
  • Innovation
  • Q A

3
Tiara Introduction
  • Global IT Leader in Data Integration
  • Executed 50 complex integrations
  • Specialized in BI, ERP, CRM
  • 175 person years of project experience
  • Our Partners
  • Pervasive Software
  • India Market Development Partner
  • Product Engineering Partner
  • Microsoft
  • Oracle GOLD Partner
  • TALLY Integrator, India
  • Pervasive Software
  • Global Software Company
  • Leader in Embedded Data Infrastructure
  • Cloud-based and On-premise Integration
  • Data Management (PSQL DB)
  • B2B Data Exchange

4
Business Intelligence Building Blocks
5
Business Intelligence Building Blocks
Building Block Features
Data Integration Enabler of Business Intelligence
Data warehouse Dimensional view vs. simple view
OLAP Reporting Slicing and Dicing of data to generate intelligent reporting
Predictive Analytics Apply statistical methods on data warehouse to predict future business activities
6
Unified Business Intelligence
7
Data Integration
E-Commerce (Data Exchange)
Extract Transform Load (ETL)
Integration as a Service (Cloud based Integration)
8
Data Integration Basic Elements
9
Innovation
  • Data Mediation Services (DMS)
  • Embedded Data Integration
  • Service Oriented Approach (SOA)
  • DataCloud Cloud based Data Integration

10
Pervasive Data Integrator Architecture
  • Data Standardization In-built functions /
    schemas and components to support data standards
    such as EDI, HL7 (Healthcare) etc.

11
Pervasive Data Integrator Demo
  • Quick Demo of Pervasive Data Integrator
  • Map Designer
  • Process Designer

12
Worldwide Customers
13
Data Mediation Service (DMS) Expandable
Integration
DMS Connector for MS Dynamics CRM
DMS Component for TALLY ERP9
DMS Component for MS Dynamics CRM Online
Pluggable
Data Mediation Service (DMS) PDI Native
Connector SDK (Open Standards)
Reusable
  • Data Mediation Service (DMS) Map Designer
    Connector SDK
  • Message Component Framework (MCF) Process
    Designer SDK
  • Open standards (SDO, WS-), Java Plug-in
    environment
  • Proprietary framework of Pervasive (accessible
    via Java)
  • Pluggable and embeddable Universal CONNECTTM
  • High Reusability Largest ROI

14
Data Mediation Service (DMS) Connectors
15
MCF Components
16
Embedded Data Integration
  • Embedding Data Integration tool as an in-built
    module within any application
  • Data Integration Engine can be executed via an
    SDK
  • SDK allows command level interface from Java
  • Best suitable for ISVs, SaaS vendors and BPOs
  • Reusability of transformation features of the
    Engine
  • Enable applications to quickly integrate with
    external system

17
SOA based Data Integration
  • Using Web Services to enable data integration
  • Transaction / Service Request (SOAP) based data
    integration
  • Enables easy integration with enterprise
    applications
  • REST Invoker Does not require an adapter
  • REST based Invoker (MCF component) returns XML
    data
  • Leverage XML connector to integrate with other
    systems
  • Best suited for SaaS applications
  • On-Demand Applications (E.g Adaptive Planning)

18
Cloud based Integration New Deployment Models
Cloud
On-premise
  • Data Integration tool (ETL) running on a Cloud
    platform
  • Cost effective pay-per-use model
  • Enables delivery of ready-made integration
    solutions
  • Best fit for cloud to cloud integration
    (integration between SaaS applications)

19
  • DataCloud a Cloud based Integration platform
  • Design and Deployment of Data Integration
    solutions on the Cloud
  • Data Web Services (DWS) for AWS (Amazon Web
    Services)
  • Design Deploy using DataCloud Tools Virtual
    IDE, Local IDE , Cloud Based Management Console
  • API Enabled (DataCloud API)
  • SOAP Interface, REST Interface
  • Entity Based Design Easy to use
  • Multi-Tenant Support
  • Process and Data Separation
  • Multiple Work Engines

20
Pervasive Integration Agents
  • Powerful complement to DataCloud 2
  • Distributed Pervasive Integration
  • Pervasive Integration Agent Cloud-based
  • Delivery installation, Configuration
  • Mapping
  • Management monitoring
  • Lightweight platform capable

Spoke
Agent
Applications Databases
20
21
Summary
  • Data Innovation Design once, deploy anywhere
    Pluggable, re-usable
  • Universal Connect Any end-point to Any end-point
    Integration
  • Integration as a Service (IAAS)
  • Data Cloud Integration on the Cloud using
    Lightweight Integration Agents

22
Open Discussion
  • Challenges
  • 1) Data Quality Handling accuracy, duplicates
    etc.
  • Solution DQ Tools such as Profiler, MatchMerge
  • 2) Data Size Integration of large size of data
  • Solution(s)
  • Pervasive Data Rush Parallel Processing, and
  • Hadoop Distributed Data Processing based on
    Google BigData HDFS (Hadoop Distributed File
    System), Map/Reduce, HBase
  • Question Answers

23
THANK YOU
Our Contacts Tiara Consulting USA (California)
India (Chennai) Singapore Phone (044) 4345
7250 (Dir) Email solutions_at_tiaraconsulting.com
Pervasive Software, Austin, TX
www.pervasiveintegration.com Venkatesh Babu,
President CEO Phone 91 948 635 2370 (Mob)
Email venkatesh_at_tiaraconsulting.com Vengadesh
Ramakrishnan, Regional Manager Phone 91
9566695671 (Mob) Email rvengadesh_at_tiaraconsulti
ng.com Naveen Prabhu A T, IT Solutions
Manager Phone 91 9442307040 (Mob) Email
naveenprabhu_at_tiaraconsulting.com www.tiaraconsult
ing.com
Write a Comment
User Comments (0)
About PowerShow.com