---
sourceDocument: Yokohama IT Operations Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/it-operations-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Oracle Analytics Server

# Oracle Analytics Server pattern-based discovery {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 8, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) 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 in ServiceNow identifies key components of Oracle Analytics Server (formerly Oracle Business Intelligence Enterprise Edition) running on Windows and Linux servers.
This discovery supports maintaining an accurate Configuration Management Database (CMDB) by detecting core Oracle BI components and their relationships within your IT environment.
To ensure effective discovery, updating the Discovery and Service Mapping Patterns application from the ServiceNow Store may be necessary.
Show full answer Show less  

## Prerequisites

* **Application Updates:** Confirm that Discovery and Service Mapping Patterns, Visibility Content, and CMDB CI Class Models applications are current.
* **Running Processes:** Verify that Oracle Analytics Server processes are active on target systems:
  * Windows: sawserver.exe, NQScheduler.exe, nqsserver.exe
  * Linux: sawserver, nqscheduler, nqsserver
* **File System Permissions:** Ensure discovery credentials have read access to Oracle BI installation directories, BIORACLEHOME environment variable location, and bifoundation/version.txt file.
* **Credentials Configuration:** Set up Windows credentials for Windows targets and SSH credentials for Linux targets within the ServiceNow AI Platform.
* **Discovery Execution:** Schedule a horizontal discovery to initiate data collection.

## Key Features

* **Core Components Discovered:**
  * **Oracle BI Server:** Processes queries and manages metadata.
  * **Oracle BI Presentation Service:** Provides the web-based user interface for visualizations and dashboards.
  * **Oracle BI Scheduler:** Manages scheduled report generation and distribution.
* **Data Captured in CMDB:** Each component is identified with details including name, version, and installation directory.
* **CI Relationships:** The discovery creates relationships indicating that these Oracle Analytics Server components run on Windows or Linux servers, helping map dependencies and system architecture.

## What to Expect

By implementing Oracle Analytics Server pattern-based discovery, ServiceNow customers can expect automated identification and accurate recording of Oracle Analytics Server components in their CMDB. This enhances visibility into the Oracle BI environment, supports impact analysis, and improves service mapping for better operational management. Proper setup and permissions ensure comprehensive discovery, enabling streamlined management of Oracle Analytics deployments within your IT 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 {#oracle-analytics-server-pattern__id_parent_topic}

Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).{#oracle-analytics-server-pattern__inline-send-to-store}
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
{#oracle-analytics-server-pattern__ul_hwg_mvy_whc}

## Prerequisites {#oracle-analytics-server-pattern__section_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
    {#oracle-analytics-server-pattern__ul_apps}

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`
      {#oracle-analytics-server-pattern__ul_pfp_ml5_xhc}
    * Linux:
      * `sawserver`
      * `nqscheduler`
      * `nqsserver`
      {#oracle-analytics-server-pattern__ul_dnw_nl5_xhc}

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
    {#oracle-analytics-server-pattern__ul_jkj_dxy_whc}

Create credentials on the ServiceNow AI Platform
:
    * Windows: Configure Windows credentials. For more information, see [Windows credentials](https://www.servicenow.com/docs/access?context=r_WindowsCredentialsForm&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US).
    * Linux: Configure SSH credentials. For more information, see [SSH credentials](https://www.servicenow.com/docs/access?context=r_SSHCredentialsForm&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US).
    {#oracle-analytics-server-pattern__ul_i1y_vwy_whc}

Schedule a horizontal discovery
:   For more information, see [Schedule a horizontal discovery](https://servicenow-prod.fluidtopics.net/CIQEq9XeYjrEAd3sKWHEVg "A discovery schedule determines what horizontal discovery searches for, when it runs, and which MID Servers are used. Create a discovery schedule for your local environment or a schedule for discovering the resources in your cloud service account.").

## Data collected by Discovery during horizontal discovery {#oracle-analytics-server-pattern__section_data_collected}

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

Resources discovered by the Oracle BI Server pattern
:
    {#oracle-analytics-server-pattern__table_bi_server__entry__2}

    | 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. |
    [Table 1. Oracle BI Server \[cmdb_ci_oracle_bi_server\]]

    {#oracle-analytics-server-pattern__table_bi_server}

Resources discovered by the Oracle BI Presentation Service pattern
:
    {#oracle-analytics-server-pattern__table_bi_presentation__entry__2}

    | 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. |
    [Table 2. Oracle BI Presentation Service \[cmdb_ci_oracle_bi_presentation_service\]]

    {#oracle-analytics-server-pattern__table_bi_presentation}

Resources discovered by the Oracle BI Scheduler pattern
:
    {#oracle-analytics-server-pattern__table_bi_scheduler__entry__2}

    | 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. |
    [Table 3. Oracle BI Scheduler \[cmdb_ci_oracle_bi_scheduler\]]

    {#oracle-analytics-server-pattern__table_bi_scheduler}

## CI relationships {#oracle-analytics-server-pattern__section_relationships}

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

Relationship created by the Oracle BI Server pattern
:
    {#oracle-analytics-server-pattern__table_relationships_bi_server__entry__3}

    | 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\] |
    [ ]

    {#oracle-analytics-server-pattern__table_relationships_bi_server}

Relationships created by the Oracle BI Presentation Service pattern
:
    {#oracle-analytics-server-pattern__table_relationships_bi_presentation__entry__3}

    | 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\] |
    [ ]

    {#oracle-analytics-server-pattern__table_relationships_bi_presentation}

Relationships created by the Oracle BI Scheduler pattern
:
    {#oracle-analytics-server-pattern__table_relationships_bi_scheduler__entry__3}

    | 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\] |
    [ ]

    {#oracle-analytics-server-pattern__table_relationships_bi_scheduler}