Process Analytics > Administration Guide > Configuration > Process Analytics Admin

Process Analytics Admin Configuration

The configurationA set of constituent components that make up a system. This includes information on how the components are connected including the settings applied. files are stored in the "conf" folder of the Process Analytics Admin program directory. Adjust them before you start Process Analytics Admin.

admin.db.properties

Parameters Description
cv_DatabaseType=

Database type of the Process Analytics databaseA database is an organized collection of data including relevant data structures.. This type can differ from the AE source database.

Allowed values:
"SqlServer2005" - Microsoft SQL Server 2005 or later (2008 uses the same setting)
"SqlServer2000" - Microsoft SQL Server  2000
"Oracle" - Oracle 10g or 11

cv_ServerName= Name of the computer on which the Process Analytics database runs. Only required if you use the MS SQL Server.
cv_ServerPort=

Port number of the Process Analytics database Server. Only required if you use the MS SQL Server.

Default value: 1433

cv_Schema= This parameter determines the Process Analytics database schema that should be used (optional).
cv_DatabaseName= Name of the Process Analytics database. Only required if you use the MS SQL Server.
cv_User= User of the Process Analytics database.
cv_Password=

Database passwordA secret combination of characters for a Automation Engine user.

You can either specify the password in encrypted or unencrypted (not recommended) form. Use the program UCYBCRYP which is supplied in the folder IMAGE:TOOLS\ENCRYPT in order to encrypt passwords. You can call the program as follows:

UCYBCRYP[.EXE] -p -n password

cv_InstanceName=

Name of a named MS SQL Server instance. The default instance is used if this field includes no value.

Note that dynamic ports are used by default if several instances are installed. In this cas, do not specify the Server port (parameter "ServerPort") of this instance (for example, cv_ServerPort= ). The port configuration is available in the SQL Server Configuration Manager (protocols for <instance name> -> TCP/OP -> Properties -> IP addresses).

cv_IntegratedSecurity=

Determines whether the integrated security for MS SQL Server should be used.

Allowed values: true, false (default value)

"true" - Windows authentication is used to log on to the database Server. In this case, the parameters cv_User and cv_password are ignored.
"false" - Login data (user and password) are retrieved from this configuration file.

cv_Url=

URL for the connection to the Oracle Server in the form "jdbc:oracle:thin:" and the name and port of the computer on which the database runs. Only required if you use Oracle as the Process Analytics database.

Example:
jdbc:oracle:thin:@hostname:1521/ORCL

uc4_DatabaseType=

Database type of the AE system's database (source database)

Allowed values:
"SqlServer2005" - Microsoft SQL Server 2005 or later (2008 uses the same setting)
"SqlServer2000" - Microsoft SQL Server  2000
"Oracle" - Oracle 10g or 11

uc4_ServerName= Name of the computer on which the AE source database runs. Only required if you use the MS SQL Server.
uc4_ServerPort=

Port number of the AE source database Server. Only required if you use the MS SQL Server.

Default value: 1433

uc4_Schema= This parameter determines the AE source database schema that should be used (optional).
uc4_DatabaseName= Name of the AE database. Only required if you use the MS SQL Server.
uc4_User= User of the AE database.
uc4_Password=

Database password

You can either specify the password in encrypted or unencrypted (not recommended) form. Use the program UCYBCRYP which is supplied in the folder IMAGE:TOOLS\ENCRYPT in order to encrypt passwords. You can call the program as follows:

UCYBCRYP[.EXE] -p -n password

uc4_InstanceName=

Name of a named MS SQL Server instance. The default instance is used if this field includes no value.

Note that dynamic ports are used by default if several instances are installed. In this cas, do not specify the Server port (parameter "ServerPort") of this instance (for example, uc4_ServerPort= ). The port configuration is available in the SQL Server Configuration Manager (protocols for <instance name> -> TCP/OP -> Properties -> IP addresses).

uc_IntegratedSecurity=

Determines whether the integrated security for MS SQL Server should be used.

Allowed values: true, false (default value)

"true" - Windows authentication is used to log on to the database Server. In this case, the parameters uc4_User and uc4_password are ignored.
"false" - Login data (user and password) are retrieved from this configuration file.

uc4_ClientId=

Number of the AE client whose data is used. This number refers to the specified AE source database.

You can also store the data of several clients in the Process Analytics database. Do so by changing the value in the database and calling the Process Analytics Admin again. Process Analytics Studio always represents the information of the client that has been specified at logon.

uc4_Url=

URL for the connection to the Oracle Server in the form "jdbc:oracle:thin:" and the name and port of the computer on which the database runs. Only required if you use Oracle as the AE database.

admin.loader.properties

You can adjust the loading behavior of Process Analytics Admin in order to optimally use your system resources. These options should only be used by experienced users. The loading performance is influenced by adjusting these parameters. The optimum values depend on the database and on the system configuration that is used.

Parameters Description
Timeout= Time in milli seconds after which the loading process ends if no new data can be read from the AE database or written to the Process Analytics database. All data that has been loaded during this process becomes invalid and is deleted when Process Analytics Admin starts the next time.
InsertsPerStatement=

This value determines the data records that are written to the database at the same time. Selecting a very small value has the effect that the total processing time increases. A high value can negatively affect the performance of your system.

Default value: 10

StatementsPerConnection=

Number of insert statements (see "InsertsPerStatement" above) that are written to the database per write operation. The same condition applies as described above.

Default value: 10

Threads=

Number of threads that run at the same time when data is loaded and written. Depending on the OS on which Process Analytics Admin runs, you can change this number.

Minimum: 6

QueueSize=

Maximum number of data records that is loaded from the AE database before it is converted and written to the Process Analytics database. A high value requires more memory but accelerates the laoding process.

Default value: 10.000

ReadPacketSize=

Number of lines (packet) that Process Analytics Admin reads from the AE database after a particular waiting period. This period is defined in the parameter ReadSleepTime=. See also: Loading Process in Packets

Default packet size: 25.000

ReadSleepTime=

Waiting time in milli seconds after a packet has been read. The packet size is determined in the parameter ReadPacketSize=. This pause is used in order to avoid negative effects on the AE system during the loading process. The loading process is described in Loading Process in Packets.

Default value: 5,000

The speed of the loading process is defined in the parameters "ReadSleepTime" and "ReadPacketSize". A higher speed also involves an increased workload on the AE database during the reading process. The following use cases are available:

The following illustration shows the behavior of both parameters (ReadPacketSize = n, ReadSleepTime = t).

Loading process in packets