Installing Process Analytics

Use the following guide for your Process Analytics installation.

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

Transferring files

Download the latest version of Process Analytics from the Automic Download Center. 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.

Installing the JDBC Driver

Download the suitable JDBC driver. It depends on the version and type of your AE system's database (source database) and is available here:

Microsoft SQL Server:
http://msdn.microsoft.com/en-us/data/aa937724.aspx
Oracle
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
DB2 (only if DB2 is the source database)
http://www-01.ibm.com/support/docview.wss?uid=swg21363866

Unpack the downloaded archive and copy the .jar files to the lib directory of Process Analytics Admin and Studio.
Sample directory paths:
C:\AUTOMIC\Process Analytics\admin\lib
C:\AUTOMIC\Process Analytics\studio\lib

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.
Sample Java call:
java -classpath Process Analytics_admin.jar;lib\commons-logging-1.1.jar;lib\crypt.jar;lib\ae.jar;lib\ojdbc6.jar;lib\sqljdbc4.jar

Setting up the Database

Create a new MS SQL Server or Oracle database. You can also use an existing database but AE does not recommend this.

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

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

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;

Creating the Database Tables

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

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 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.

	5.	Configuring Process Analytics

You can configure Process Analytics Admin by adjusting the files that are stored in the "conf" folder. This folder is available in the program directory of Process Analytics Admin.
If necessary, adjust the Process Analytics call in the file admin.bat (Windows) or admin.sh (UNIX) by adding or removing start parameters.
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.
Program outputs are written to log files. You can also create trace files. The corresponding process is described in the chapter Log Configuration.

Starting Process Analytics Admin

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.

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

Starting Process Analytics Studio

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

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