Deployment

Deploy Advanced Visualization for the First Time

APM delivers an installation package that includes files needed for a successful implementation of Advanced Visualization. The topics outline the steps that you must complete to deploy and configure this module for the first time. These instructions assume that you have completed the steps for deploying the basic APM system architecture. Ensure that you install Advanced Visualization on a different server from the one on which you have installed APM.

About This Task

These tasks may be completed by multiple people in your organization. We recommend, however, that the tasks be completed in the order in which they are listed.
TaskNotes
Open the required server ports.This step is required.
Review the Advanced Visualization system requirements.This step is required.
Review the database requirements.This step is required.
Run the Advanced Visualization Installer.This step is required.

Required Server Ports

To provide communication between Advanced Visualization and other systems, make sure the listed ports are open.

Table 1. Port Details
Port NumbersDescription
80, 8005, 8080, 8120, 9090Used by Advanced Visualization User Interface.
9006Used by Advanced Visualization User Interface. This port is required only if Advanced Visualization is installed on the same machine as APM.
6432Used by Advanced Visualization Hyperstage PostgreSQL database.

System Requirements

License Requirements

This feature is available with the core APM application; no specific license is required.

Hardware Requirements

The following hardware requirements outline the minimum hardware required for any computer that will be set up for Advanced Visualization. These minimum requirements may not be sufficient, depending upon how your system is configured and the anticipated user load the system must service.

Table 2. Hardware Requirements
ComponentMinimum Requirements
Core

4-core processor, 2.5 GHz minimum per core

8-core processors are recommended for optimal performance

RAM16 GB RAM or higher for optimal performance
Hard Drive40 GB of free disk space

Software Requirements

The following software is required on any machine that will be set up for Advanced Visualization.

Table 3. Server Details
Software Name and VersionWhere you can obtain it

Windows Server 2012 (64-bit) or

Windows Server 2016 (64-bit) or

Windows Server 2019 (64-bit)

Microsoft
Table 4. Browser Details
BrowserNotes

Google Chrome or

Mozilla Firefox or

Microsoft Edge

For recommended browser versions, refer to the https://kb.informationbuilders.com/topic/webfocus-8207-browser-information.

Database Requirements

You must create a database before installing Advanced Visualization. Advanced Visualization supports the following relational databases.
  • PostgreSQL
  • Microsoft SQL Server
  • Oracle
Table 5. Database Details
Database ProviderRequirements
Microsoft SQL Server
  • For the database, use SQL Server authentication instead of Windows authentication.
  • The user ID must have db_owner rights to the repository database.
  • Set the database collation to case sensitive. Case-insensitive collation is not supported.
  • For install, upgrade, and configuration tasks, grant db_datawriter, db_datareader, and db_ddladmin roles on the repository database and schema, to the account that is used by the Advanced Visualization install process to connect to the repository database and schema.
  • For run-time tasks, grant db_datawriter and db_datareader roles on the repository database and schema, to the account that is used by the Advanced Visualization to connect to the repository database and schema.
Oracle
  • User CHAR semantics when creating a database for use with Advanced Visualization.
  • Oracle database blocks (db_block_size) require 8K or higher.
  • Set the maximum number of open cursors (open_cursors) to 500 or higher when all tables are created and inserted.
  • Tablespace requirements depend on customer usage.
  • Advanced Visualization requires case-sensitive collation. By default, for Oracle, the string comparisons are case sensitive.
  • Use the NLS_COMP and NLS_SORT sort system parameters for comparison and sorting.
  • The RDBMS user account privileges that are used by Advanced Visualization must have the ability to create tables, modify tables, execute queries, and insert and delete records.

Advanced Visualization Installation Steps

Before You Begin

Before you can run the Advanced Visualization installer, you must:

  • Ensure that your system meets the system requirements.
  • Ensure that you install Advanced Visualization on a different server from the one on which you have installed APM.
  • Ensure that you have access to the Advanced Visualization installation package.
  • Ensure that you can access the APM Server host URL from the server where you plan to install Advanced Visualization.

