Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Upgrade to OAS: Why and How?

FTisiot
February 26, 2020

Upgrade to OAS: Why and How?

Upgrade to Oracle Analytics Server

FTisiot

February 26, 2020
Tweet

More Decks by FTisiot

Other Decks in Technology

Transcript

  1. Upgrade To OAS
    Why and How
    Francesco Tisiot
    Analytics Tech Lead - Rittman Mead
    @Ftisiot

    View Slide

  2. Verona, Italy
    http://ritt.md/ftisiot
    [email protected]
    @FTisiot
    Oracle ACE Director
    Francesco Tisiot
    Analytics Tech Lead

    View Slide

  3. Data Engineering Analytics Data Science
    www.rittmanmead.com
    [email protected]
    @rittmanmead

    View Slide

  4. Where are You Now? @Ftisiot

    View Slide

  5. OAC 12C 11G 10G
    @Ftisiot

    View Slide

  6. What is
    OAS
    @Ftisiot

    View Slide

  7. Oracle
    Analytics
    Server
    Oracle
    Analytics
    Server
    Oracle
    Analytics
    Server
    @Ftisiot

    View Slide

  8. Oracle Analytics Product FaMILY @Ftisiot

    View Slide

  9. Oracle Analytics Cloud @Ftisiot

    View Slide

  10. Functions
    OAC supports Every type of analytics
    Classic Modern
    @Ftisiot

    View Slide

  11. Classic Enterprise BI
    •Similar to OBIEE 12c
    •Centrally maintained & governed
    •Semantic model
    •Interactive Dashboards
    •KPI measurement & monitoring
    •Guided navigation paths
    •BI Publisher
    •Highly formatted, burst outputs
    •Action Framework
    •Navigation actions
    •Scheduled agents
    @Ftisiot

    View Slide

  12. Modern Data Discovery
    •Data Preparation
    •Acquire data
    •Clean/Enrich
    •Transform
    •Repeatable Flows
    •Data Visualisation
    •Create visual insights rapidly
    •Construct narrated storyboards
    •Share findings
    @Ftisiot

    View Slide

  13. Unique
    Source of
    Truth
    Raw Data To
    Insights
    Specific Access
    Control
    Data
    Enrichment
    and Cleaning
    Unified Analytics
    Free Discovery
    Centralised
    Reporting
    https://speakerdeck.com/ftisiot/become-an-equilibrista-find-the-right-balance-in-the-analytics-tech-ecosystem
    @Ftisiot

    View Slide

  14. What’s New in OAS?
    Licensing Visualization
    Data Flows Settings
    Augmented Analytics
    Machine Learning
    @Ftisiot

    View Slide

  15. Licensing
    All Included!
    @Ftisiot

    View Slide

  16. Visualizations @Ftisiot

    View Slide

  17. Data Flows @Ftisiot

    View Slide

  18. Settings @Ftisiot

    View Slide

  19. Augmented Analytics
    Data Enrichment
    Suggestions
    Explain
    One-Click
    Advanced
    Analytics
    Natural
    Language
    Processing
    @Ftisiot

    View Slide

  20. Explain @Ftisiot

    View Slide

  21. Explain @Ftisiot

    View Slide

  22. Machine Learning @Ftisiot

    View Slide

  23. Compare - Classification @Ftisiot

    View Slide

  24. Use On the Fly or within a Dataflow @Ftisiot

    View Slide

  25. Why OAS
    @Ftisiot

    View Slide

  26. 3 Stay in My Datacenter
    4 Full Control
    5 Customisations
    2 New Features
    1 Support
    @Ftisiot

    View Slide

  27. Limitations
    http://ritt.md/oas-limit
    Scorecard and Strategy Management
    Oracle Marketing Segmentation
    BI Scheduler Job Manager
    Act As
    Desupported and no longer available
    Deprecated
    Deprecated
    Deprecated
    BISQLGroupProvider Deprecated
    System Session Variables Deprecated
    STILL There!
    @Ftisiot

    View Slide

  28. Installation @Ftisiot

    View Slide

  29. OS
    Linux 6+
    DB
    Oracle 11.2+
    JDK
    1.8 8u211+
    Pre-Requisites @Ftisiot

    View Slide

  30. Folder Structure
    home
    oracle
    product
    oas55
    config
    domain
    bi
    ORACLE_HOME
    DOMAIN_HOME
    oas56
    @Ftisiot

    View Slide

  31. 1 Jdk
    Installation
    3 OAS
    4 Create RCU
    5 OAS Configuration
    2 Fusion Middleware
    http://ritt.md/oas-inst
    @Ftisiot

    View Slide

  32. Upgrade @Ftisiot

    View Slide

  33. Upgrade Path
    OAS
    OBIEE 12.2.1.4
    In-Place
    < OBIEE 12.2.1.4
    Out of Place
    @Ftisiot

    View Slide

  34. Upgrade Path - 12c
    OAS
    OBIEE
    12.2.1.4.0
    OBIEE
    12.2.1.2.0
    @Ftisiot

    View Slide

  35. Upgrade Path - 11g
    OAS
    OBIEE
    11.1.1.7
    OBIEE
    11.1.1.9+
    @Ftisiot

    View Slide

  36. Out of Place
    In - Place vs
    Keep Security Settings
    Keep Component Configurations
    Review and Redo Security Settings
    Redo Component Configurations
    Restart from Clean State
    Inherit old Installation
    Overwrite Existing Environment New Environment Built Alongside
    @Ftisiot

    View Slide

  37. In-Place Upgrade
    Backup
    Server Schemas
    @Ftisiot

    View Slide

  38. In-Place Upgrade
    1 Upgrade Schemas
    2 Backup mapViewerConfig.xml
    3 Backup Domain
    4 Reconfigure Domain
    5 Upgrade Domain Components
    6 Start Servers
    -readiness
    -readiness
    @Ftisiot

    View Slide

  39. In-Place - Post Upgrade Tasks
    1 Internal SSL
    2 Migrate Catalog Groups
    3 HTML Markup
    @Ftisiot

    View Slide

  40. Out-of-Place
    1 11.1.1.9
    2 Create 11g Export Bundle
    3 Import the Bundle in OAS
    @Ftisiot

    View Slide

  41. Out-of-Place - Post Upgrade Tasks
    1 Configurations
    2 Security
    3 Custom Images/Messages
    @Ftisiot

    View Slide

  42. OAS Known Bugs
    2644363.1
    2645310.1
    After Upgrade To Oracle Analytics Server (OAS), Modifying System Settings Fails With "Property Update
    Failed Due To Unauthorized Access"
    After Snapshot (BAR) Import In Oracle Analytics Server (OAS), Data Flows Fail With '400 - Bad
    Request ..' Error
    Thanks to Joel Acha - Elffar Analytics
    @Ftisiot

    View Slide

  43. Testing
    Automated Testing
    Oracle Baseline Validation Tool (Not Supported)
    Rittman Mead Regression Testing Tool
    @Ftisiot

    View Slide

  44. Create Testing Suite @Ftisiot

    View Slide

  45. Remove Unused Content @Ftisiot

    View Slide

  46. User Tracking @Ftisiot

    View Slide

  47. Get Ready for the Upgrade
    Content
    Server
    Starting Point
    Path
    @Ftisiot

    View Slide

  48. FREE
    OAS
    Assessment
    http://ritt.md/oas
    @Ftisiot

    View Slide

  49. OAS
    Upgrade
    Jump-Start
    @Ftisiot

    View Slide

  50. Upgrade To OAS
    Why and How
    Francesco Tisiot
    Analytics Tech Lead - Rittman Mead
    @Ftisiot

    View Slide