Creating report based on External Data Source (Database table) – Oracle BAM

Creating report based on External Data Source  (Database table) – Oracle BAM

In Oracle BAM the reports can be created based on the external database table.This post will explain the steps required to build a simple report based on the external database table.

Create the External Database:

• Login to Oracle BAM Start page and click on Architect button.

• Select External Data Sources from the drop down list and click on the create button in the next page.

• Provide the External Datasource Name and the database details and click on the Test button to test the External Data Source.

Importing the Oracle BAM objects from 10g to 11g

Importing the Oracle BAM objects from 10g to 11g

The icommand utility will be used to export and import the Oracle BAM objects between environments.

This blog will explain how to import the Oracle BAM objects exported from the 10g environment.

Before executing the icommand to import the BAM objects make sure the BAM port name (the default port name is 9001) configured properly in $MIDDLE_HOME/ORACLE_SOA1/bam/config/BAMICommandConfig.xml file.

Import the data object:

icommand -cmd import -file D:\Albin\Docs\SavingsAccountOpeningBAM\SavingsAccountOpening.do -mode preserveid

Configuring Oracle BAM Adapter connection factory through EM console– Oracle SOA Suite

Configuring Oracle BAM Adapter connection factory through EM console– Oracle SOA Suite:

The Oracle BAM Adapter is used as a partner link in a BPEL process to send data to Oracle BAM data object.

The below are the steps to configure the default connection factory, new connection factories also can be created instead of using the default one in Oracle SOA Suite 11g or Oracle SOA Suite 12c

Steps to configure the BAM Adapter:

• Login WebLogic Admin Console

• Click Deployments in Domain Structure pane

• Click on the application OralceBamAdapter

• Click on Configuration tab

• Click on Outbound Connection Pools

• Expand oracle.bam.adapter.adc.RMIConnectionFactory.

Configuring BAM web application properties – Oracle SOA Suite

Configuring BAM web application properties – Oracle SOA Suite

The BAM web application properties should be configured before designing the reports in Oracle BAM, these properties will be configured in reports.

Steps to configure the BAM web application properties

• Login to EM console and maximize the BAM node

• Click on OracleBamWeb and click on BAM Web Properties

• Change the application URL and the Server name as shown below (port should be the BAM server port) and Click on Apply

Oracle BAM (Oracle Business Activity Monitoring) Features

Oracle BAM (Oracle Business Activity Monitoring) Features:

Oracle Business Activity Monitoring (Oracle BAM) is a complete solution for building interactive, real-time dashboards and proactive alerts for monitoring business processes and services.

Oracle BAM gives business executives and operation managers the information they need to make better business decisions and take corrective action if the business environment changes.

• Able to monitor the BPEL process and other processes by integrating the processes with BAM.
• Able to create live report for the process integrated
• Able to alert the users based on the rules defined
• We can able to call BPEL and other Webservices from BAM.

Oracle BAM is comprised of six components:

• Data Integration
• Data Caching
• Analytics
• Monitoring
• Alerting
• Reporting

Oracle BAM Event Engine:

• Oracle BAM Event Engine monitors complex changing conditions in the data and the system in real-time and based upon user-defined rules.
• Takes a variety of actions in response to those changes.
• Notifying the appropriate user with an alert and/or report.
  

Oracle BAM Active Report Engine:

• Oracle BAM Active Report Engine assembles and formats the data for a live report to be displayed in Oracle BAM’s thin and rich clients
• Reports are available in a variety and combination of view types including charts
  

Oracle BAM –User Interfaces:

Oracle BAM Active Viewer

– thin user interface for the business user

Oracle BAM Active Studio

– thin user interface for the power user

– the power user can create and edit reports

Oracle BAM Architect

– thin user interface for the data designer focused on creating data objects in the Oracle BAM Active Data Cache

Oracle BAM Administrator

– thin user interface for the system administrator who is responsible for user management and overall server management

Security Filter:

Security filters to data objects so that only specific users can view specific rows in the data object

Permissions:

Permissions for users and groups on data objects.