What Are the System Administration Tools?

There are several tools that you can use to manage the system.

This section describes system administration tools that are available to help you to manage the system. The table outlines the tools and their purpose.

Tool Purpose More Information

Oracle Analytics Server Console

Manage configuration and administration of system settings, user accounts and permissions, information back up, safe domains, virus scanner, email server, deliveries, and more.

About the Oracle Analytics Server Console

Classic Administration

Most options on the Classic Administration page are exposed through the Console. Only use the Classic Administration page if you're familiar with on-premises products that use a similar page.

About the Classic Administration Page

Fusion Middleware Control

Monitor, manage, and configure system components.

Fusion Middleware Control

Oracle WebLogic Server Administration Console

Monitor and manage JEE Java components.

Oracle WebLogic Server Administration Console

Process control command line tool

Manage system components (for advanced users).

Process Control Commands

Scripts

Administer the system.

Scripts

Model Administration Tool

Manage the semantic model.

Model Administration Tool

Catalog Manager Command Line Interface

Manage the Presentation Catalog.

Catalog Manager Command Line Interface

Job Manager Command Line Interface

Manage the Oracle BI Scheduler

Job Manager Command Line Interface

About the Oracle Analytics Server Console

Use the Oracle Analytics Server Console unless you're specifically directed to do otherwise. Most administration options are exposed through the Console, so Oracle recommends that you configure your instance using the Console.

On the Home page click the Navigator and select Console.

Task More Information

Maps

You can add custom map layers, make maps and map backgrounds available to users. See Apply Map Backgrounds and Map Layers to Enhance Visualizations in Visualizing Data in Oracle Analytics Server.

Extensions

You can view and upload extensions from local folders.

Search Index

You can configure search indexing, semantic model crawls, Catalog crawls, and monitor crawl job status. See Manage How Content Is Indexed and Searched.

Users, Roles, and Application Roles

You can manage users, roles, and application roles. See Manage Application Roles in Managing Security for Oracle Analytics Server.

Snapshots

You can work with snapshots. See Take Snapshots and Restore.

Connections

Not supported.

Virus Scanner

You can configure a virus scanner for when you upload files. See Configure a Virus Scanner.

Session and Query Cache

You can manage sessions for your service instance and set the log level for this tenant. See Monitor Users and Activity Logs.

Issue SQL

You can enter a SQL statement to issue directly against the Oracle Analytics Server. See Run Test SQL Queries.

Monitor Deliveries

You can monitor, schedule and edit deliveries. See Send Email Reports and Track Deliveries in Visualizing Data in Oracle Analytics Server.

Mail Server

Not supported.

System Settings

You can configure a range of system settings using the available options. See About Advanced Configuration Options.

Remote Data Connectivity

You can enable connections to use either Data Gateway or Remote Data Connector.

About the Classic Administration Page

Only use the Classic Administration page if you're familiar with on-premises products that use a similar page. Most options on the Classic Administration page are exposed through the Console, so Oracle recommends that you configure your service using the Console.

Task More Information

Manage Privileges

Oracle recommends that you keep the default privileges because they’re optimized for Oracle Analytics. Editing privileges might result in unexpected behavior or access to features.

Manage Sessions

See which users are signed in and troubleshoot report queries. See Monitor Users and Activity Logs.

Manage Agent Sessions

Currently not available in Oracle Analytics Server.

Manage Device Types

Add devices that can deliver content for your organization. See Manage the Types of Devices that Deliver Content

Toggle Maintenance Mode

Indicates whether Maintenance Mode is on or off. In Maintenance Mode, you make the catalog read-only so that other users can't modify its content. Users can still view objects in the catalog, but they can't update them. Some features, such as the "most recently used" list aren't available.

Reload Files and Metadata

Use this link to reload XML message files, refresh metadata, and clear caches. You might want to do this after uploading new data, for example if you add or update a data model.

Reload Log Configuration

Oracle recommends that you keep the default log level. Oracle Support might suggest you change the log level to help troubleshoot an issue.

Export Fallback Font

Oracle recommends that you configure Go Noto font as the fallback font in Classic reports and dashboards. Used when the default PDF fonts (such as Helvetica, Times-Roman, and Courier) can’t display non-Western characters included in the data when generating PDF output. See Open-Source Fonts to Replace Licensed Monotype Fonts.

