Oracle Analytics Server pattern-based discovery

  • Release version: Zurich
  • 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 identifies key Oracle Analytics Server components on Windows and Linux servers within your environment. This discovery supports maintaining an accurate Configuration Management Database (CMDB) by detecting core Oracle BI components and their relationships. To ensure successful discovery, the Discovery and Service Mapping Patterns application and related ServiceNow applications must be up to date.

    Show full answer Show less

    Prerequisites

    • Verify that Discovery and Service Mapping Patterns, Visibility Content, CMDB, and CI Class Models applications are current.
    • Confirm Oracle Analytics Server processes are active on target machines:
      • Windows: sawserver.exe, NQScheduler.exe, nqsserver.exe
      • Linux: sawserver, nqscheduler, nqsserver
    • Ensure discovery credentials have read access to Oracle BI installation directories, including the environment variable location and bifoundation/version.txt file.
    • Create appropriate credentials on the ServiceNow AI Platform:
      • Windows: Configure Windows credentials
      • Linux: Configure SSH credentials

    Discovery Process

    Run a horizontal discovery to collect data about Oracle Analytics Server components. The discovery populates the CMDB with details and relationships for these components.

    Key Features

    • Oracle BI Server: Discovers instances of the core analytics engine, capturing name, version, and installation directory.
    • Oracle BI Presentation Service: Detects the web-based user interface service, including name, version, and installation path.
    • Oracle BI Scheduler: Identifies the scheduling component responsible for report generation, with similar attributes recorded.

    Configuration Items (CIs) and Relationships

    Each discovered component is recorded as a CI in the CMDB with the following relationships:

    • Oracle BI Server runs on either Windows Server or Linux Server.
    • Oracle BI Presentation Service runs on either Windows Server or Linux Server.
    • Oracle BI Scheduler runs on either Windows Server or Linux Server.

    These relationships help map the deployment architecture and dependencies of Oracle Analytics Server components within your environment.

    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]