Download - Integration of ERP’s using SOA
-
8/9/2019 Integration of ERPs using SOA
1/14
Integration of ERPs
using SOA
-
8/9/2019 Integration of ERPs using SOA
2/14
Scenario
All the H.Rfunctionalities takes
place in this ERP
Oracle EBS JDEE1
Other business
processes, (finance,manufacturing,
operations, sales &etc.)
OrganizationOrganization
-
8/9/2019 Integration of ERPs using SOA
3/14
Human Resource functionalities Oracle E-
Business Suite& other Business functionalities JDEE1
Employee requests for five days Paid Leave to themanager by an e-mail or verbally.
The manager accepts his request, but its hisresponsibility to inform the HR about the same.
Now the H.R database is not updated with employee
leave details.
The employee receives incorrect amount of hissalary, due to lack of update in H.R database .
Organization suffers a LOSS. An organization willsuffer huge losses if many such employee leave
Understanding the Scenario
-
8/9/2019 Integration of ERPs using SOA
4/14
Our application to therescue
These losses can be can be prevented, byupdating the H.R database consistently.
This can be achieved by Integrating the two
ERPS modules in an organization. Here weintegrate EBS & JDEE1.
To achieve integration and eliminate the losses,our leave application comes to the Rescue.
The leave application updates the database ofboth the ERPS without much of humanintervention.
-
8/9/2019 Integration of ERPs using SOA
5/14
Integration
Lack of integration results in:
Inconsistent & poor quality of data
High inventory carrying cost
Data Reconciliation issues
Data fragmentation
Integration of two systems results in :-
Managing data quality
Centralize product information
Eliminate product data fragmentation
-
8/9/2019 Integration of ERPs using SOA
6/14
Fusion Middleware
Standards-based technology that details the linkage
between enterprise applications , middleware , and other
technologies
A unifying model of emerging trends in service oriented
architecture and enterprise information architecture.
Oracle Fusion Middleware is a family of closely related
products that are often deployed and used in conjunction
with one another.
-
8/9/2019 Integration of ERPs using SOA
7/14
Service OrientedService Oriented
ArchitectureArchitecture
Application Server
Java EE, WS-*, event services
Enterprise Service Bus
RoutingAdapters
Service
Registry (UDDI)
BPEL Process Manager
Native
BPEL
Human
workflow
Business
RulesWeb Services
Manager
Security
BAM MonitoringEventsAnalytics
JDeveloper
Integrated
Services
Environment
App Dev
Framework
XSLT
Transform
B2B
Management
-
8/9/2019 Integration of ERPs using SOA
8/14
BPEL
BPEL is an XML-based language that defines a
business process flow.
Standard executable language for specifying
interactions with Web Services
It defines a notation for specifying business
process behavior based on Web Services
-
8/9/2019 Integration of ERPs using SOA
9/14
Tools Used
Oracle SOA Suite
- W3C defines SOA as a set of componentswhich can be . invoked, and whoseinterface descriptions can be published
and discovered.
- SOA is an architecture
- Using Oracle SOA Suite
JDeveloper- Free IDE from oracle
- Covers the full development lifecycle
- Features for development in Java, XML, SQL andPL/SQL,
HTML, JavaScript, BPEL and PHP.
-
8/9/2019 Integration of ERPs using SOA
10/14
BPEL Components UsedBPEL Components Used
Emp_Verification:
Verifies employee
Copy employee details from employee database to temporary database
Mail_Managertwo :
Sends mail to manager along with leave request & employee details
Leave_Approve :
Approves/rejects leave request
Mail is sent to employee & manager ,& database is updated in case of rejection
Mail is sent to employee along with reason in case of rejection
Polling :
Updates HR database
Checks for any updates in database
-
8/9/2019 Integration of ERPs using SOA
11/14
Project Detail
Employee login using its Empid & Password
Provides all the detail of employee from its database.
Employee applies for leave.
If Employee is a manager, all pending requests are shown. Manger accepts/rejects requests.
If manager accepts, mail is sent to manager & employee,&
database is updated.
If manager rejects, mail is sent to manager & employee
along with reason.
-
8/9/2019 Integration of ERPs using SOA
12/14
Flow DiagramFlow Diagram
Log In
Employee
Details
Apply forLeave
Email issent
Verify
No
Yes
Check
Manager
Yes
Show Pending
Approvals
No
-
8/9/2019 Integration of ERPs using SOA
13/14
Integration: JDEE1 andIntegration: JDEE1 and
Oracle EBSOracle EBS
E-BUSINESS SUITEApplication
Server
USER
1
USER
2
USER
3
USER
4
USER
1
USER
N
Leave
App
SOAP
Adapter
SOAP
Adapter
JD EDWARDS E1Application
Server
-
8/9/2019 Integration of ERPs using SOA
14/14
Languages HTML - XML - Java Script - AJAX-XHTML
Browser Explorer - Mozilla Safari - Chromo
Hardware PC
Language J2EE Java
Application Server Oracle SOA Suite
Database Oracle Database 9i,10i,10g,11i,11g
Operating System OS Independent(Used Windows for application)
HardwareIBM - HP - Sun - Compaq - Dell
C
L
I
E
N
T
Portability PlatformIndependence