1 / 21

Innovative Data Integration

Innovative Data Integration. Tiara USA (San Ramon, CA) | India (Chennai) | Singapore www.tiaraconsulting.com India Market Development Partner – Pervasive Software. Foundation to Business Intelligence. Business Intelligence Conference, Mumbai April 16, 2011. Agenda. Introduction

euclid
Download Presentation

Innovative Data Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Innovative Data Integration Tiara USA (San Ramon, CA) | India (Chennai) | Singapore www.tiaraconsulting.com India Market Development Partner – Pervasive Software Foundation to Business Intelligence Business Intelligence Conference, Mumbai April 16, 2011

  2. Agenda Introduction BI Building Blocks Data Integration Innovation Q & A

  3. Tiara – Introduction Our Partners • Pervasive Software • India Market Development Partner • Product EngineeringPartner • 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 • Global IT Leader in Data Integration • Executed 50+ complex integrations • Specialized in BI, ERP, CRM • 175 person years of project experience

  4. Business Intelligence – Building Blocks

  5. Migration Extraction Integration Exchange Data Integration Cloud E-Commerce (Data Exchange) Extract – Transform – Load (ETL) Integration as a Service (Cloud based Integration)

  6. Data Integration – Basic Elements

  7. Innovation Data Mediation Services (DMS) Embedded Data Integration Service Oriented Approach (SOA) DataCloud – Cloud based Data Integration

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

  9. Pervasive Data Integrator – Demo Quick Demo of Pervasive Data Integrator Map Designer Process Designer

  10. Worldwide Customers India Customers Deutsche Bank

  11. 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

  12. Data Mediation Service (DMS) Connectors

  13. MCF Components

  14. 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

  15. 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 SaaSapplications • On-Demand Applications (E.g: Adaptive Planning)

  16. 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)

  17. 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

  18. 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

  19. 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

  20. 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

  21. THANK YOU Our Contacts Tiara Consulting– USA (California) | India (Chennai) | Singapore Phone:(044) 4345 7250 (Dir) | Email:solutions@tiaraconsulting.com Pervasive Software, Austin, TX – www.pervasiveintegration.com VenkateshBabu, President & CEO Phone: +91 948 635 2370 (Mob) | Email:venkatesh@tiaraconsulting.com VengadeshRamakrishnan, Regional Manager Phone: +91 9566695671 (Mob) | Email:rvengadesh@tiaraconsulting.com Naveen Prabhu A T, IT Solutions Manager Phone: +91 9442307040 (Mob) | Email:naveenprabhu@tiaraconsulting.com www.tiaraconsulting.com

More Related