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

    Oracle Analytics Server pattern-based discovery identifies and maps Oracle Analytics Server components—formerly known as Oracle Business Intelligence Enterprise Edition—on Windows and Linux servers within your environment. It leverages Discovery and Service Mapping Patterns to detect core integrated components that provide business intelligence capabilities, helping you maintain accurate and up-to-date Configuration Management Database (CMDB) records.

    Show full answer Show less

    Key Features

    • Core Component Discovery: Detects three main Oracle Analytics Server components:
      • Oracle BI Server: The core analytics engine handling queries and metadata management.
      • Oracle BI Presentation Service: The web-based interface delivering dashboards and visualizations.
      • Oracle BI Scheduler: Manages scheduled report generation and distribution.
    • Cross-Platform Support: Works on both Windows and Linux servers, identifying the relevant processes such as sawserver.exe, NQScheduler.exe, and nqsserver.exe on Windows, and their Linux equivalents.
    • CMDB Population: Automatically populates CMDB tables with details such as instance name, software version, and installation directory for each discovered component.
    • Relationship Mapping: Establishes relationships in the CMDB showing that each Oracle Analytics Server component runs on a specific Windows or Linux server.

    Prerequisites and Setup

    • Ensure Discovery and Service Mapping Patterns, Visibility Content, CMDB, and CI Class Models applications are up to date.
    • Verify Oracle Analytics Server processes are running on target systems.
    • Confirm that discovery credentials have read access to Oracle BI installation directories, the BIORACLEHOME environment variable, and the bifoundation/version.txt file.
    • Configure appropriate credentials on the ServiceNow AI Platform:
      • Windows: Configure Windows credentials.
      • Linux: Configure SSH credentials.
    • Schedule a horizontal discovery to initiate the component detection process.

    Practical Outcomes for ServiceNow Customers

    • You gain accurate visibility into Oracle Analytics Server components and their deployment details, supporting improved IT asset management and operational insights.
    • The discovery patterns automate CMDB updates, reducing manual effort and increasing data reliability for incident, problem, and change management processes.
    • By mapping component-to-server relationships, you can better understand infrastructure dependencies and support impact analysis.
    • Keeping discovery applications updated ensures compatibility with the latest Oracle Analytics Server versions and enhances discovery accuracy.

    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]