Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

Where are You Now? @Ftisiot

Slide 5

Slide 5 text

OAC 12C 11G 10G @Ftisiot

Slide 6

Slide 6 text

What is OAS @Ftisiot

Slide 7

Slide 7 text

Oracle Analytics Server Oracle Analytics Server Oracle Analytics Server @Ftisiot

Slide 8

Slide 8 text

Oracle Analytics Product FaMILY @Ftisiot

Slide 9

Slide 9 text

Oracle Analytics Cloud @Ftisiot

Slide 10

Slide 10 text

Functions OAC supports Every type of analytics Classic Modern @Ftisiot

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

Licensing All Included! @Ftisiot

Slide 16

Slide 16 text

Visualizations @Ftisiot

Slide 17

Slide 17 text

Data Flows @Ftisiot

Slide 18

Slide 18 text

Settings @Ftisiot

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

Explain @Ftisiot

Slide 21

Slide 21 text

Explain @Ftisiot

Slide 22

Slide 22 text

Machine Learning @Ftisiot

Slide 23

Slide 23 text

Compare - Classification @Ftisiot

Slide 24

Slide 24 text

Use On the Fly or within a Dataflow @Ftisiot

Slide 25

Slide 25 text

Why OAS @Ftisiot

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

Installation @Ftisiot

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

Upgrade @Ftisiot

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

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

Slide 37

Slide 37 text

In-Place Upgrade Backup Server Schemas @Ftisiot

Slide 38

Slide 38 text

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

Slide 39

Slide 39 text

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

Slide 40

Slide 40 text

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

Slide 41

Slide 41 text

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

Slide 42

Slide 42 text

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

Slide 43

Slide 43 text

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

Slide 44

Slide 44 text

Create Testing Suite @Ftisiot

Slide 45

Slide 45 text

Remove Unused Content @Ftisiot

Slide 46

Slide 46 text

User Tracking @Ftisiot

Slide 47

Slide 47 text

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

Slide 48

Slide 48 text

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

Slide 49

Slide 49 text

OAS Upgrade Jump-Start @Ftisiot

Slide 50

Slide 50 text

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