Utilizing Oracle Analytics Server with Enterprise Manager

February 3, 2023 | 9 minute read
Jerry Abramson
Consulting Member of Technical Staff
Text Size 100%:

Certification of Oracle Analytics Server 6.4.0 for use with Enterprise Manager

The Oracle Enterprise Manager organization is proud to present formal certification of Oracle Analytics Server, with Pixel-Perfect Reporting, version 6.4.0, for use with Enterprise Manager 13.4 and 13.5.

Since the Oracle Analytics Server 5.5.0 is outside of the extended support contracts available via general Oracle Analytics Server support channels, the Enterprise Manager organization has de-certified Oracle Analytics Server, version 5.5.0, for use with Enterprise Manager. The Enterprise Manager technical brief, specific to Oracle Analytics Server, version 5.5.0, is no longer supported nor available for download.

Background

Beginning with Oracle Enterprise Manager Cloud Control 13c Release 5 (13.5), embedded BI Publisher reporting functionality is no longer available from the Enterprise Manager console.

To use BI Publisher reporting functionality, Installation of a standalone instance of Oracle Analytics Server (OAS) is available.

  • Please note that Oracle Analytics Server is considered a major new release of what had been branded 'Oracle Business Intelligence Enterprise Edition (OBIEE)'
  • Additionally, BI Publisher, as part of OBIEE, has been renamed to 'Pixel-Perfect Reporting', and continues to be an integral component of Oracle Analytics Server.

Advantages of the standalone Oracle Analytics Server

By using a standalone OAS deployment for reporting, customers have the flexibility to manage the life cycle of any required reporting functionality independent of the Enterprise Manager installation, upgrade, and patch cycles.

Why Oracle Analytics Server with Enterprise Manager can be a powerful tool

To ensure a seamless transition to Enterprise Manager 13.5 for our customers, detailed technical briefs have been written to track major new releases of Oracle Analytics Server.

The first technical brief that was released was the brief specific to utilizing Oracle Analytics Server, version 5.5.0, with Enterprise Manager.

This technical brief has been rewritten and is replaced by the newly published version specific to Oracle Analytics Server, version 6.4.0. 

Additional technical briefs and tools for utilizing Oracle Analytics Server with Enterprise Manager will be made available throughout the year.

  • Oracle is committed to ensuring that the full capabilities of Oracle Analytics Server's Pixel Perfect Reporting continue to be available and fully supported throughout the support lifetime of Enterprise Manager 13.5.

Oracle Analytics Server with Enterprise Manager

These technical briefs have been developed, implemented, and tested by the same development teams that had implemented the embedded BI Publisher reporting capabilities in all prior Enterprise Manager releases.

The implications of this development model are far-reaching and significant.

  • The same rigor and diligence associated with prior code deliverables have been applied, in full, to the development of these technical briefs.
  • Years of development and testing have already been invested in these technical briefs.
  • Subsequent updates to these technical briefs, with the same diligence, will continue to track major releases of Oracle Analytics Server.
  • This blog, and all associated technical briefs, are meant to be utilized as a supplement to, and not a replacement for, the existing Fusion Middleware Documentation Book Sets specific to Oracle Analytics Server.

A best practice and planning for a fresh installation of Enterprise Manager 13.5

There are three steps to follow in order to plan for a fresh installation of Enterprise Manager 13.5.

  • Step A: Install and configure Enterprise Manager 13.5
  • Step B: Follow the detailed steps in this workbook
  • Step C: Update the standalone OAS installation for use with Enterprise Manager 13.5

A best practice for planning for an upgrade of Enterprise Manager from EM 13.4 to EM 13.5

  • Step A: Follow the detailed steps in this workbook before upgrading to EM 13.5.
  • Step B: Upgrade to Enterprise Manager 13.5
  • Step C: Update the standalone OAS installation for use with Enterprise Manager 13.5

Outline and organizational flow of the OAS 6.4 Technical Brief

Chapter 1 provides an overview of the Base Install and Configuration Of Oracle Analytics Server, version 6.4, for use with Enterprise Manager.

Chapter 2 provides an overview Of Post Install Steps For OAS, which includes configuration of appropriate OAS Security Model and associated Datasource(s).

Chapter 3 provides an overview of the OAS Security Models and their relationships to the corresponding Enterprise Manager Security Configuration.

Chapter 4 provides details on the two types of Enterprise Manager Security, which includes Repository-Based Authentication and LDAP-Based Authentication.

Chapter 5 provides an overview of the three required OAS Database connections. This includes the base schema required by the Oracle Analytics Server itself, the Enterprise Manager schema is utilized for all reporting data presented as the content of OAS Reports, and the same Enterprise Manager schema utilized when Enterprise Manager Repository based authentication is utilized.

