Configuring ODS for Process Analytics

<< Click to Display Table of Contents >>

Navigation:  Automation Server > Automation Server configuration and administration guide > Initial project configuration > Best practices in the production environment > Setting up a Bizagi ODS >

Configuring ODS for Process Analytics

Overview

Relying on the Bizagi ODS is a powerful option aimed especially at enhancing availability and performance of your transactional database.

Once you have set the database replica of your Bizagi database, proceed to configure the connection to such ODS in Bizagi.

This is done by using Bizagi Management Console for any environment (Test or Production).

 

For introductory information and to review prerequisites of this option, refer to Setting up a Bizagi ODS.

 

Defining ODS for Process Analytics

Once you have set the database replication configuration for the ODS, configuring the connection to this ODS in Bizagi is done by using Bizagi Management Console for any environment (Test or Production) as described below.

 

 

1. Open the Environment options.

To configure the ODS from the Management Console, go to the Configuration tab and click on the Environment button for the Environment configuration.

 

ODS02_MC_patch

 

This option is also available in Bizagi Studio for the Development environment:

 

ODS01_Environment

 

2. Locate the ODS Configuration.

Under the Advanced options, an Operational Data Store section will be shown to configure the connection to your replicated environment's database.

 

3. Configure the ODS connection.

Configuration at this point will vary according to the server and platform running your processes.

When running Automation Server in a .NET platform, first choose the Provider type and then fill out the details.

 

For SQL Server, input the connection detail taking into account:

Server: The database instance where the ODS is at.

Database: The replicated database (ODS).

Login name: The login account used for the connection to that database.

Password: The password for the login account used for the connection to that database.

 

For Oracle, input the connection detail taking into account:

Service: The connection string to the Oracle database instance. Should be inputted with the [databaseServer]:[port]/[serviceName] syntax:

Username: The user schema representing the replicated source.

Password: The password for that user schema.

 

ODS03_Oracle

 

Execution

Once this information is configured, Process Analytics queries executed in the Work Portal will be carried out against the ODS, and without using different resources than those involved for the end users' daily activities.

 

 

ODS_Final

 

 

Additional options

In addition to the previous option, Bizagi eagerly encourages the use of query engine to support your ODS as a best practice, boosting your BAM and Analytics modules even more.

To learn more about this possibility, refer to How to enable query engine ODS support.