File Adaptor and Database Adaptor

Reading a file using file adaptor and inserting into database using DB Adaptor

configuring Database Adaptor in Application server

Login to em console ->cluster toplogy->oc4j_soa->Administration->JDBC Resources
connection pools->
create Name - filedbconn
Connection Factory Class oracle.jdbc.pool.OracleDataSource
URL : jdbc:oracle:thin:@//localhost:1521/xe
Username : system
Password : oracle

creating Datasource connections

login in to em console ->cluster toplogy->oc4j_soa->Administration->JDBC Resources
Datasources->create ->select Manage Datasource -> continue

Application Name : default
JNDI Location : jdbc/localdbtest
Type : Manage Datasource
Connection Pool : filedbconn(select existing connection pool name)
Transaction Level : Global & Local Transactions
Name : LocalDBDatasource

configuring Database Adaptor

go to em console ->cluster toplogy->oc4j_soa->Applications->default ->DBAdaptor
Connection Factory Interface - javax.resource.cci.ConnectionFactory
JNDI Location - eis/apps/LocalDatabase
xADataSourceName - jdbc/localdbtest (is the name of JNDI Location in Datasource)

Create BPEL Process



select empty BPEL process



Configure file adaptor



Enter Service Name



select Readfile

Connecting to Oracle SOA Server 10g from Jdev 10g

Here I would like to show how to connect Jdeveloper to Oracle SOA Suite servers.
This includes connecting to Oracle XE Database, Oracle Application Server and Integration Server


1) Establish Connection from Jdeveloper to Oracle Database

Start Jdeveloper open the Connections Navigator tab, and double-click Database to launch the Create Database Connection wizard



Right click on Database Server and select New Connection a Connection wizard appears click next

Connection Name: DBDemoConn
Connection Type: Oracle (JDBC)



Click next and enter Database Username/Password system/welcome1



Click next and give Host Name, JDBC Port and SID



Click on Next, and Test Connection



2) Establish Connection from Jdeveloper to Application Server
Open the Connections Navigator tab, and double-click Application Server. Create Application Server Connection wizard appears



I have given Connection Name, Connection Type as SOA_Appserver, Oracle Application Server 10g 10.1.3



Click next and type Username/Password oc4jadmin/admin123

Specify Host Name, OPMN Port, oc4j Instance name
OPMN Port can be found from Runtime Ports in Application Server console






Click on Next, and Test Connection



3) Establish Connection from Jdeveloper to Integration Server (BPEL)
Open the Connections Navigator tab, and double-click Integration Server. Create Integration Server Connection wizard appears



I have given connection name as SOA_Intserver and click next



Once you select Application Server the details will be populated automatically in the Integration Server.



Click next and Test Connection the status of Application Server, BPEL, ESB Servers should be OK

"An unknown OPMN error has occurred""Error connecting to OPMN (is it running?): Connection refused: connect"

Stop all opmn and related process forcefully if does not stop from "stop SOA suite" script

Rename persistence to persistence.old in \SOA_HOME\OracleAS_1\j2ee\oc4j_soa\persistence

we will not be able to rename the folder if opmn or any related process is still running.

Use the following command to start SOA suite

opmnctl start
opmnctl startproc process-type=HTTP_Server
opmnctl startproc process-type=${oc4j_instance_name}
opmnctl startproc process-type=oc4j_soa

Upgrading Oracle SOA Suite 10.1.3.1 to 10.1.3.5

To Upgrade Oracle SOA Suite to 10.1.3.5 Oracle Application Server 10g patch 8626084 is available.

we can apply this Patch to existing versions of Oracle SOA Suite(10.1.3.x)

I have upgraded OracleSOA 10.1.3.1 to 10.1.3.5 on windows wanted to share it

Upgrading SOA 10.1.3.1 to 10.1.3.5

1)Upgragde ORABPEL and ORAESB schemas before applying patch

Run ORABPEL Schemas
Connect to Database as ORABPEL User and run upgrade_10131_10135_oracle.sql located in
\10.1.3.5\ias_windows_x86_101350\Disk1\install\soa_schema_upgrade\bpel\scripts


Run ORAESB Schemas
Connect to Database as ORAESB User and run upgrade_10131_10135_oracle.sql located in
\10.1.3.5\ias_windows_x86_101350\Disk1\install\soa_schema_upgrade\esb\sql\other

2)Install SOA Suite
click setup.exe from \soa10.1.3.5\ias_windows_x86_101350\Disk1

3)specify existing SOA Suite Path and oc4jadmin Password
oc4jadmin password : welcome1

4)we need to give OWSM Database Password for SOA 10.1.3.5 Patch
Host Name,Port,ServiceName,OWSM Password.

5)click Configure Assistances.It will try to install

Installation of Oracle SOA Suite 10.1.3.1

Before Installing SOA Suite we must check the following

Install Oracle Database Installation of Oracle SOA Suite requires the availability of an Oracle database. This database must be up and running, and does not have to be on the same system where you are installing the products.
Memory Requirements Minimum physical memory 2GB and available memory 1GB
JDK 1.4 or 1.5 and set ORACLE_HOME and JAVA_HOME path

