Innovative Data Integration Foundation to Business Intelligence Tiara

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

Agenda • • • Introduction BI Building Blocks Data Integration Innovation Q&A

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 • Global Software Company – India Market Development Partner • Leader in Embedded Data – Product Engineering Partner Infrastructure • Microsoft • Oracle GOLD Partner • TALLY Integrator, India – Cloud-based and On-premise Integration – Data Management (PSQL DB) – B 2 B Data Exchange

Business Intelligence – Building Blocks

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

Data Integration – Basic Elements

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

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

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

Worldwide Customers Deutsche Bank India Customers

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

Data Mediation Service (DMS) Connectors

MCF Components

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, Saa. S vendors and BPOs – Reusability of transformation features of the Engine – Enable applications to quickly integrate with external system

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 Saa. S applications – On-Demand Applications (E. g: Adaptive Planning)

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 Saa. S applications)

• Data. Cloud: 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 Data. Cloud Tools: Virtual IDE, Local IDE , Cloud Based Management Console • API Enabled (Data. Cloud API) – SOAP Interface, REST Interface – Entity Based Design: Easy to use • Multi-Tenant Support – Process and Data Separation • Multiple Work Engines

Pervasive Integration Agents • Powerful complement to Data. Cloud 2 • Distributed “Pervasive” Integration Pervasive Integration Agent – Cloud-based: • Delivery & installation, Configuration • Mapping • Management & monitoring • Lightweight platform capable “Spoke” Agent Applications & Databases 20

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

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

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 Venkatesh Babu, President & CEO Phone: +91 948 635 2370 (Mob) | Email: venkatesh@tiaraconsulting. com Vengadesh Ramakrishnan, 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