Upgrade to OAS: Why and How?

Upgrade to Oracle Analytics Server

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
   ft@rittmanmead.com
   @FTisiot
   Oracle ACE Director
   Francesco Tisiot
   Analytics Tech Lead
   

   View Slide

3. Data Engineering Analytics Data Science
   www.rittmanmead.com
   info@rittmanmead.com
   @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