Create Schemas for Oracle SOA Suite

Oracle SOA Suite require that certain schemas exist in the database prior to installation (advanced)

Load ORABPEL,ORAESB,ORAWSM Schemas into Database

Navigate to \SOA Suite\install\soa_schemas\irca
set JAVA_HOME,ORACLE_HOME path in irca file

Run irca with following options

irca all|orabpel|oraesb|orawsm "db_host db_port db_service_name" sys_password -overwrite ORABPEL ORABPEL_PASSWD ORAESB ORAESB_PASSWD ORAWSM AWSM_PASSWD>

ex: irca all " localhost 1521 XE" welcome1 -overwrite ORABPEL oracle ORAESB oracle ORAWSM oracle

go to \SOA Suite\ setup and install

select Advance installation

specify Database configurations

username
Password
host:port
servicename

Enter Application Server Instance name,username,password:welcome1

Instance name : oc4j_soa and click install it will take some time for installation

Designing BPEL Process using Round Robin functionality

Implementing Dynamic user Xpath in BPEL Process
create a BPEL Process and Add human task for BPEL worklist application.
Edit human task Add an assignment and Routing policy.
select Type as GroupVote
Specify pattern name, group name and realm name in Expression Builder

Ex: hwf::wfDynamicUserAssign ('ROUND_ROBIN','WesternRegion','jazn')
Auto Generate Simple Task Form and deploy the process.
Once process is Build successfull login to BPEL console and enter input payload for worklist application
Users in "WesternRegion" Group are istone,jcooper,cdoyle in realm "jazn"

• Login to BPEL Worklist Application as ‘istone’ is the first user in the ‘WesternRegion’ group and the task is initially assigned to first user in the group as per Round Robin functionality
• Second time when task is initiated it is assigned to second user in the group “jcooper”.
• Third time when task is initiated it is assigned to 3rd user in the group "cdoyle".

Implementing Dynamic Group Xpath in BPEL Process
DynamicGroupXpath function is similar to WfDynamicUserAssign select DynamicGroupXpath from Expression builder in BPEL worklist Application human tsk

Ex: hwf: wfDynamicGroupAssign ('ROUND_ROBIN','RegionalOffices','Jazn')
'Regional Offices is the group name
Group is selected either subordinate groups of the specified group (single group).

Regional Office (Head Office)
WesternRegion(sub office which inherits regional office)
CentralRegion(sub office which inherits regional office)

When task is assigned to “Regional Office” group. It is 1st assigned to users of “WesternRegion” group and later to “central region” as both are subordinate groups of regional offices.

Oracle Workflow Services Dispatching Functions

Features of Oracle workflow services include built-in dispatching functions:
round-robin, least-busy and most-productive

Oracle BPEL Worklist Round Robin Functionality
The term 'Round Robin' used to refer to things that operate in a rotational manner, like tournaments where each player plays every other, circular letters etc.
Automatic Assignment and Delegation
A user may decide to have another user perform tasks on their behalf. Tasks can be explicitly delegated from the Oracle BPEL Worklist Application or can be automatically delegated. An example of automatic routing is to allocate tasks among multiple individuals belonging to a group. For example, a help desk
supervisor decides to allocate all tasks for the western region based on a round robin basis

Dynamic Assignment Functions
Dynamic assignment functions select a particular user or group from either a group or from a list of users or groups included with Oracle BPEL Process Manager. The three Dynamic Assignment Functions included with Oracle BPEL Process Manager are round-robin, least-busy, and most-productive.
Round Robin: picks each user or group in turn
These dynamic assignment functions can be called using the custom XPath functions in a BPEL process or task definition.
WfDynamicUserAssign
WfDynamicGroupAssign

wfDynamicUserAssign
This function returns the name of an identity service user, selected according to the specified assignment pattern. The user is selected from either the subordinate users of the specified group (if a single group name is supplied), or from the list of users (if a list of user names is supplied). If the identity service is configured with multiple realms, the realm name for the group and users must also be supplied. Additional assignment pattern specific parameters can be supplied. These additional parameters are optional, depending on the details of the specific assignment pattern used.
There are two signatures of this function.
Signature 1:
hwf::wfDynamicUserAssign (’patternName’,’groupName’,’realmName’?,’
patternParam1’?,....,’patternParam2’?,...,’patternParamN’?)
Signature 2:
hwf::wfDynamicUserAssign (patternName, userList, realmName?,patternP
aram1?,patternParam2?,...,patternParamN?)

