Thursday Jul 02, 2015

How to Service Enable Database Stored Procedure or Function in Oracle Service Bus 12c.

Oracle Service Bus transforms complex and brittle architectures into agile integration networks by connecting, virtualizing, and managing interactions between services and applications. In this post I will explain how to create a simple web service in Oracle Service Bus 12c based on functions or stored procedures in a database.

Service Bus provides a J2EE Connector Architecture (JCA) transport that interacts with back-end Enterprise Information Systems (EIS), letting these systems participate in the Service Bus integration environment. The JCA transport provides native connectivity between Service Bus and external systems, letting those systems interact in the service bus layer and leverage the capabilities and features of Service Bus. For our purposes we will be using JCA Database Adapter, which lets Service Bus business and proxy services communicate with Oracle databases or third-party databases through JDBC.

[Read More]

Saturday Jun 20, 2015

Creating Oracle Service Bus 12c Proxy Service to Decouple JCA Database Adapter Business Services

In an earlier blog I showed how to service enable a database on OSB 12c . The business service created as we saw is strongly coupled to the database. A change on the database (table name, data type or column name) would impact the interface created. This is something that we want to avoid when using the service in a larger context in Service –Oriented Architecture (SOA).

In this blog post, I will explain how to create a proxy service in OSB 12c that can act as an atomic service to decouple the database.

[Read More]

Wednesday Jun 17, 2015

Database CRUD Web Services Enablement with Oracle Service Bus 12c

Before the release of Oracle Fusion Middleware 12c, we could only use  a JCA Database adapter with Oracle Service Bus 11g by working with Eclipse (OEPE) for OSB development of services and Jdeveloper in parallel as the  adapter wizards were only available in JDeveloper Oracle SOA Suite 11g project.

The development of services to decouple a database in Oracle Service Bus 12cis less work due to the now existing new Overview Editor in Jdeveloper 12c for developing Service Bus services compared to the Composite Editor for Oracle SOA Suite 11g, it lets you drag and drop components on to the editor to create services. The editor provides direct creation and editing of JCA adapters, REST bindings, and Service Bus services.

[Read More]

Monday Feb 11, 2013

Partner Webcast - Building Custom JCA Adapters To Integrate 3rd Party Solutions to Oracle FMW - 21 Feb 2013

Succeed in business process optimization with efficient integration of back-end applications

Oracle Integration Adapters, a component of Oracle Fusion Middleware, offers organizations a service oriented approach to unlocking the information assets that have evolved in most IT environments. These adapters are based on Java Connection Architecture (JCA) specification, and they have become a standard way of integration with Enterprise Information Systems (EIS).

Oracle Adapters provide an easy-to-use, flexible, standards based SOA platform to enable rapid and real-time connectivity and access to over 300+ enterprise applications. Oracle on its own and also via partnerships with best of breed Adapter Vendors provide a broad range, but what if your application is not covered? What is your application cannot be easily integrated via technology adapters (DB, File, JMS, etc.) or you'd like to gain performance or other benefits from knowing its internal architecture?

How can you develop your custom JCA adapter?

[Read More]

Oracle ECEMEA Partner Hubs
Migration Center Team

We share our skills to maximize your revenue!
Adopt and implement the latest of Oracle Technology in your solutions.

Stay Connected
Google+ Subscribe


« November 2015