April 2010 Oracle Spatial User Conference

Transcription

April 2010Oracle Spatial User Conference

April 2010Oracle SpatialUser ConferenceOracle SpatialUser ConferenceApril 29, 2010Hyatt Regency PhoenixPhoenix, Arizona USA

April 2010Oracle SpatialUser ConferenceDavid LappSpatial and BI SpecialistOracle Public SectorJayant SharmaTechnical DirectorOracle Spatial

April 2010Oracle SpatialUser ConferenceIntegration of OracleSpatial and MapViewerwith Oracle BusinessIntelligence

April 2010AgendaOracle SpatialUser Conference OBIEE-Spatial demonstration Technologies involved Pervasive OBIEE-Spatial integration ETL into data warehouseLogical Business ModelAd hoc analysisMap integration Methodology walkthrough Summary and Q&A

April 2010Oracle SpatialUser ConferenceDemo

April 2010Business Intelligence (BI)Oracle SpatialUser ConferenceSourceSystemsBI ServerInformation delivery

April 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition(OBIEE )

April 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition(OBIEE )

April 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition(OBIEE )

April 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition(OBIEE )

Location IntegrationsApril 2010Oracle SpatialUser Conference

Location IntegrationsApril 2010Oracle SpatialUser Conference

Location IntegrationsApril 2010Oracle SpatialUser Conference

Location IntegrationsApril 2010Oracle SpatialUser Conference

April 2010Oracle Location FeaturesOracle SpatialUser ConferenceCRM, ERP EnterpriseApplicationsOracle EBS, PSFT Dashboards, Portal, Integration PlatformMapViewerGeTe P osch ar pano tne tialo r lgiesGeosSe W parv eb tialicesFusion Middleware ServicesOracle core technologyOracle Application ServerSpatialLocatorOracle DatabaseOracle location technologyFusionMiddlewareDatabaseOracle location integration

Integration at All LevelsApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise EditionPRESENTATION LAYERLOGICAL LAYERDataPHYSICAL LAYER

Integration at All LevelsApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise EditionPRESENTATION LAYERLOGICAL LAYERDataPHYSICAL LAYER

Integration at All LevelsApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise EditionPRESENTATION LAYERLOGICAL LAYERDataPHYSICAL LAYER

Integration at All LevelsApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise EditionPRESENTATION LAYERLOGICAL LAYERDataPHYSICAL LAYER

Integration at All LevelsApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise EditionPRESENTATION LAYERLOGICAL LAYERDataPHYSICAL LAYER

April 2010Business RequirementOracle SpatialUser ConferenceStakeholders need project reports and analysesfrom their perspectiveProjectProject teEngineeringRegionGISProjectsmanymanyStakeholder geographies

Spatial SolutionApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition Presentation layerdelivery mechanismsLogical layerbusiness modelPhysical layersource mappingsOther SourcesData WarehouseBudgetPortioningScheduleProject factsSenate Congress AssemblyWork typeGeographyDataETLBudgetFinanceProject PortfolioManagementEngineeringGeodata

April 2010Oracle SpatialUser ConferenceDemo and Walkthrough

April 2010Business RequirementOracle SpatialUser ConferenceStakeholders require detailed and summarizedproximity of construction to conservation areasProximity will not be available in source data must be integrated with other data sources will be needed by many BI users

Spatial SolutionApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition Presentation layerLogical layerPhysical layerdelivery mechanismsbusiness modelsource mappingsDataBudgetFinanceProject PortfolioManagementEngineeringGeodata

April 2010Oracle SpatialUser ConferenceDemo & Walkthrough

April 2010Business RequirementOracle SpatialUser ConferenceAd hoc location analysis must be accessible bySQL savvy usersLocation analysis must be self service integrated with other OBIEE ad hoc analyses blend seamlessly into dashboards etc

Spatial SolutionApril 2010Oracle SpatialUser ConferenceOracle Business Intelligence Enterprise Edition Presentation layerLogical layerPhysical layerdelivery mechanismsbusiness modelsource mappingsDataBudgetFinanceProject PortfolioManagementEngineeringGeodata

April 2010Oracle SpatialUser ConferenceDemo & Walkthrough

April 2010Oracle SpatialBusiness RequirementUser ConferenceWe need interactive maps in our dashboards!!Users demand “Google-style” mapping “2-way” map integration seamless integration with BI analyses

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceOBIEEAnswers requestPresentation layerLogical layerPhysical layer

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardOBIEETableChartGaugeAnswers requestPresentation layerLogical layerPhysical layer

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardOBIEETableChartGaugeAnswers requestPresentation layerLogical layerPhysical layerStatic Text

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardOBIEETableChartGaugeAnswers requestPresentation layerLogical layerPhysical layerStatic TextBI sessionand auth IDsinvoke map

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardTableOBIEEChartGaugeStatic TextAnswers requestBI sessionand auth IDsPresentation layerinvoke mapLogical layerPhysical layermapping metadatageospatial dataOracle SpatialDatabase

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardTableOBIEEChartGaugeStatic TextAnswers requestBI sessionand auth IDsPresentation layerinvoke mapLogical layerPhysical layermapping metadatageospatial dataOracle SpatialDatabase

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardTableOBIEEChartGaugeStatic TextAnswers requestBI sessionand auth IDsPresentation layerLogical layerinvoke mapNSDPPhysical layermapping metadataOracle MapViewergeospatial dataOracle SpatialDatabase

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardTableOBIEEChartGaugeStatic TextAnswers requestMap tied toanalyticsBI sessionand auth IDsPresentation layerLogical layerinvoke mapNSDPPhysical layermapping metadataOracle MapViewergeospatial dataOracle SpatialDatabase

Basic MapViewer NSDP Join to Answers RequestApril 2010Oracle SpatialUser ConferenceDashboardTableOBIEEDrill downChartGaugeStatic TextAnswers requestMap tied toanalyticsBI sessionand auth IDsPresentation layerLogical layerinvoke mapNSDPPhysical layermapping metadataOracle MapViewergeospatial dataOracle SpatialDatabaseNavigateInvoke UCM,BPM

April 2010Oracle SpatialUser ConferenceDemo & Walkthrough

April 2010SummaryOracle SpatialUser Conference Spatial integration at every level of OBIEERepresentative of universal integration opportunitiesIntegration points driven by business needsEssential MapViewer integration will streamline in 11g

Pervasive OBIEE-Spatial integration ETL into data warehouse Logical Business Model Ad hoc analysis Map integration Methodology walkthrough Summary and Q&A. April 2010 Oracle Spatial User Conference Demo. April 2010 Oracle Spatial User Conference Business Intelligence (BI)