Transcription

Welcome to the “Gathering Intelligencefrom your Applications and Data: Thecase for Oracle BI ” eSeminarAgenda1. PTS Organization2. The case for Oracle BI by Matt Elumba3. Additional ResourcesMilan ThanawalaDirector, Server TechnologiesOrcl4isv [email protected]

PTS Organization Who Product Technical Services (PTS)Enable partners to rapidly, successfully, and efficiently adoptOracle server technologies What In-depth architectural/technology adoption discussionsMigration of DB, AppServer to OracleRAC Validation (onsite or in Oracle lab) Why A part of the Product Group in Server TechnologiesPTS provides a single technical POC for ISVsTechnical Services are free for qualified ISVsOrcl4isv [email protected]

Oracle Business IntelligenceEnterprise Edition PlatformOrcl4isv [email protected]

The Evolving Role of BIFrom:To:AnalystsPervasive useHistorical dataReal-time, predictive dataFragmented viewUnified, enterprise viewReporting resultsInsight-driven businessprocess optimizationAnalytic toolsUnified infrastructure &prebuilt analytic solutionsOrcl4isv [email protected]

Legacy Business IntelligenceDisparate Tools for a Separate FunctionsOLAP AnalysisOLTPApp DWQuery & ReportEnterpriseDWDepartmentData MartsPortal/ScorecardOLAP ional (SQL) SourcesOrcl4isv [email protected] Mining5OtherFile or XMLSources All RelevantEnterprise DataSources

Legacy Business IntelligenceDisparate Tools for a Separate FunctionsOLAP AnalysisQuery & ReportPortal/ScorecardData MiningConsumers ofAnalytic Insight Data Access andCalculation Limited OLTPApp DWEnterpriseDWDepartmentData MartsOLAP ional (SQL) SourcesOrcl4isv [email protected] or XMLSources All RelevantEnterprise DataSources

Oracle Business IntelligenceEnterprise -hocExplorationSense andRespondDisconnected Web Services& IntegrationAnalytics Single LogicalAnalytical Viewof all EnterpriseDataCommon Enterprise Information ModelUnified Business Intelligence InfrastructureOLTPApp DWEnterpriseDWRelational (SQL) SourcesOrcl4isv [email protected] MartsXMLAOLAP AWMultiMulti-dimensionalSources7Consumers ofAnalytic Insight DataIntegratedAccess andInformationCalculationAccess, Analysis and DeliveryLimitedConsumerOptionsAudienceOtherFile or XMLSources All RelevantEnterprise DataSources

Oracle BI Server Simplified Business Model View Enhanced Open Intelligence Interface for increasedinteroperability Advanced Calculation & Integration Engine Expanded calculation and analytic functions Enhanced multi-dimensional DB support Intelligent Request Generation andOptimized Data Access Innovative distributed data access optimizations Expanded cache detection for rapid response Native RDBMS support for Oracle, MicrosoftSQL Server, IBM DB2 and Teradata Additional Native driver and platform-specific optimizations Mission Critical Performance and Scalability Expanded clustering and replication across all server tiers Across-the-board performance improvements – notably forhigh-end UNIX and SMP environmentsOrcl4isv [email protected]

End User ProductsEnterprise EditionOracleInteractiveDashboards Guided experience leads user from insight to action Intuitive and interactive dashboards/scorecards Personalized, function-specific and role-basedOracleAnswers Ad-hoc data exploration True business user self sufficiency Create, modify and author analysis, pivots anddashboardsOracleDelivers Dynamic problem/opportunity detection andnotification Automated analytic workflows and processes Tailored delivery for wide range of mobiledevicesOracleReporting &Publishing Schedule & distribute enterprise-class reports Sophisticate “pixel-perfect” report layoutcontrolsOrcl4isv [email protected]

Tailored and Personalized InteractionsTransparent Business IntelligenceOrcl4isv [email protected]

Guided AnalyticsLeading Users from Discovery to ActionThis is no longer about a stack of reports. Guided Analytics drives alignment andactions through the organization by modeling and making accessible discoveryand decision making best practices.Orcl4isv [email protected]

Sense and RespondReal-Time Proactive Monitoring and ResponseDelivers/Analytic Agents provides true real-time in context sense and respondcapabilities across systems tailored for any user on any device.Orcl4isv [email protected]

End UserDemonstrationOrcl4isv [email protected]

Oracle Disconnected AnalyticsFull-Featured Disconnected ClientThe user experience is identical to the connected user. Dashboard and Answersfunctionality will act identically as if the user were connected to the server.Oracle Disconnected BI ServerDisconnected Metadata & Report DefinitionsCalculation and IntegrationCachingWeb CatalogIntelligent Request GenerationOrcl4isv tedOracleDataOperational

