Oracle requisites

<< Click to Display Table of Contents >>

Navigation:  Bizagi Studio > Bizagi Studio 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:

 

VERSION

VERSION NUMBER

Oracle 12c

12.1.0.2 or above

Oracle 11g R2

11.2.0.3 or above

 

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

 

note_pin

Supported character sets for Oracle databases are both Unicode and non-Unicode. However, take into consideration the following:

Migrating Oracle databases to Unicode (from non-unicode character sets) is not supported.

For Unicode Oracle databases, string attributes will hold a maximum of 1000 characters.

If you need more than 1000 characters, extended text attributes should be used.

 

 

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 ensure 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;

 

When using Oracle 11g R2, you should ensure that your version is 11.2.0.3.x or higher:

 

Oracle11Version

 

 

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)

 

ConnectSysdba

 

 

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.

 

note_pin

The aforementioned script has a .basql file extension.

In other to retrieve the actual script, ensure you rename this file to a .zip and then extract its contents.

 

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.

 

BizAgiAdmonScript

 

1.3 Run the script.

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

 

ExecuteBizAgiAdmon

 

note_pin

This script is subject to change in each Bizagi version.

Therefore, you should take the mentioned script that corresponds exactly to the installed version of Bizagi.

 

 

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.0): http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

 

 

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:

 

AboutOracleDataProvider_Image001

 

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

 

AboutOracleDataProvider_Image002

 

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 websites:

http://www.oracle.com/technology/software/tech/windows/odpnet/install1110720.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.

 

note_pin

Notice that:

The database server does not require this component.

End users do not need to install this component on their workstations (end users access Bizagi Work Portal, which only requires a browser).