Installing the Oracle's connectivity client

<< Click to Display Table of Contents >>

Navigation:  Automation Server > Automation Server configuration and administration guide > System prerequisites > Bizagi server prerequisites >

Installing the Oracle's connectivity client

Overview

Automation Server requires a database server for your processes repository.

Oracle databases are supported for the database server configuration, as described at Oracle prerequisites.

Once you install and set up an Oracle instance, you need to carry out the following tasks:

 

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

2. Install Oracle's connectivity client on the Bizagi server.

 

This section details how to perform the second configuration task.

 

Oracle's connectivity client

Automation Server relies on the Oracle Data Provider for the .NET connector to access an Oracle database, while running in a .NET platform.

This connector is needed only when any of the following are met:

The process repository is hosted in Oracle.

Your processes integrate one or more external Oracle data sources (by relying on the Data Virtualization or Data Replication Bizagi features).

 

The connector is not needed at the database server but at the Bizagi server (where Automation Server is installed, both for its Work portal and Scheduler).

The following table describes where this component is needed according to the features involved:

 

Installing Oracle Data Provider required...

On the Bizagi Server (running the Work portal)

On the server running the

Scheduler service (usually the same Bizagi Server)

When using Oracle for Bizagi Processes repository

Yes

Yes

When using Virtualization to integrate Oracle

Yes

No

When using Replication to integrate Oracle

No

Yes

 

Procedure

To install this client, follow these instructions:

 

1. Download the installer

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

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

 

For a 64-bit Bizagi setup, download the 11.2.0.3.0 x64 release for .NET 4.0 at:

https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html#license-lightbox

 

2. Install ODAC and its ODP.NET component

Run the installer on the Bizagi Server (where Automation Server is running), and 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.

After you see a message that the installation is complete, 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/database/technologies/dotnet-odacdeploy-downloads.html#license-lightbox.

 

3. Do this for additional servers if necessary

If you are using a Bizagi cluster or have the Scheduler service running on a different server, install this component on each server.

 

note_pin

Note that:

The database server does not require this component.

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