<< Click to Display Table of Contents >> Navigation:  Bizagi Studio > Bizagi Studio installation > Bizagi Studio Server Installer > Bizagi Studio server system requirements > Database requisites > Oracle requisites

Overview

Bizagi Studio requires a database server for your processes repository.

Oracle database is supported for the database server configuration.

 

Supported versions and editions

The following are supported:

 

 

Supported for Standard and Enterprise editions. Express (XE) edition is not supported.

 

 

Required configuration

To use an Oracle instance to work with Bizagi, you require the following:

 

1. Create a specific user to be used by Bizagi.

You will need to create the user that Bizagi relies on, in your Oracle instance either through an option when creating a project through Bizagi, or by running a script.

This user is called the BizagiAdmon user.

 

2. Install the Oracle Data Provider where Bizagi Studio is.

Bizagi Studio (and further Bizagi components), rely on the Oracle Data Provider for .NET connector to access an Oracle database.

This is not needed at the Database Server but where Bizagi projects (or their components) run.

When a project is in its automation stages, this means that you will need to install the Oracle Data Provider for .NET connector wherever Bizagi Studio is installed, either if you have an Oracle database for your process repository, or if you are integrating an external Oracle data source in your Bizagi project (using Data Virtualization / Data Replication).

 

Verifying Oracle configuration

Carry out the steps described next, to make sure that your Oracle instance is set to work with Bizagi.

 

Which version do I have?

To determine your version of Oracle, connect to your database instance and run:

select * from v$version;

 

Checking the required configuration

Check or configure the following requirements.

 

1. Create a specific user to be used by Bizagi.

Bizagi relies on a Oracle user for administration and project tasks (i.e, to create the metadata structure of a Bizagi project, create backups, etc).

This user is called BizagiAdmon and it is a prerequisite to create a Bizagi project at an Oracle instance.

 

You may choose have Bizagi automatically create this user, or run a SQL script to create this user at the instance.

For quick start options, in which you want to have Bizagi automatically create the user, just make sure you specify the sys user (sysdba) credentials when creating your Bizagi project.

For information creating a Bizagi project, refer to Creating a project using Oracle.

 

To create the user by running a SQL script, follow these instructions:

 

1.1 Connect to your Oracle instance as the sys user (sysdba)

 

 

1.2 Edit the ConfigureInstanceForBizAgi-[Oracle_Version].sql script

Locate Bizagi Studio installation path and browse into the Project model's database folder (by default at C:\Program Files\BizAgi\ProjectModel\Database\).

For Oracle 11g R2, edit the script called ConfigureInstanceForBizAgi-11g.

 

 

To edit the script, make sure you remove the comment lines that define the following variables, and edit their values:

•BA_TABLES_DATAFILES_DIR: Should be replaced with the path where you want to create the tablespaces datafiles.

•BA_LOBS_DATAFILES_DIR: Should be replaced with the path where you want to create the datafiles holding Bizagi LOBS.

•BA_INDEXES_DATAFILES_DIR: Should be replaced with the path where you want to create the indexes datafiles.

•BA_BACKUP_PATH: Should be replaced with the path where you want to store automatic backups.

•BA_BIZAGIADMON_PASSWORD: Should be replaced with the password for the BizagiAdmon user.

 

 

1.3 Run the script.

Run the edited script and make sure it is a successful operation.

 

 

 

1.4 Configure the optimizer.

The following is applicable to Oracle versions 12 and it is a recommended guideline due to Oracle's report on BUG 21615091 (https://support.oracle.com/rs?type=bug&id=21615091).

Connect with an user with DBA rights (e.g, DBA, SYSTEM) and run the following script to configure the optimizer:

ALTER SYSTEM SET "_optimizer_reduce_groupby_key" = FALSE;

 

2. Install the Oracle Data Provider where Bizagi Studio is.

To install this connector's components, follow these instructions:

 

2.1 Choose the installers

The Oracle Data Provider for .NET is installed through the Oracle Data Access Components (ODAC).

Bizagi requires the ODAC 11g release which can be download directly from Oracle's website:

64-bit release (v11.2.0.3): https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html#license-lightbox

 

 

2.2 Install ODAC and its ODP.NET connector

Run the installer where you have Bizagi Studio installed.

Make sure you select the Oracle Data Access Components for Oracle Client option:

 

 

Then select the Oracle-Data-Provider for .NET component:

 

 

Click Install to complete the procedure.

Once finished, you will be notified by this window and you may close the installer.

Further information about the Oracle Data Provider for .NET, any requirements or its detailed instructions, are found at Oracle's website:

https://www.oracle.com/co/database/technologies/odac-downloads.html.

 

2.3 Repeat the installation at any other relevant machines

When setting up a collaborative teamwork environment, Bizagi Studio users would need to install this component in their workstations as well.

This component is needed if you are using the Data Virtualization or Data Replication features that integrate an Oracle database.