oracle ebs free web service integration tools

E-Business Suite comes packed with great tools. Learn more about the free web service integration tools included in the Oracle software you already own. Check out our free whitepaper for more information: http://www.smartdogservices.com/whitepapers/free-web-service-integration-tools-included-in-ebs/

1. Your friend in the business. How to Use The Free Integration Tools That Come with Oracle E-Business Suite

2. Topics for Today Problem Statement Overview of Integration Options EBS Web Service Integration Web Service Demonstration Questions Agenda Customers that run the E-Business Suite have been challenged trying to get these systems to work seamlessly with internal and external systems. This webinar talks about the integration tools that are available in Oracle EBS that you can use today and in the future.

3. EBS is Your Primary ERP System You run other systems Disparate Technologies Inside and Outside the Firewall SaaS and In House Business Needs have Changed Need them to Talk to One Another Need these systems to work well together as a single system Problem Statement Custom System ? ? ? ? ? ? How do we get them to all work together?

4. What are my Options? Point-to-Point This is the traditional method of sending integrating two systems through file transfers and the loading of data for a specific purpose. Since many SaaS solutions do not support this method, it is not an option for this discussion. Option 1 – EBS SOA Gateway (SOAP & REST Web Services) EBS SOA gateway provides hosting for “out-of-the-box” Web services from Oracle E-Business Suite . It provides capable integration functionality, but only for a defined set of integration points. Also, there are licensing changes that will be in effect as you move your environment to 12.2. Option 2 – Oracle RESTful Data Services (ORDS) REST is fast becoming the de facto standard for providing data for easy consumption by mobile apps, web apps as well as for in house and cloud based applications. ORDS is a new product from Oracle which allows us to quickly and securely host REST web services Option 3 - Middleware (Full SOA Integration) Full SOA integration through middleware is the most robust and comprehensive solution for developing an integrated application architecture.

5. Comparison Chart Scenario EBS SOA Gateway ORDS Middleware Solution Limited orchestration required Limited routing or queuing required Web Services primarily REST based Limited orchestration required Limited routing or queuing required Need to host SOAP web services Significant orchestration required Need for off-line queuing and throttling Need for routing of messages Multiple consumers of the data No Cost Option for 12.2.X * SOA Gateway REST is No Cost SOAP is Not No Cost for 12.1.X Yes Yes Yes No Maybe Maybe Maybe Yes No Yes No No Yes Yes No

6. Standards Based REST, SOAP (http, https) Real-Time Integration Immediate results Interoperable Platform and Language Agnostic Versatile & Accessible Easier to consume and access Promote Re-Use One service consumed by multiple clients Mobile, Web Site, Cloud Saas System New Technology Google, PayPal, AWS, Twitter SaaS systems primarily support web services Options 1&2 – Simple SOAP & REST Services

7. Option 3 – Middleware Solution Routing Mediation Monitoring Connectivity Transformation Business Rules Service Orchestration

8. Can be Overkill Expensive Complex to Manage S pecialist R esources Option 3 – Middleware Solution

9. How can I integrate my systems today (without spending a fortune) and still enable the business to grow in the future? Down T he Road

10. Gain immediate benefits Consume data from other systems Expose your data to SaaS systems, other corporate systems, mobile applications etc . Start with Simple Web Services Depending on your Integration requirements, move to full Middleware Integration Preparation for middleware integration Services 100% re-usable in middleware solution Build your service catalog Ease into middleware integration solution Service Enablement Strategy: Option 1 and/or 2 – depending on your needs

11. EBS Web Service Integration Options

12. No cost option in 12.1.3. Note : For 12.2+ you need a separate license for SOAP based services. Oracle Integration Repository Large repository of existing services exposed by applications within EBS Produce and consume web services REST and SOAP Build in PL/SQL or Java Integrated SOA Gateway

13. SOA Gateway Scenario EBS to RightNow SOA Gateway SOAP Service Create Customer Get Customer RightNow calls EBS to create new customer RightNow calls EBS to get customer details Build in PL/ SQL Expose as Web-Service Register in Repository

14. No C ost O ption Host REST web services Consume SOAP & REST Build in PL/SQL Authenticate (oauth2) Authorize via PL/SQL Json & XML payloads Certified with R11 & R12 5 click Web Service! Oracle REST Data Services

15. ImageNow calls Service to create AP invoice in EBS Service hosted by ORDS ORDS Scenario EBS & ImageNow ORDS Exposes URL to Client Applications Accepts inbound http request Parses http variables into PL/SQL Executes PL/SQL block (Web service program logic) Returns http response back to client (200, 400 etc.)

16. ORDS Scenario REST Service Anatomy Module Collection of related resources Template / Resource Object with data , relationships to other resources and methods Handler/Method Action to perform on Resource, GET, POST, PUT etc.

17. ap /invoice Resource (Method: POST) URI (portion of http URL) ap /invoice Method (GET, DELETE, PUT, POST ) Source Code Type PL/SQL MIME Type / Message Format XML PL/SQL Block / Web Service Program Logic ORDS Scenario

18. ORDS Scenario Sample REST Web Service Call

19. Demonstration

20. Comparison Chart Scenario EBS SOA Gateway ORDS Middleware Solution Limited orchestration required Limited routing or queuing required Web Services primarily REST based Limited orchestration required Limited routing or queuing required Need to host SOAP web services Significant orchestration required Need for off-line queuing and throttling Need for routing of messages Multiple consumers of the data No Cost Option for 12.2.X * SOA Gateway REST is No Cost SOAP is Not No Cost for 12.1.X Yes Yes Yes No Maybe Maybe Maybe Yes No Yes No No Yes Yes No

21. Things to Remember Customers that run EBS have powerful integration tools available to them at no additional cost. These tools can provide a simple and robust integration to SaaS and other external systems. These tools can be used to quickly build connectors between E-Business Suite to third party or SaaS Solutions. Once you build these connectors, they can be reused later as your environment changes and you evolve to a fully integrated application architecture. “Let’s Get Started”

22. Let’s get started.