Defining an ODS data source at the JEE application server

<< Click to Display Table of Contents >>

Navigation:  Bizagi Engine > Bizagi system administration > Database server configuration > Bizagi ODS >

Defining an ODS data source at the JEE application server

applies_JEE

 

Overview

If your project is running in a JEE platform, using the ODS feature requires that you define the Data Source in your JEE Application Server that connects to your replicated Database.

 

This feature is optional and it is recommended to improve Bizagi Engine's performance and availability.

For more information about the concept behind this feature, refer to Configuring Bizagi ODS for Process Analytics.

 

 

ODS00_Overview

 

 

Defining the ODS Data source

Once you have configured your replicated Database, make sure you register and define the Data source at your JEE Application Server.

This step slightly varies according to the JEE Application Server itself (WebSphere, Weblogic, JBoss).

 

Configuration in WebSphere

To register and define the ODS Data source, keep in mind you may use the JDBC Provider you already have registered for Bizagi Work portal.

By using the existing JDBC Provider, you will only need to create a new Data Source.

To do this, access the administration console and locate the panel to the left to quickly click the Data sources link (at the Resources section in the expanded JDBC item).

 

Make sure you select the scope that includes your server instance (or your cluster, if you are using a clustered environment).

 

Create a Data Source by clicking the New button.

In the new Data Source configuration, enter the following information:

Data source name: Enter the unique name for this Data source.

Keep in mind that this name must be taken into account for the ODS configuration back in Bizagi.

JNDI name: You may enter as well the same name as used for the Data source name.

 

ODS_WSDS_02

 

Ensure that you use the Select an existing JDBC Provider to select the JDBC Data Provider according to your Database Engine (choose either the one for Oracle or SQL Server).

 

WSDS_03

 

If you are using Oracle, click Next and in the upcoming step, make sure that you edit the URL.

For the URL, enter the whole connection string to your replicated Oracle instance. This should be formatted as:

jdbc:oracle:thin:@[database_server]:[port_number]:[service_name]

Consider:

odatabase_server: The Database Server name. You may choose to use the SID instead.

oport_number: The port under which the Database service listens. In Oracle, by default it is the 1521.

oservice_name: The service name to your Oracle instance ID .

Once this is set for your Oracle connection, click Next in the following Windows (until you reach the last guided step and click Finish to create the Data Source).

 

On the other hand and if you are using SQL Server, click Next in the following Windows (until you reach the last guided step and click Finish to create the Data Source). No further configuration is required and you may leave the defaults shown by WebSphere.

 

 

For an either Oracle or SQL Server Data source, click the recently created Data source and click on the Custom properties link located at the Additional Properties section.

 

ODS_WSDS_05

 

Edit the properties as described below (according to your Database Engine), in order to assign the proper values of your replicated Database connection.

 

For Oracle:

Create 2 new properties: user and password. For their values, consider:

ouser: The user schema which represents your Bizagi project.

opassword: The password to access the user schema.

 

For SQL Server:

Edit these properties:

oserverName: The Database Server name.

oportNumber: The port under which the Database service listens. In SQL Server, by default it is the 1433.

odatabaseName: The name of the replicated Database.

ouser: The login account to access the Database.

opassword: The password for the login account to access the Database.

 

After editing these properties, make sure you click Save to apply all changes.

 

Configuration in Weblogic

To register and define the ODS Data source, keep in mind you will only need to create a new Data Source.

To do this, access the administration console and go into the Services section and into Data Sources.

 

WL_4_01

 

Create a Data Source, by clicking on New and specifying that it is a Generic Data Source. To configure the Data Source, specify the following:

Data source name: Enter the unique name for this Data source.

Keep in mind that this name must be taken into account for the ODS configuration back in Bizagi.

JNDI name: You may enter as well the same name as used for the Data source name.

 

Next, and for a replicated Database in Oracle, choose Oracle as the Database type.

And then, select Oracle’s Driver (Thin) for instance connections; Versions: 9.0.1 and later for the Database Driver.

 

If you are using a replicated Database in SQL Server, make sure you choose MS SQL Server as the Database type.

And then, select Microsoft's MS SQL Server Driver (Type 4) Versions:2005 and later for the Database Driver.

 

For an either Oracle or SQL Server Data source, click Next to specify the Connection details to your Database.

Make sure you review the URL of your connection string.

 

Finish the configuration by ensuring that this data source is applied to your server instance (or your cluster, if you are using a clustered environment)within the target configuration.

 

Finally, make sure you activate the changes.

 

What is next?

Once you are done, make sure that you configure the ODS Data source in Bizagi (as described at Configuring Bizagi ODS for Process Analytics), by referring to the exact name of the Data source configured in the above steps.