About This Task

Procedure

  1. Log on as a user with administrative privileges to the server where you plan to install Advanced Visualization.
  2. Access the APM distribution package and then navigate to the folder Setup\Advanced Visualization.
  3. Run the file setup.exe.
    The APM Advanced Visualization page appears.

  4. Select Next.
    The License Agreement page appears.

  5. Read the license agreement, and if you agree to the terms, select I accept the terms of the license agreement, and then select Next.
    The Choose Destination Location page appears.
    Note:
    • By default, the Advanced Visualization software will be saved to C:\Meridium. If you want to change the location, select Change…, and then navigate to the location where you want to install the software.
    • Ensure that the installation path does not contain any space characters.


  6. Select Next.
    The APM Server URL page appears.

  7. In the APM URL box, enter the APM Server URL.
  8. Select Next.
    The Setup Type page appears.

  9. Select your database provider and select Next.
    The Database Server Login page appears.

  10. In the Login ID box, enter your database user ID.
  11. In the Password box, enter your database password.
    The database information page appears.
  12. Based on your database provider, enter the following credentials, and then select Next:
    • MS SQL
      • Host: Enter the MS SQL Server host name.
      • Port: Enter the MS SQL Server port number.
      • Name: Enter the name for your MS SQL Server database.
    • PostgreSQL
      • URL: Enter the Database Connection URL.
    • Oracle
      • Host: Enter the Oracle database host name.
      • Port: Enter the Oracle database port number.
      • SID: Enter the system identifier for your Oracle database instance.
  13. Select Next.
    The Ready to Install the Program page appears.

  14. Select Install.

Results

Advanced Visualization is successfully installed in your machine. To verify that the installation is successful, perform one of the following steps:
  • Log in to http://localhost:8080/ibi_apps with the credentials admin and secret.
  • Access Windows services to view the Advanced Visualization services.

What To Do Next

Perform the post-installation steps.

Advanced Visualization Post-Installation Steps

Before You Begin

Install Advanced Visualization.

Procedure

  1. On the machine on which you have installed APM, install IIS extensions. This step is required only if an error occurs when you try to access Advanced Visualization.
    1. Copy the files C:\Meridium\utils\install_iis_extensions.bat and C:\Meridium\utils\install_iis_extensions.ps1 from the Advanced Visualization machine to the APM host machine.
    2. Run the C:\Meridium\utils\install_iis_extensions.bat file as an administrator.
      The required extensions are installed.
  2. On the machine on which you have installed APM, set the reverse proxy.
    1. Copy the file C:\Meridium\utils\setReverseProxyCmd.bat from the Advanced Visualization machine to the APM host machine.
    2. Run Command Prompt as an administrator, and then run the following command:
      setReverseProxyCmd.bat http://<Advanced Visualization host URL>:<port number>
  3. If you have set up a load balancer for multiple APM nodes:
    1. Set the reverse proxy on all the APM machines by performing the previous step.
    2. Run the following command to set the APM host as the load balanced URL on the Advanced Visualization server:
      C:\Meridium\utils\setAPMHost.bat http://<APM host URL>

What To Do Next

Access the Advanced Visualization page.

Uninstall Advanced Visualization

This procedure uninstalls APM Advanced Visualization after the initial installation.

Procedure

  1. On the server machine where Advanced Visualization is installed, via the Control Panel, access the Programs and Features window.
  2. In the grid, select APM Advanced Visualization, and then select Uninstall. The Advanced Visualization installer appears, displaying the Preparing Setup screen, which contains a progress bar. After completion, a message appears, asking if you want to remove the selected application and all of its features.
  3. Select Yes.
    The Setup Status screen appears, displaying a progress bar. After the application and all of its features are removed, the Uninstall Complete screen appears.
  4. Select Finish.
    The APM Advanced Visualization installer closes.

Results

The APM Advanced Visualization is uninstalled from your machine.