Oracle Briefing Books“Pack & Go”Bring along an electronic “Briefing Book” which is a collection of your most importantdashboards. Briefing Books are extremely small, and can be delivered daily forenterprise collaboration.The bottom of every Dashboard pagehas an“Add to Briefing Book”Link that automatically builds anelectronic briefing book that you carrywith you.Orcl4isv [email protected]

Oracle Reporting and PublishingPrecision control over report format, layout, and output – enabling creationand distribution of “pixel-perfect” reports regardless of graphical complexity.ChecksOracle Reporting andPublishing leverages theCommon EnterpriseInformation Model for broaddestinations and formatsInvoicesLabelsDestinationsOrcl4isv [email protected] / EFT / EDI

ArchitectureOrcl4isv [email protected]

Oracle BI EE ArchitectureWeb Server(IIS, Tomcat, Websphere, iPlanet)Oracle BI WebOracle InteractiveDashboardsWebCatalogServiceAgent Execution LogicDevice Adaptive ContentOracle AnswersUser Profiling, Security and Session MngmtScheduling/Event ServicesTCP/IP(SSL)XML, HTML,XLS, PDF, TXToverHTTP/HTTPSTCP/IP (SSL)SOAP Web Services, XML and URL InterfaceOracle Delivers ServerWeb BrowserSAW Bridge (J2EE/ISAPI)XMLFrameworkODBC over TCP/IP (SSL)Session ManagementLogical Request GenerationQuery Govern.Security ServicesCacheServicesNavigatorMulti-Pass /Sub-Request LogicFragmentationOptimizationAggregateNavigatorDB AuthenticationCustom AuthenticatorOptimized Query RewritesExecution EngineData Source AdaptersODBC, CLI, OCI, XML, MDXOrcl4isv [email protected] and Operational Data Sources18System / Perf MonitoringLoad BalancerMetadata InterchangeLogical SQL ODBC/JDBC (Logical Business Model)Intelligent Request GenerationExternalizedAuthenticationLDAPExternal Applications and PortalsCache Services (Web) & Connection MngmtOracle BI ServerOracle BICluster ControllerHTML, SOAPoverHTTP/HTTPSJavascriptfor Usability & InteractivityOracle BIAdministrationMetadata Management ServicesMultiMulti-User Development ServicesMetadata Documentation ServicesServer Management Services

Oracle BI ServerCommon Enterprise Information ModelSimplified Logical ModelThe Oracle BI server presents as alogically modeled database enabling theCommon Enterprise Information Model.This provides powerful calculation,computation and federation capabilities to3rd party tools as well as our own.Orcl4isv [email protected]

Oracle BI ServerSystem ServicesSystem ServicesClustering:Add stacks as needed in a share nothingclustered environment.Session Management and Governance:Query throttling via connection pools andauthorizationSecurity Services:Integration with OID, LDAP withsophisticated data driven personalizationmechanisms.Orcl4isv [email protected]

A Day in the Life of a QueryOrcl4isv [email protected]

A Day in the Life of a QueryA logical request comes in asking for Orcl4isv [email protected],Closed Revenue (GL)Service Requests (Call Center)Share of Revenue (Derivation)

A Day in the Life of a QueryOracle BI Server CacheThe Server will check to see if this requestcan be fulfilled via a prior request usingServer Cache.This is an on-demand intelligent shareableand secure cache that can support:Subsets, Aggregations and DerivationsOrcl4isv [email protected]

A Day in the Life of a QueryNavigatorIf it is the request is cannot be fulfilled bycache then the server will intelligentlyprocess the requestOrcl4isv [email protected]

A Day in the Life of a QueryMulti-Pass/Sub-Request LogicDoes this analysis require sophisticatedanalysis such as an OLAP calculation?[Revenue Share]The Server will determine the bestpossible way to provide thiscalculation/computationOrcl4isv [email protected]

A Day in the Life of a QueryFragmentation OptimizationDoes this request span across partitionsor silos of data?[Closed Revenue and Service Requests]The server will determine based on therequest if it should navigate to both or onlyone. It will automatically resolve fan traps.Orcl4isv [email protected]

A Day in the Life of a QueryAggregate NavigatorIs there an aggregate that can bettersatisfy this request versus hitting thedetail?{Brand Summary Table}The Server will apply approprate summaryredirection to provide the quickestresponse.Orcl4isv [email protected]

A Day in the Life of a QueryOptimized Query RewritesWhat can be function-shipped down to thedatabase versus performed/supplemented by the computationcapabilities of the Server.The server will provide a consistent set offunctionality to the user regardless ofunderlying datasource.Orcl4isv [email protected]

Oracle BI ServerExploiting Native Database FunctionalityOrcl4isv [email protected]

