System Requirements

This chapter covers the following topics:

Client Requirements

The minimum requirements for client machines for all Demantra products is:

Demantra Local Application

The Demantra Local Application is run as a stand-alone desktop application with no web browser dependency. As such, the client requirements to run the Demantra Local Application are different than those of previous versions for the web-based worksheet plug-in and the Demantra Local Application web page.

The Demantra Local Application requires Java 8 Update 77 or above. Both 32-bit and 64-bit versions of Java are supported.

The Demantra Local Application supports the following operating systems:

Demantra Anywhere

Demantra Anywhere is a browser-based user interface that supports mobile platforms as well PCs and Apple computers.

Demantra Anywhere supports the following:

Operating System Chrome Firefox Internet Explorer / Microsoft Edge Safari
Android Supported* Not Supported N/A N/A
iOS Not Supported Not Supported N/A Supported
Mac OS X Supported Supported N/A Supported
Windows Supported Supported Supported** N/A

* - Support on the Android operating system is limited to Chrome for Android. The Native Android browser that shipped with version prior to 4.4.x is not supported.

** - Support for Internet Explorer and Microsoft Edge is limited to the most recent version plus one previous release. As of January 12th 2016, this means the most recent version of Microsoft Edge and IE11 only.

Compatibility Mode: For Internet Explorer and Microsoft Edge, only Native mode is supported. View Compatibility mode should be disabled.

JavaScript: JavaScript support must be enabled.

Doctype: Demantra Anywhere relies on css attribute selectors, some versions of IE support attribute selectors only if a !DOCTYPE is specified, therefore to use Demantra Anywhere on IE a doctype is required.

Support is provided by Oracle on all platforms that the browser vendor provides support for. For mobile device operating systems, Oracle provides support for the most recent browser delivered by the device operating system only.

Demantra Workflow Manager

The Demantra Workflow Manager is a feature of the Demantra Local Application and does not have any additional system requirements. You access the Workflow Manager from the Settings and Actions menu.

Demantra Administrative and Configuration Tools

All Demantra Administrative and Configuration Tools have migrated from 32-bit to 64-bit. This includes:

You must have a 64-bit Oracle Database client installed to run these.

If you have both a 32-bit and a 64-bit Oracle Database Client installed and if the ORACLE_HOME Environment Variable points to the 32-bit client, then you must do the following for the Oracle Demantra Administrative and Configuration Tools to use the 64-bit client:

Microsoft Windows 7, 8, and 10 and Windows Server 2012 are supported.

Known Apple Mac OS X Limitations

The Oracle Demantra administrative utilities (Business Modeler, Chaining Management, Member Management, Engine Administrator) are not supported on the Mac OS X operating system. These utilities are supported only on Windows platforms. This means the Demantra Silent Installer in the Demantra Local Application is not supported on the Mac operating system. See Oracle Demantra Administrative Utilities for details.

Only the web browsers listed in the table above are supported for Demanta Anywhere. Apple Mac support is limited to the Demantra Local Application and Demantra Anywhere. Database and application server software is not supported on Mac OS X. See Software Requirements for the Servers.

Additionally, ending a Demantra Anywhere session using the browser's X icon may cause unexpected errors, and it is therefore not recommended to end a session in this manner. Always click the Logout link to properly end a Demantra session.

Using Other Software

Oracle Demantra supports the Windows Terminal Services. It also supports Excel integration for XP, 2003, 2007 and 2010 for Dynamic Open Link (DOL). Open Office 3 is supported for export.

Note: Dynamic Open Link (DOL) is not yet certified on Microsoft Office for Mac. However, Demantra's 'Export to Excel' option generates XLS files that can be opened by most Mac-based applications that support this format.

Software Requirements for Servers

This section lists the software stacks that support the Oracle Demantra Web Platform Server, Administrative Utilities, and Analytical Engine. For the latest, most up-to-date information on supported platforms, refer to the Certifications section on My Oracle Support.

Oracle Demantra Web Platform Server

These are the stacks on which Oracle Demantra receives rigorous testing. Other variations are possible. In principle, Oracle supports any:

Refer to certification details for Oracle VM support for Oracle WebLogic and Oracle database).

Both the Analytical Engine and Trade Promotion Optimization engine are also certified on Oracle VM using any of the Demantra-certified Windows platforms and Linux.

VMWare is not officially supported. Please see My Oracle Support Note 249212.1 for Oracle's policy on VMWare image support.

Oracle Demantra supports the following software:

Entity Supported Product and Version
Application Server

  • Oracle WebLogic 11g (10.3.6 or higher) and 12c (12.1.1.0.0 or higher)

  • Tomcat 7 and 8.5

  • IBM WebSphere 8.5.5
Java

  • Java JDK 8 64-bit Update 77 or above on the Application Server

    Note: : 32-bit versions of Java are not supported.

  • JVM as included with application server installation

Note: Available Java heap memory must be at least 512 MB to create and run the JVM.
Database

  • Oracle 12c (12.1.0.1 +) - Enterprise Edition

Note: For details about required configuration steps, see Additional Steps for Configuring Oracle 12c.

  • Oracle 11gR2 (11.2.0.4 +) - Enterprise Edition

  • Oracle Real Application Clusters (RAC)

  • Oracle Connection Manager (CMAN)

  • Oracle Exadata platform

Note: If you are using Oracle JRockit, refer to My Oracle Support note 978098.1 for important configuration guidelines.

Note: The database health check procedures are supported on both the Standard Edition (SE) and Enterprise Edition (EE) of the Oracle database. However, the Enterprise Edition is required to leverage the online table reorganization functionality. Additionally, the Standard Edition does not include the database functions parallel query/DML or database partitioning. For details on how these functions can be used to improve database performance, see Database Health Check, Database Partitioning for the Analytical Engine, and the UseParallelDML procedures in the Oracle Demantra Implementation Guide.

Caution: There is a known issue when using parallel hints to improve Demantra performance on Oracle 11g version 11.2.0.1 and earlier. If your Oracle 11g version is earlier than 11.2.0.1, refer to My Oracle Support note 1249314.1 before installing Demantra.

Additional Steps for Configuring Oracle 12c Pluggable Databases

A Pluggable Database (PDB) is a new, optional multi-tenancy feature of Oracle 12c. This feature enables a single container database (CDB) to contain multiple pluggable databases. The Demantra Installer does not automatically create or configure a PDB, Demantra with Oracle 12c, a PDB must be defined before running the Oracle Demantra Installer to install a new or upgrade an existing installation. Note that PDB is not mandatory for using Oracle Demantra, and the following steps are only required if you are using a PDB. For information on how to create a PDB, see http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_6009.htm.

You must also create an entry in your TNSNAMES file and enter the PDB name as the SERVICE_NAME before running Oracle Demantra Installer.

For example, assume the PDB you want to use is called “PDBORCL”. In this case, create a new entry in your TNSNAMES file as follows:

pdborcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST10064.my-domain.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER=DEDICATED)
      (SERVICE_NAME = PDBORCL.MY-DOMAIN.COM)
    )
  )

Running the Oracle Demantra Installer

After creating the TNSNAMES entry as described above, run the Oracle Demantra Installer.

In the 'DBA Details' screen, specify the pluggable database you want to use in the 'TNS Name' field. Using the example above as a guideline, you would enter 'pdborcl' here.

In the 'Configure JDBC Connection' screen, specify the pluggable database you want to use. For the example above, you would enter:

For more information about the Oracle 12c Database, please refer to Oracle 12c documentation.

Oracle Database Servers

These are the Oracle Demantra components that the Oracle database supports:

These are the Oracle Demantra integrations that the Oracle database supports:

Note: Oracle does not support Microsoft SQL Server. To learn which Demantra versions support SQL Server, please review previous versions of the Installation Guide and Release Notes on My Oracle Support.

Oracle Demantra Analytical Engine

The Demantra Analytical Engine supports the following:

The following prerequisite for Demantra Analytical Engine deploying on UNIX-like OS:

For additional details, see Deploying Demantra on UNIX, Solaris or Linux, Oracle Demantra Installation Guide for 12.2.

For information on deploying the Demantra Analytical Engine on Linux, see Deploying the Demantra Analytical Engine on Linux.

Trade Promotion Optimization (TPO) Engine

The Demantra Trade Promotion Optimization (TPO) Engine has been tested and certified on the following:

Entity Supported Versions (32-bit or 64-bit)
Operating System

  • Windows versions 2008 and 2012

  • Oracle Enterprise Linux (OEL) versions 5 and 6

  • SUSE Linux version 10 (SP3)

  • Solaris (SPARC) versions 10 and 11

Note: TThe TPO engine supports version 12 of both the ILOG CPLEX and OPL libraries.
Application Server

  • Tomcat

  • WebLogic

  • IBM WebSphere

  • IBM WebSphere Express