Issue SQL

Test and debug SQL queries. See Run Test SQL Queries.

Scan and Update Catalog Objects That Require Updates

Use this link to scan the catalog and update any objects that were saved with earlier updates of Oracle Analytics.

Manage Themes

Change the default logo, colors, and heading styles for reporting pages, dashboards, and analyses. See Manage Themes.

Manage Captions

Localize the names (captions) of reporting objects that users create. See Localize Your Captions.

Manage Map Data

Define how users display their data on maps. See Manage Map Information For Analyses.

Manage Publisher

Set up data sources for pixel-perfect reports and delivery destinations. Configure the scheduler, font mappings, and many other runtime options. See Introduction to Publisher Administration.

Configure Crawl

This option is available through the Console. See Schedule Regular Content Crawls of Catalog Objects and Schedule Regular Content Crawls of Semantic Model Content.

Monitor Crawl

This option is available through the Console. See Monitor Search Crawl Jobs.

Fusion Middleware Control

Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring system components.

Fusion Middleware Control is used principally for managing the system components of a BI domain and provides support for the following:

  • Starting, stopping, and restarting system components.

  • Configuring preferences and defaults.

  • Viewing status of scaled out components.

  • Managing performance and monitoring system metrics.

  • Performing diagnostics and logging.

Fusion Middleware Control also provides access to Oracle WebLogic Server Administration Console, where you monitor and manage Java components.

Fusion Middleware Control is available only if the Administration Server is running, as described in Conditions to Start the System.

See Use Tools to Manage and Configure the System.

Oracle WebLogic Server Administration Console

Oracle WebLogic Server is a Java EE application server that supports the deployment of Java components in a robust, secure, highly available, and scalable environment.

See Use Tools to Manage and Configure the System.

Oracle WebLogic Server Administration Console enables you to monitor and manage a WebLogic Server domain. Its capabilities include the following:

  • Monitoring the health and performance of JEE servers.

  • Configuring WebLogic server domains.

  • Stopping and starting JEE servers.

  • Viewing JEE server logs.

  • Managing user populations in the LDAP Server of the Oracle WebLogic Server.

See the Oracle Technology Network: http://www.oracle.com/technetwork/index.html

Process Control Commands

Process control commands enable you to manage Oracle Analytics Server system components, support both local and distributed process management, and the communication of process state (up, down, starting, and stopping).

Note:

You also use Fusion Middleware Control user interface to start, stop, and view status of system components.

Process control commands provide the following functionality to manage the Oracle Analytics Server system components:

Scripts

Scripts are for advanced administrator use and enable you to programmatically administer Oracle Analytics Server.

The scripting environment is based on the Java scripting interpreter Jython. You use batch scripts that are supplied in a file (scripts invoke a sequence of commands without requiring your input), or embedded in Java code. See About the Scripts for Managing Service Instances. You can extend the scripting language by following the Jython language syntax. See WebLogic Server WLST Online and Offline Command Reference in WLST Command Reference for Oracle WebLogic Server.

Model Administration Tool

The Model Administration Tool is a Windows application that enables you to manage the semantic model.

To obtain Model Administration Tool, install Developer Client Tool onto a Windows machine in your environment. See Download, Install, and Start the Client Tools for Oracle Analytics Server.

See Before You Begin in Metadata Repository Builder's Guide for Oracle Analytics Server.

Catalog Manager Command Line Interface

The Catalog Manager Command Line Interface is a tool that's the interface with the Presentation Catalog.

To obtain the Catalog Manager Command Line Interface, install the Client Tools onto a machine in your environment. See Download, Install, and Start the Client Tools for Oracle Analytics Server.

You use the Catalog Manager Command Line Interface to manage Presentation Catalogs. See Configure and Manage the Presentation Catalog.

Job Manager Command Line Interface

The Job Manager Command Line Interface is a tool that is the interface with the Oracle BI Scheduler.

The Job Manager Command Line Interface is installed locally when you install Oracle Analytics Server.

Using the Job Manager Command Line Interface, you can connect to, start and stop the Oracle BI Scheduler, add and manage jobs, and manage job instances. See Perform Advanced Job Management Tasks.