Skip to content

Expert Oracle Posts

Integrated SOA Gateway (ISG) – 4 – standalone installation for ERP R12.2

In this post we will discuss on key steps that we need to follow to install Integrated SOA Gateway (ISG) on a standalone  SOA Weblogic server.

Oracle E-Business Suite Integrated SOA Gateway (ISG) enables supported interface types published in Oracle Integration Repository. These interfaces can be transformed into SOAP and REST web services.

Oracle E-Business Suite SOAP Services

  • SOAP-based web services are deployed on Oracle SOA Suite running on Oracle WebLogic Server
  • Steps to configure SOAP services span across Oracle E-Business Suite as well as Oracle SOA Suite
  • Interface types enabled for SOAP services are PL/SQL, Concurrent Program, XML Gateway (Inbound), and Business Service Object.

1 Comment

Integrated SOA Gateway (ISG) – 3 – EBS Integration Repository basic details

Oracle E-Business Suite Integrated SOA Gateway is the intrinsic part of Oracle Ebusiness Suite for service enablement.

Key points:

  • A central location where all service related business interfaces are stored
  • All application users can browse through these business interfaces to know what type of services are available for service consumption.
  • Provides a complete catalog of integration interfaces within Oracle E-Business Suite.
  • Any changes in interface definitions and descriptions are automatically reflected with EBS release
  • Displays each interface details including source information, methods within the interface, and Web service information if the interface can be service enabled.
  • Supports custom integration interfaces
  • Enforces security rules to allow only authorized users to perform administrative tasks
Leave a Comment

Integrated SOA Gateway (ISG) – 2 – Service Enablement in Oracle E-Business Suite

We already described in earlier post what is web service. Service enablement is one of the “essential features”  or “process flow” in Oracle E-Business Suite Integrated SOA Gateway. You can say it is that “magic ingredient” which allows native packaged integration interface definitions written in PL/SQL, Java, and other formats and stored in Oracle Integration Repository to be transformed into Web services.

“Service enablement” involves:

  • Generating service artifacts, such as XSD
  • To validate XML messages, WSDL or WADL to describe the Web service,
  • Deploying web services on an application server so that the services are available to clients over the Web.
Leave a Comment

Integrated SOA Gateway (ISG) – 1 – fundamentals

Before going into ISG Concepts, it is important to briefly understand what is a Web Service and some other related terms which can be new for beginner.

Web Services:

  • Web Service in simple terms is a “software system” for machine-to-machine interaction over a network.
  • Its interface is described in certain format which can be processed by machine.
  • WSDL is one kind of interface format which can be created using SOAP messages
  • WADL is another kind of interface format created using REST messages
  • Web Services are self-describing, reusable software components encapsulating discrete functionality. Example: Employee creation can be one self-contained web service.

Leave a Comment

Basics of Jenkins

Jenkins is free tool and is considered one of the important tool for DevOps related activities. It is  written entirely in Java language.

Before we move further we need to understand one key term “continuous integration/deployment”

What is continuous integration/deployment

  • You have a large team of 15 developers.
  • Code is changed and committed many times in a day
  • “Commit” means code will be “build” and tested
  • If “testing” is good, then build is tested for deployment
  • If “deployment” is good, you will plan for Production push

1 Comment