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 in ServiceNow identifies and maps key Oracle Analytics Server components installed on Windows and Linux servers within your environment. This discovery supports Oracle Analytics Server (previously Oracle Business Intelligence Enterprise Edition) by detecting its core elements and populating configuration management database (CMDB) records accordingly. To ensure accurate detection, customers might need to update their Discovery and Service Mapping Patterns application from the ServiceNow Store.

    Show full answer Show less

    Prerequisites

    • Application Updates: Confirm that Discovery and Service Mapping Patterns, Visibility Content, CMDB, and CI Class Models applications are up to date.
    • Running Processes: Verify Oracle Analytics Server processes are active on target machines:
      • Windows: sawserver.exe, NQScheduler.exe, nqsserver.exe
      • Linux: sawserver, nqscheduler, nqsserver
    • File System Access: Ensure discovery credentials have read access to Oracle BI installation directories, the BIORACLEHOME environment variable location, and the bifoundation/version.txt file.
    • Credentials Setup: Configure appropriate credentials in ServiceNow AI Platform:
      • Windows: Use Windows credentials
      • Linux: Use SSH credentials
    • Discovery Execution: Schedule a horizontal discovery to initiate Oracle Analytics Server component detection.

    Key Features

    The discovery patterns identify three main Oracle Analytics Server components and populate their corresponding CI records in the CMDB:

    • Oracle BI Server: Core analytics engine managing queries and metadata.
    • Oracle BI Presentation Service: Web-based interface delivering dashboards and visualizations.
    • Oracle BI Scheduler: Manages scheduled reports and their distribution.

    For each discovered component, the following data is collected:

    • Name of the instance
    • Version of the software
    • Installation directory path

    CI Relationships

    The patterns establish relationships showing each Oracle Analytics Server component runs on either a Windows or Linux server, linking the CIs appropriately to the underlying operating system CIs:

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

    Practical Benefits

    By using these discovery patterns, ServiceNow customers can maintain an up-to-date CMDB reflecting the Oracle Analytics Server deployment accurately. This enables improved visibility into Oracle BI environments, supports impact analysis, and facilitates better operational management of business intelligence infrastructure.

    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
    • Windows: Configure Windows credentials. For more information, see .
    • Linux: Configure SSH credentials. For more information, see .
    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]