Oracle Analytics Server pattern-based discovery

  • Release version: Xanadu
  • Updated January 8, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Oracle Analytics Server Pattern-Based Discovery

    The Oracle Analytics Server pattern-based discovery feature identifies components of Oracle Analytics Server on Windows and Linux servers. This capability enhances your service mapping and discovery processes, ensuring comprehensive visibility of your business intelligence environment. To utilize these discovery patterns, ensure you are using the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

    Show full answer Show less

    Key Features

    • Core Component Discovery: The discovery patterns identify three main components of Oracle Analytics Server:
      • Oracle BI Server: The analytics engine that processes queries and manages metadata.
      • Oracle BI Presentation Service: The user interface that provides visualizations and dashboards.
      • Oracle BI Scheduler: Manages scheduled report generation and distribution.
    • Data Population: Discovered data is populated in the Configuration Management Database (CMDB), enhancing asset management.
    • CI Relationships: Relationships between discovered components and their respective servers are established to support integrated service mapping.

    Prerequisites

    Ensure the following before initiating discovery:

    • All relevant applications, including Discovery and Service Mapping Patterns, must be updated.
    • Verify that Oracle Analytics Server processes are running on target systems.
    • Confirm that credentials used for discovery have the necessary file system access permissions.
    • Configure Windows or SSH credentials as required for access.

    Key Outcomes

    By implementing Oracle Analytics Server pattern-based discovery, ServiceNow customers can expect:

    • Enhanced visibility and management of Oracle Analytics components within their infrastructure.
    • Accurate population of the CMDB with essential data about each component, including name, version, and installation directory.
    • Streamlined service mapping through established relationships between components and their servers, leading to improved operational efficiency.

    Discovery and Service Mapping Patterns finds Oracle Analytics Server (formerly Oracle Business Intelligence Enterprise Edition) components on Windows and Linux servers in your environment. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

    Request apps on the Store

    Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

    Oracle Analytics Server consists of integrated components that provide business intelligence capabilities. The Discovery patterns discover three core components:
    • Oracle BI Server: Core analytics engine that processes queries and manages metadata
    • Oracle BI Presentation Service: Web-based user interface component that delivers visualizations and dashboards
    • Oracle BI Scheduler: Component that manages scheduled report generation and distribution

    Prerequisites

    Verify that the applications are up to date
    Verify that the following applications are up to date:
    • Discovery and Service Mapping Patterns
    • Visibility Content
    • CMDB CI Class Models
    Verify that the Oracle Analytics Server processes are running on target systems
    Verify that the following Oracle Analytics Server processes are active on target systems:
    • Windows:
      • sawserver.exe
      • NQScheduler.exe
      • nqsserver.exe
    • Linux:
      • sawserver
      • nqscheduler
      • nqsserver
    Verify file system access permissions
    Verify that the credentials used for discovery have read access to the following locations:
    • Oracle BI installation directories
    • BI_ORACLE_HOME environment variable location
    • bifoundation/version.txt file within the Oracle BI installation
    Create credentials on the ServiceNow AI Platform
    Schedule a horizontal discovery
    For more information, see Schedule a horizontal discovery.

    Data collected by Discovery during horizontal discovery

    Discovery populates the data in the CMDB when running the Oracle Analytics Server patterns.

    Resources discovered by the Oracle BI Server pattern
    Table 1. Oracle BI Server [cmdb_ci_oracle_bi_server]
    Field Description
    Name [name] Name of the Oracle BI Server instance.
    Version [version] Version of the Oracle BI Server software.
    Installation directory [install_directory] File system path where the Oracle BI Server is installed.
    Resources discovered by the Oracle BI Presentation Service pattern
    Table 2. Oracle BI Presentation Service [cmdb_ci_oracle_bi_presentation_service]
    Field Description
    Name [name] Name of the Oracle BI Presentation Service instance.
    Version [version] Version of the Oracle BI Presentation Service software.
    Installation directory [install_directory] File system path where the Oracle BI Presentation Service is installed.
    Resources discovered by the Oracle BI Scheduler pattern
    Table 3. Oracle BI Scheduler [cmdb_ci_oracle_bi_scheduler]
    Field Description
    Name [name] Name of the Oracle BI Scheduler instance.
    Version [version] Version of the Oracle BI Scheduler software.
    Installation directory [install_directory] File system path where the Oracle BI Scheduler is installed.

    CI relationships

    The Oracle Analytics Server patterns create these relationships to support Oracle Analytics Server discovery.

    Relationship created by the Oracle BI Server pattern
    CI Relationship CI
    Oracle BI Server [cmdb_ci_oracle_bi_server] Runs on::Runs Windows Server [cmdb_ci_win_server] or Linux Server [cmdb_ci_linux_server]
    Relationships created by the Oracle BI Presentation Service pattern
    CI Relationship CI
    Oracle BI Presentation Service [cmdb_ci_oracle_bi_presentation_service] Runs on::Runs Windows Server [cmdb_ci_win_server] or Linux Server [cmdb_ci_linux_server]
    Relationships created by the Oracle BI Scheduler pattern
    CI Relationship CI
    Oracle BI Scheduler [cmdb_ci_oracle_bi_scheduler] Runs on::Runs Windows Server [cmdb_ci_win_server] or Linux Server [cmdb_ci_linux_server]