Database TPO engine supports any of the databases listed in Oracle Demantra Web Platform Server.

* Both the 32-bit and 64-bit versions of the operating systems listed above are supported. However, please note that the TPO engine runs on a 64-bit application server. For more information, see 32-bit Oracle Client Requirements.

Note: If you are deploying the TPO engine on a platform other than Windows, see Configure Promotion Optimization (PMO) on a UNIX-like Operating System, Oracle Demantra Installation Guide for 12.2

Hardware Architecture

For solution architecture, the most important consideration is the size of the implementation:

For larger systems, consider running the database and application server on a UNIX platform such as Linux, Solaris, HPUX, or AIX and be sure to size the hardware accordingly. Demantra is a data process-intensive application and database clustering using Oracle database Real Application Clusters (RAC) is supported. The application server is not the load point in the Demantra application architecture, so J2EE clustering is not supported.

Note: RAC supports several methods of connection configurations, and not all forms are currently supported by the Demantra Web-based applications. (The analytical engine, Business Modeler, and Member Management/Chaining applications support all forms of RAC configuration through TNSname configuration.). The Demantra Web applications support only a single VIP host name configuration form. For more information see "Overview of Connecting to Oracle Database Using Services and VIP Addresses" in the Oracle® Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2).

Two-Tier and Multi-Tier Architectures

The architecture of Oracle Demantra implementations fall into two main categories:

Architectures Using the Distributed Engine

Commonly you use one machine as the server for the Analytical Engine, and you run one instance of the engine (single-instance mode). If your system includes the Distributed Engine, other variants are possible:

Hardware Requirements for the Servers

This section lists sample hardware requirements for the servers used in an Oracle Demantra installation, as well as for the Analytical Engine. These are basic guidelines; please contact your account representative or Oracle Support Services for detailed guidelines.

Requirements for Two-Tier Solution

For a two-tier solution, you must use the Windows stack or a variation, because Oracle Demantra Administrative Utilities (the Business Modeler and other desktop utilities) are supported only on Windows. You can run these administrative utilities using the Demantra Local Applicationon any Windows client. These are the minimum hardware requirements.

Entity Windows Stacks UNIX Stack
Processor Four Pentium 4 processors, 1 GHz Contact Oracle Support Services
Memory Dedicated server with 4 GB of memory At least 1 GB
Disk 80 GB disk space consisting of:

  • Minimum 8 disks at RAID level 5

  • 2 channel RAID controller

 6 GB disk space

General Comments Regarding Multi-Tier Solution

In a multi-tier solution, the servers and the Analytical Engine are potentially all on different machines. Note the following general comments:

Database Server

The table below shows the database server requirements.

Entity Windows Stacks UNIX Stack
Processor Four Pentium 4 processors (with extension ability to 8), 2.5 GHz Contact Oracle Support
Memory At least 16 GB At least 16 GB
Disk 160 GB disk space consisting of:

  • High-end storage system, for example SAN

  • Minimum 8 disks at RAID level 10

  • 2 channel RAID controller

 160 GB disk space consisting of:

  • High-end storage system (for example, SAN)

  • Minimum 8 disks at RAID level 10

  • 2 channel RAID controller

Application Server

The table below shows the application server requirements.

Entity Windows Stacks UNIX Stack
Processor Two Pentium 4 Xeon processors (with extension ability to four), 1 GHz Contact Oracle Support
Memory (depends on number of concurrent users) 3 GB 3 GB
Disk 20 GB disk space, configured RAID 1+0 20 GB disk space, configured RAID 1+0

Analytical Engine

The table below shows the Analytical Engine requirements.

Entity Windows Stacks Linux Stacks
Processor Pentium 4 processor, 1 GHz Contact Oracle Support
Memory (depends on number of concurrent users) At least 1 GB At least 1 GB
Disk 6 GB disk space 6 GB disk space

If your system includes the Distributed Engine, refer to Architectures Using the Distributed Engine.

Oracle Demantra Administrative Utilities

The table below shows the Oracle Demantra Administrative Utilities requirements.

Entity Windows Stacks
Processor Two Pentium 4 Xeon processors (with extension ability to four), 1 GHz
Memory 2 GB of memory (depends on number of concurrent users)
Disk 20 GB disk space, configured RAID 1+0

Network Requirements

For a Web-based solution, the WAN requirements vary by implementation; here are some guidelines:

Note: Oracle Demantra is SAN aware.