Chapter 6 provides flow Charts for all of the procedures detailed in the remainder of the technical brief.

Chapter 7 provides a detailed overview of upgrading from Enterprise Manager 13.4.

Chapter 7
Figure 1:  Chapter 7 Upgrade Overview from EM 13.4

 

Chapter 8 provides the complete set of steps to install and configure Oracle Analytics Server, version 6.4, for use with Enterprise Manager.

Chapter 8
Figure 2:  Chapter 8 Steps to Install and configure OAS

 

Chapter 9 provides detail on the two security models utilized by Oracle Analytics Server, version 6.4.0, for use with Enterprise Manager.

Chapter 9
Figure 3: Chapter 9 Two Security Models Utilized by OAS

 

Chapter 10 provides the complete set of steps to configure Oracle Analytics Server, utilizing the "Database Security Model", for use with Enterprise Manager's Repository-based security.

Chapter 10
Figure 4:  Chapter 10 configuring OAS with the Database Security Model

 

Chapter 11 provides the complete set of steps to configure Oracle Analytics Server,  utilizing the "Fusion Middleware Security Model", for use with Enterprise Maanger's LDAP-based security.

Chapter 11
Figure 5:  Chapter 11 configuring OAS with Fusion Middleware

 

Chapter 12 provides the first set of steps when utiilizing Single-Sign On, layered on top of the steps in chapter 11. 

Chapter 13 provides the second set of steps when utilizing Single-Sign On, layered on top of the steps in chapter 11. 

Chapters 12 and 13
Figure 6:  Chapter 12 optional configuration

 

Chapter 14 provides the complete set of steps to configure the rquired Oracle Analytics Server Datasource(s). 

Chapter 14
Figure 7:  Chapter 14 configure required OAS datasources

 

Chapter 15 provides the preliminary steps prior to uploading the full set of Oracle provided out of box reports that are included with Enterprise Manager 13.5.

Chapter 15
Figure 8:  Chapter 15 Oracle provided out-of-the-box reports

 

Chapter 16 provides the required steps to migrate any customer-developed reports from the embedded BI Publisher to the standalone Oralce Analytics Server.

Chapter 16
Figure 9:  Chapter 16 migrate customer-developed reports from embedded BIP to standalone OAS

 

Chapter 17 provides the complete set of steps when upgrading from Enterprise Manager 13.4 to Enterprise Manager 13.5.

Chapter 17
Figure 10:  Chapter 17 upgrading to Enterprise Manager 13.5

 

Chapter 18 provides the steps to complete the upload of the fuĺl set of Enterprise Manager-provided reports to the standalone Oracle Analytics Server. This includes both the Enterprise Manager 13.5 Framework Reports and the Enterprise Manager 13.5 Plugin Reports.

Chapter 18
Figure 11:  Chapter 18 uploading Enterprise Manager reports

 

Chapter 19 provides the steps to migrate schedule data from the embedded BI Publisher in EM 13.4 to the standalone Oracle Analytics Server.

Chapter 19
Figure 12:  Chapter 19 migrate schedule data from EM 13.4

 

Chapter 20 provides the required step to remove the latent embedded BI Publisher artifacts as monitored Enterprise Manager targets.

Chapter 20
Figure 13:  Chapter 20 remove latent BI Publisher artifacts as monitored targets

 

Chapter 21 provides a full set of references to all related Oracle Documentation books that were used to develop this technical brief.

Appendix A through Appendix K review various procedures and technologies that are used throughout the technical brief.

In summary, Oracle Analytics Server can continue to be utilized with Enterprise Manager 13.5.  This is true both for existing reporting requirements, as well as new requirements.

As Oracle Analytics Server reporting capabilities continue to align with your enterprise requirements, review the technical brief, and check this page for additional tools and documentation.

Enterprise Manager's two Reporting Solutions

Information Publisher (IP) – Inbuilt reporting feature, with no additional lifecycle overhead.

  • IP Encompasses the ability to quickly develop browser pages that consist of tables, charts, and metrics.
  • These pages can be saved for later viewing, and delivery, via E-Mail.

Oracle Analytics Server (OAS) – A Full-featured reporting product with a lifecycle independent of Enterprise Manager releases.

  • OAS Encompasses a fully featured reporting platform with sophisticated presentation, report development, and customization capabilities.
  • Additionally, a large set of options for report scheduling and delivery options (E-Mail, ftp, etc).

 

To learn more about Enterprise Manager, and utilizing Oracle Analytics Server, visit:

 

 

Jerry Abramson

Consulting Member of Technical Staff


Previous Post

Security first with guided policy setup for OCI Database Management

Pratima Chennupati | 5 min read

Next Post


Oracle ranked leader for hybrid cloud and multicloud management

Moe Fardoost | 7 min read