wfDynamicGroupAssign
This function gets the name of an identity service group, selected according to the specified assignment pattern. The group is selected from either the subordinate groups of the specified group (if a single group name is supplied), or from the list of groups (if a list of user names is supplied). If the identity service is configured with multiple realms, the realm name for the group and groups must also be supplied. Additional assignment pattern specific parameters can be supplied. These additional parameters
are optional, depending on the details of the specific assignment pattern used.
There are two signatures of this function.
Signature 1:
hwf::wfDynamicGroupAssign(’patternName’,’groupName’,’realmName’?,
’patternParam1’?,’patternParam2’?,...,’patternParamN’?)
Signature 2:
hwf::wfDynamicGroupAssign(’patternName’,’groupList’,’realmName’?,
’patternParam1’?,’patternParam2’?,...,’patternParamN’?)
Arguments:
■ PatternName - The name of the assignment pattern (for example, ROUND_
ROBIN).
■ groupList - The list of groups from which to select a group.
■ realmName - The name of the identity service realm to which the groups belong.
■ patternParam1...patternParamN - Any additional parameters required by
the assignment pattern implementation (may be optional, depending on the
pattern)

Oracle SOA Suite Overview

SOA
A service-oriented architecture is essentially a collection of services. These services communicate with each other. The communication can involve either simple data passing or it could involve two or more services coordinating some activity.

Oracle SOA Suite
Oracle SOA Suite is an essential middleware layer of Oracle Fusion Middleware. It provides a complete set of Service Infrastructure components for designing, deploying, and managing composite applications. Oracle SOA Suite enables services to be created, managed, and orchestrated into composite applications and business processes. Composites enable you to easily assemble multiple technology components into one SOA composite application.

Oracle SOA Suite is unique in that it provides the following set of integrated capabilities:

Messaging

Service discovery

Orchestration Web services management and security Business rules

Business activity monitoring

These capabilities help address the fragmented IT landscape and address the difficulties associated with silos of IT infrastructure and applications.

components Of oracle soa suite are

1) Oracle JDeveloper, Oracle ADF, and Oracle TopLink together provide acomprehensive integrated services environment and framework that allowsdevelopers to build model-driven applications and business processes which can thenbe deployed and registered as applications, services, or business processes into OracleSOA Suite components.

2)Oracle Enterprise Service Bus provides a loosely-coupled framework for inter-application messaging.ESB has its own boundaries, which is the enterprise. All internal systems within enterprise and external systems can connect to ESB server in order to send and receive messages.

3)Oracle BPEL Process Manager enables business processes to be modeled, automated,and monitored. Oracle BPEL Process Manager provides a comprehensive, standards-based and easy to use solution for creating, deploying, and managing cross-application businessProcesses with both automated and human workflow steps.

4)Oracle Web Services Manager (Oracle WSM) is a Web services security and management solution that provides a common security infrastructure for all Web service applications.

Various Components of OWSM are

Policy Enforcement Points (Oracle WSM Agents and Oracle WSM Gateway)
Oracle WSM Policy Manager
Oracle WSM Monitor
Oracle Enterprise Manager 10g Web Services Manager Control (Web Services Manager Control)
Oracle WSM Database

5)Oracle Business Rules makes processes and applications more flexible by enabling business analysts and non-developers to easily define and modify business logic without programming.
Oracle Business Rules consist of a Rule Authoring Tool, a Rules engine, and SDK. The Authoring tool presents an English-like paradigm for declaring rules that can be used by both programmers and business analysts. The Rules Engine is a fast and efficient JSR-94 compliant RETE based engine written in Java. The SDK enables rules generation by custom rules editing applications.

6)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.

Overview Of Oracle Fusion Middleware

Oracle Fusion Middleware is a family of Oracle Produts which helps in Application Development and Integration Solution to Identity Management,Collaboration Suite and Business Intelligence Reports.
Oracle Fusion Middleware is designed to support development,deployment and Management of Service Oriented Architecture.
Following are Various Products of Oracle Fusion Middleware

Oracle Application Server
Oracle Application Server is core component of OFM.It offers a comprehensive solution for developing, integrating, and deploying enterprise's applications, portals, and Web services. As the only platform designed for grid computing as well as full lifecycle support for Service-Oriented Architecture (SOA), Oracle Application Server gives you unmatched scalability, availability, manageability, and security .

Oracle Collaboration Suite
The Oracle Collaboration Suite enables individuals and teams to communicate and work together using a set of integrated software that enhances the existing desktop and wireless clients used in your organizations.
key components of collaboration suite are
Real Time Collaboration and Oracle Content Management

Oracle Portal
Oracle Portal combines a rich, declarative environment for creating a portal Web interface, publishing and managing information, accessing dynamic data, and customizing the portal experience with an extensible framework for any Web-based technology, such as J2EE-based application access and Web Services. Using Oracle Portal, e-businesses have the power to connect employees, partners, and customers with the information they need, as well as the flexibility to create views tailored to each community


Oracle Identity Manager
Oracle Identity Manager is a higly flexible and scalable enterprise identity management system that centrally administers user accounts and access privileges with enterprise IT. It manages the entire identity life cycle to meet changing business and regulatory requirements and provides essential auditing, reporting and compliance functionalities.

Business Integration
Business Integration Connecting or Integrating processes, Applications or information with business partners using hot pluggable products which are based on Services Oriented Architecture.

Business Process Analysis Suite
Oracle Business Process Analysis (BPA) Suite speeds process innovation by rapidly modeling business processes and converting them into IT executables.