Installing Process Analytics

As a system administrator, you want to install and use Process Analytics to analyze scheduled, running or processed tasks in your system.

Before installing Process Analytics, check the Automic Compatibility Matrix to make sure that your system meets the necessary requirements.

Note: To install Process Analytics Studio, follow steps 1 and 2, and then configure the Process Analytics Studio.

To Install Process Analytics

  1. Download the latest version of Process Analytics from https://downloads.automic.com/.

  2. Unpack the archive and copy the content to a separate folder.

    The "setup.exe" program in the directories IMAGE:\Process Analytics\ADMIN and IMAGE:\Process Analytics\STUDIO is also available for Windows.

  3. Download the suitable JDBC driver according to the version and type of your system's database.

    Important! Process Analytics supports DB2, Oracle and Microsoft MS SQL. It does not support PostgreSQL.

  4. Unpack the downloaded archive and copy the .jar files to the lib directory of Process Analytics Admin and Studio.

    Example:

    C:\AUTOMIC\ProcessAnalytics\admin\lib

    C:\AUTOMIC\ProcessAnalytics\studio\lib

  5. If necessary, add the downloaded .jar files (path and file name) to the parameter classpath of the Java call in the files studio.sh and admin.sh (UNIX) or studio.bat and admin.bat (Windows). These files are provided in the installation directories of Process Analytics Admin and Studio.

    Example:

    java -classpath ProcessAnalytics_admin.jar;lib\commons-logging-1.1.jar;lib\crypt.jar;lib\AE.jar;lib\ojdbc6.jar;lib\sqljdbc4.jar

  6. Create a new MS SQL Server or Oracle database. It is not recommended to use an existing database.

    If you use an MS SQL Server, also activate the TCP/IP log for the Database Server on which the database runs.

    1. Start the SQL Server Configuration Manager.
    2. Select "SQL Server Network Configuration" and the corresponding Database Server name.
    3. In the right area, call the TCP/IP context menu and click "Properties."
    4. Enter the correct port of your Database Server in "IP addresses" - "IP All." The default value is 1433.
    5. Activate the TCP/IP protocol via the context menu.
    6. In the section "SQL Server Services", restart the relevant SQL Server service.

  7. Create a new database user. This user should have the "db_owner" role for the Process Analytics database in the MS SQL Server.

    For Oracle, users require the privileges CREATE SESSION, CREATE TABLE, CREATE SEQUENCE for the Process Analytics database. The following sample SQL script creates the DB user "PA" with the required rights:

    CREATE USER PA IDENTIFIED BY pwd DEFAULT TABLESPACE CLEARVIEW_DATA;

    GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE TO PA;

    ALTER USER PA QUOTA UNLIMITED ON CLEARVIEW_DATA;

    ALTER USER PA QUOTA UNLIMITED ON CLEARVIEW_INDEX; 

  8. Create the database tables.

    The tables that are required for Process Analytics are created in the database. A detailed description of these tables is provided in the section ETL Process.

    • If you use an Oracle database, create the tablespaces Process Analytics_data and Process Analytics_index.

      Manually execute the supplied SQL script createCVStruture.sql on the Process Analytics database. It is provided in the dll directory of Process Analytics Admin. The folder's script that should be used depends on the Process Analytics database's type and version.

      • Microsoft SQL Server 2000:ddl/sql_8

      • Microsoft SQL Server 2005 or 2008: ddl/sql_9

      • Oracle: ddl/oracle

    • If you use an Oracle Server for the Process Analytics database, the tables are created in the particular user's default schema. The tables are created in the tablespace Process Analytics_data and all indexes in the tablespace Process Analytics_index.

  9. Configure Process Analytics Admin by adjusting the files that are stored in the "conf" folder located in the Process Analytics Admin directory.

  10. If necessary, adjust the Process Analytics call in the file admin.bat (Windows) or admin.sh (UNIX) by adding or removing start parameters. See: Process Analytics Admin Start Parameters.

  11. Configure Process Analytics Studio by adjusting the files studio.db.properties and uc4config.xml. They are stored in the "conf" folder in the program directory of Process Analytics Studio. See: Configuring Process Analytics Studio

    Program outputs are written to log files. You can also create trace files. The corresponding process is described in the chapter Log Configuration. See: Log Configuration.

  12. Start the loading process for Process Analytics Admin via the file admin.bat (Windows) or "admin.sh" (UNIX).

    All task information is read from the AE database, converted and written to the Process Analytics database.

    Note: This procedure is always required if new tasks are scheduled, activated and processed in AE, and should be analyzed using Process Analytics.

  13. Start Process Analytics Studio via the file PAStudio.exe (Windows) or "studio.sh" (UNIX). 

    Important! Java 1.7 is not supported for Process Analytics Studio! Use Java 1.6 to start PA Studio.

See also: