1 / 19

Heterogeneous Data Sources and Their Integration Leveraging Oracle BI Apps / OBIEE

Heterogeneous Data Sources and Their Integration Leveraging Oracle BI Apps / OBIEE. Vinay Dhingra BI Practice Manager, Apps Associates Date: 24-09-2011. Agenda. Introduction Challenges faced in Successful Implementation of BI BI Products Levels of Maturity

adair
Download Presentation

Heterogeneous Data Sources and Their Integration Leveraging Oracle BI Apps / OBIEE

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. Heterogeneous Data Sources and Their Integration Leveraging Oracle BI Apps / OBIEE Vinay Dhingra BI Practice Manager, Apps Associates Date: 24-09-2011

  2. Agenda • Introduction • Challenges faced in Successful Implementation of BI • BI Products Levels of Maturity • Oracle BI Application Architecture • Our Company: Apps Associates • Q&A

  3. Introduction Vinay Dhingra BI Practice Manager, Apps Associates • 12+ years of experience as BI Architect, Tech lead, PM, etc. • Practice Manager with Apps Associates managing 50+ consultants • Lead Consultant/Architect in Core Engineering group at Oracle for Financial and HR Analytics • Consultant in US with KPI Partners and started the BI GDC for them • Holds Bachelor degree in Mechanical Engineering • Vinay has participated in over 20 Business Intelligence implementation / upgrades • Lead the first Oracle BI Financial Analytics implementation in 2008

  4. Today’s Discussion Heterogeneous Data Sources and Their Integration Leveraging Oracle BI Apps / OBIEE What is BI ? • Business Intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better business decisions. • BI Applications includes the activities of decision support system, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting and data mining. What is involved in BI ? Key challenges faced by organization in Implementation • Build Robust Data Warehouse Architecture • Integration of Heterogeneous Data Source System • Performance • Scalability

  5. Heterogeneous Data Sources Multiple Applications • Transactional data stored in multiple applications such as Oracle EBS, PeopleSoft, Siebel, JD Edwards, SAP or home grown custom applications….. Multiple Databases/Files • Data is stored in multiple databases such as Oracle, SQL Server, DB2, Teradata, MySQL, Access, Excel .... Multiple Domains • Financials, HRMS, Order, Management, Procurement, Planning, Manufacturing, Inventory Control, CRM…etc. Data Flow across Multiple Applications • Flow of data across multiple applications

  6. BI Solutions – Level of Maturity 3 Level 3 : Plug and play technology More efficient & faster Ex: Oracle BI Apps/OBIEE 2 Level 2 : Automated tools created domain based intelligent reporting sets ex. Purchasing Intelligence Ex: Daily Business Intelligence Business Value 1 Level 1 : Limited technology to extract relevant data Time consuming & lot of manual effort required Ex: Discoverer/Oracle DWH Level of Sophistication

  7. 1st Level of Maturity: Ex. Oracle Discoverer 1 Discoverer Adhoc Reporting • Challenges: • Oracle DB only • Challenging to configure • Difficult to use EBS OLTP Data Source: Oracle

  8. DBI 2nd Level of Maturity: Ex. Oracle DBI 2 EBS Apps • Utilizes EBS Instance • Created via Concurrent job extracts • Drill to Transactional data MVs • Challenges: • Contention with OLTP users (limited scalability) • Limited configurability • No Adhoc capability EBS OLTP Data Source: Oracle

  9. DBI 3 3rd Level of Maturity: Ex. Oracle BI Apps EBS Apps Oracle buys Siebel, introduces new set of BI Tools – Oracle Business Intelligence Suite Enterprise Edition Discoverer MVs EBS OLTP Data Source: Oracle

  10. Proactive Detection and Alerts Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Disconnected Analytics MS Office Plug-in WebServices Oracle BI Suite EE Oracle BI Applications - DetailedSingle- and multi-source Analytic Apps Built on BI Suite EE Sales Service &Contact Center Marketing Order Management& Fulfillment Supply Chain Financials HumanResources Oracle BI Applications IVR, ACD, CTI Hyperion MS Excel Other Data Sources BAW Schema Packaged ETL Maps UniversalAdapters Source: Oracle

  11. Oracle BI Apps Core Proposition –Fin. Analytics

  12. Heterogeneous Data Extraction and Loading Business Analytics Warehouse Load Source Independent Load Staging Tables Source Dependent Extract • Is source-specific and supports universal business adaptors • Exposes simplified business entities from complex source systems • Converts source-specific data to universal staging table format • Is lightweight and designed for performance and parallelism • Is extensible SQL SQL SQL Power Connect Power Connect Extract SQL ABAP Siebel OLTP Oracle Other App Layer App Layer PeopleSoft SAP

  13. Heterogeneous Data Extraction and Loading Business Analytics Warehouse • Encapsulates warehouse load • logic • Handles: • – Slowly changing dimensions • – Key lookup resolution / surrogate key generation • – Insert/update strategies • – Currency conversion • – Data consolidation • Uses bulk loaders on all database platforms Load Source Independent Load Staging Tables Source Dependent Extract SQL SQL SQL Power Connect Power Connect Extract SQL ABAP Siebel OLTP Oracle Other App Layer App Layer PeopleSoft SAP

  14. Oracle Data Warehouse Administration Console

  15. About Apps Associates • In operation since 2002 with consistent year-over-year growth, privately held • 2011 Inc 500/5000 list of fastest growing U.S. companies • Offices in USA – MA (HQ), New York, Atlanta, Germany and India • Over 400 employees with strong local presence • Core Specializations: E-Business Suite, Oracle Business Intelligence, Microsoft Applications, Hyperion, Integration & Fusion Middleware, Infrastructure Services • Founded by former Oracle Consulting Service employees

  16. Service Offering (All) • E-Business Suite Consulting • Release 12 Upgrades and Implementation • EBS Managed Services • Remote DBA Service • Business Intelligence/EPM* • OBI-EE, BI Applications • Hyperion • Oracle Data Integrator (ODI) • BI Publisher • *BI Pillar Partner • Fusion Middleware • SOA, Process Management • Web Services • E-Business Suite Integrated Product** • ShipConsole • **Product is Oracle Validated • Technical Services • Remote DBA Services • Microsoft Development & Support Contact Information: Pavan Kanugo:(M) +91 770 265 5583 Practice Director Pavan.Kanugo@AppsAssociates.com www.AppsAssociates.com Locations: Boston I New York I Germany I India

  17. BI Engagement Type Experience

  18. BI Solution Footprint Experience

  19. Questions?

More Related