Oracle BI ServerOptimized Native SQL Rewritesselect distinct D1.c2 as c1,Rank() OVER ( ORDER BY D1.c1 DESC ) as c2from(select sum(T677."ActlExtnd") as c1,T699."District" as c2from"d1 customer" T699,"d1 orders" T677where ( T677."repkey" T699."SalesRep" )group by T699."District") D1order by 1select D1.c2 as c1, D1.c1 as c4from(select sum(T1397."ActlExtnd") as c1,T1384."District" as c2from"D1 customer" T1384,"D1 orders" T1397where ( T1384."repkey" T1397."SalesRep" )group by T1384."District") D1[Rank Calculation Performed on Oracle BI ServerTo Compensate for the Limitations of MS SQL Server]Orcl4isv [email protected]

A Day in the Life of a QueryCache ServicesThe request once executed will now beavailable to other users as a cache entry.Orcl4isv [email protected]

Oracle BI EE ArchitectureWeb Server(IIS, Tomcat, Websphere, iPlanet)Oracle BI WebOracle InteractiveDashboardsWebCatalogServiceAgent Execution LogicDevice Adaptive ContentOracle AnswersUser Profiling, Security and Session MngmtScheduling/Event ServicesTCP/IP(SSL)XML, HTML,XLS, PDF, TXToverHTTP/HTTPSTCP/IP (SSL)SOAP Web Services, XML and URL InterfaceOracle Delivers ServerWeb BrowserSAW Bridge (J2EE/ISAPI)XMLFrameworkODBC over TCP/IP (SSL)Session ManagementLogical Request GenerationQuery GovernmentSecurity ServicesCacheServicesNavigatorMulti-Pass /Sub-Request LogicFragmentationOptimizationAggregateNavigatorDB AuthenticationCustom AuthenticatorOptimized Query RewritesExecution EngineData Source AdaptersODBC, CLI, OCI, XML, MDXOrcl4isv [email protected] and Operational Data Sources32System / Perf MonitoringLoad BalancerMetadata InterchangeLogical SQL ODBC/JDBC (Logical Business Model)Intelligent Request GenerationExternalizedAuthenticationLDAPExternal Applications and PortalsCache Services (Web) & Connection MngmtOracle BI ServerOracle BICluster ControllerHTML, SOAPoverHTTP/HTTPSJavascriptfor Usability & InteractivityOracle BIAdministrationMetadata Management ServicesMultiMulti-User Development ServicesMetadata Documentation ServicesServer Management Services

Metadata AdministrationDemonstrationOrcl4isv [email protected]

Enterprise Business Model Definition – Physical Layer:Efficient Access to Enterprise Data e Fin.Physical Layer – “IntelligentRequest Generation”XML DataSourceSQL ServerAcxiomReads in system catalog Multiple sourcesOracleOperational Optimized SQL generation Regardless of Schema Function ship to appropriate datasources/CompensationOrcl4isv [email protected]

Enterprise Business Model Definition – Logical Model:Logical View Provides Simple, Consolidated AccessBusiness Model Layer– “Calculation Engine”Physical complexityabstracted into logicalsubject areasDrill-PathsComplex/Derived Measures(Level-based, time series,dimension-specific, nested)Aggregate/Fragment AwareOrcl4isv [email protected]

Enterprise Business Model Definition – Presentation:All Data Access is Role-based and SecurePresentation Layer Role-based, in context, personalizedpresentation – Oracle AnswersOrcl4isv [email protected]

High Availability DeploymentThe addition of the OAW Replication Agent further enables mission criticaldeployments by enabling web clustering along with our Oracle BI Server Clustering.WebServerStack heduler ProcessOracleAnalytics WebLoadBalancerOracle BIServerApplicationDWStack rOracleAnalytics WebOAW rationToolLDAPServerOrcl4isv [email protected]/DWOracle BIServer37DBServerInformaticaServer

Oracle BI ServerParallel Multi-User DevelopmentMain RepositoryLocal Sandbox12 ConfigureCheck OutProject 5Project 53MergeProject 1Project 2Project 3Project 4Project 5Supporting Multi-User Development Multiple developers work cooperatively as ateam Developers check-out projects and placeonto local sandbox environments forconfiguration When done, the administrator merges thechanges into the main repository via the 3way merge facilityOrcl4isv [email protected] 6Project 7Project 8Project 9

Product StrategyKey Differentiators Enterprise Semantic Model Model Centric vs. Report Centric Analytics Pervasive Business Insight Empower Business Users with Embedded Insight Real Time Predictive Insight Activity Monitoring and Predictive Analytics Insight Driven Actions Contextual Visualization with Guided Decisions Business Process Optimization Sense & Respond with Intelligent Business Processes Fastest Time to Value Pre-Packaged Analytic ApplicationsOrcl4isv [email protected]

Next Steps Become Oracle Partner Network Member http://oraclepartnernetwork.oracle.com Check out Technical Resources on OTN .html l For technology adoption, migration assistance: Orcl4isv [email protected] [email protected]

QUESTIONSANSWERSOrcl4isv [email protected]