Skip to content

Author: Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]

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

Cassandra – 4 – Cassandra Architecture terminology

Cassandra is a distributed database system and it runs on multiple nodes at once.  The nodes use a peer-to-peer communication protocol to exchange any information.

Some key points regarding Cassandra architecture/functioning:

  • Table rows are stored in tables, each with a mandatory primary key
  • Data gets first written to log file for durability and then somewhat similar to RDBMS databases, write the data to cache and when cache is full it write the data finally to disk
  • Automatically partition the data and replicate it.
  • At regular interval, it compacts the data in the database
  • Cluster nodes are chosen randomly to fetch the data as per client need

Leave a Comment

Cassandra – 3 – Related Terms : ACID, BASE, CAP Theorem

Oralce/MYSQL database administrators are well aware of term named ACID

ACID stands for: Atomicity, Consistency, Isolation, Durability and it is at the foundation of RDBMS success.

ATOMICITY: If one part of transaction fails, the entire transaction will fail to maintain integrity of database

CONSISTENCY: Database will always be in a consistent state both at the beginning and at the end of a transaction

ISOLATION:  No transaction has access to any other in-flight/unfinished transaction

DURABILITY:  Database records the transaction in persistent storage/data files when it completes. Power/disk  failure will not impact the completed transaction.

Leave a Comment

Cassandra – 2 – Basics of Cassandra

The word Cassandra was taken from the name of ancient Greet prophet Cassandra.

Apache Cassandra is a distributed NoSQL database system. It is a distributed database system. It is NOT RDBMS system like Oracle. It is NoSQL database.

High availability and linear scalability are some key benefits of Cassandra database. Cassandra is designed for high-volume, low-latency cloud applications.

Leave a Comment

Cassandra – 1 – NoSQL Database

As they say “Necessity is the mother of invention”. There would have been no RDBMS kind of databases like Oracle if there was no computers.

Similarly there would have been no need of NoSQL kind of databases if there was no Internet explosion, no Facebook/social media, no cell phones etc. etc. All these new “trends” generated such huge data at such fast pace that RDMBS was simply not able to cope up. NoSQL helped in solving this problem of this new/huge/versatile/fast generating data.

Leave a Comment

Oracle Cloud Infrastructure (OCI) – 3 – Concept of Compartments

To organize your Oracle Cloud resources you will create couple of compartments. Your goal of creating compartment is to have ease of management, security, isolation of resources.

When your tenancy is provisioned, a root compartment is created for you. Your root compartment holds all of your cloud resources.

Before we plan to create a new compartment under our root compartment we should understand some key points and best practices related to compartments.

Some key points that you keep in mind related to compartments are:

Leave a Comment