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

The Bizagi ODS is a powerful option that 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 for 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, configure the connection to the ODS in Bizagi in the 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, select the Configuration tab and click the Environment button to start 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 sectionlets you to configure the connection to your replicated database for this environment.

 

3. Configure the ODS connection

Configuration varies according to the server and platform running your processes.

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

 

For SQL Server, input the connection details:

Server: The database instance where the ODS is at.

Database: The replicated database (ODS).

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

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

 

For Oracle, input the connection details:

Service: The connection string to the Oracle database instance. Use [databaseServer]:[port]/[serviceName] syntax:

Username: The user schema representing the replicated source.

Password: The password for the 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 other resources than those involved for the end users' daily activities.

 

 

ODS_Final

 

 

Additional options

In addition to the previous option, Bizagi encourages the use of a 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.