Oracle SOA 12c online training

1. Oracle SOA Training Why this courseWhat is SOACourse Contents

2. Agenda • Why should you learn this • What is SOA • What is its market value • Oracle SOA Suite • Course contents • What extra does this course offer

3. Why should you learn this? the next big thing it was low level programming it was BASIC and C it was medium size applications, database it was Java onwards, its enterprise apps middleware • Because it is • In 60s • In 70s • In 80s • In 90s • In 2000 • Now

4. What is Middleware • A software that helps disparate and distributed applications to collaborate with each other • Helps leverage the best-of-breed products • Companies can get more ROI by being able to reuse • SOA is the hottest middleware strategy till date. Examples: • BPEL, OSB

5. “Next big thing ??”, you would wonder, “Can you tell me more? What is SOA all about?” What is SOA?

6. What is Service-Orientated Architecture? • Not a technology or product, more a design approach • “Services” are • Atomic, do not depend on other services run beforehand • Technology and implementation neutral - J2EE, .NET, PL/SQL • Published in directories so that they can be discovered and reused ! • As an architectural style, SOA promotes loose coupling, interoperability assembling of applications from existing processes • From customer's perspective it's about integrating different systems to helps IT deliver solutions that are flexible  Can adapt to changing markets, increasing competitive pressures and evolving customer needs • Services can exchange data using a common platform (OSB) or can be orchestrated using declarative language (BPEL) • Architecture for Oracle Fusion Applications

7. What’s the Big Deal?

8. Why SOA Makes Sense: Technical Benefits • Building business processes is faster and cheaper: • Existing services can more easily be reused • Apps can expose their services in a standard way • Applications can be exposed more easily to diverse clients: • Windows clients, ASP.NET/JSP, PL/SQL, Java etc. • Applications can adapt to change

9. Why SOA Makes Sense: Business Benefits • Applications or business processes might be more easily outsourced • Because they’re well-defined and discrete • Solutions are cheaper to build • Reuse = Reduce cost • Loose coupling = Less impact for any change = Less time to spend changing code due to requirement change

10. Proof ? • “Well, this definitely sounds good … but can you show where SOA has been applied in real world ?”

11. SOA Application Examples in the real world • Data/Apps Integration • File to DB (Inbound Interface) • Information syncing from Oracle EBS to Siebel, PeopleSoft to JDEdwards • Process Portal • Parallel data processing • Content publishing • Workflow • Document Approval • Leave Application • Modern Web Applications • Internet Banking • Contract Management • New Employee Hire • Business Process Management • P2P, O2C • Medicare Eligibility Determination and Enrollment

12. I want to transfer data from legacy system that produces csv output to a database. Use a file adapter to easily read a file. You can also specify the frequency to poll for the file, file name pattern, archive the file after reading and so on. We can validate the data before inserting – verify all the fields conform to a xml schema We can enrich the data before inserting. We can perform routing to different locations - write rules to decide whether to insert the data or not, or to insert in some other DB or create another file SOA Application Examples in the real world – Inbound Interface Design Database Third Party System/ Legacy System Database Third Party System/ Legacy System File Adapter Database Adapter Validate/ Filter Enrich Route SOA Project

13. I want to invite bids for RFQ sent to suppliers. Can I send the RFQ to multiple suppliers in parallel, and then wait for each of the responses Use parallel processing capabilities of BPEL. BPEL provides a construct called FlowN using which you can spawn as many parallel flows as required, on the fly! SOA Application Examples in the real world - Parallel Data Retrieval

14. Parallel flow SOA Project developed using BPEL

15. Once a PO is created, it needs to be approved Approval depends upon PO Amount. If amount is greater than USD10,000, it needs 3 levels of approval else only 2 levels The approvers must be managers of the person submitting. If the approval is not obtained in 2 days, the issue should be escalated to next manager Any document that contains a line item belonging to IT category must be sent as an FYI to the IT department It should be possible to utilize different voting schemes – first approver wins, majority or consensus Use BPEL to orchestrate human task, business rules to achieve this. SOA Application Examples in the real world – Document Approval

16. For a new joinee, we need to Raise request in access provisioning system for email, VPN etc Send filled PDF form for AMEX card Update HR tables Send email to Sodexho team Use BPEL to bind these different system and come up with an application. Identify things that can be done in parallel. SOA Application Examples in the real world - New Employee Hire

17. Market Value • Market value is directly proportional to the number of potential applications • Market value is inversely proportional to number of professionals • In current times, its only your knowledge of new things that can sail you through • Paucity of quality training • Which is good! Because it means less competition • Integration solutions • Vendor specific – TIBCO, JCAPS • Open standard – Oracle SOA • With Oracle emerging as the leader in Apps, Oracle SOA has a secure future

18. “hmm…sounds interesting.. So, what do I need to know technically?”

19. Pre-requisites • Technology wise • Basic understanding of XML, XSL, XSD • Core Java knowledge a plus • Excellent career option for • People familiar with Oracle Apps, Peoplesoft, Siebel • Java, .NET developers • Web developers • Sun JCaps, TIBCO, EAI

20. Hmm..so that is SOA? Well…there is still more to it 20

21. Orchestration of Services • Orchestration of services is required when there is a requirement to combine existing services into new services. • Solution should allow assembling a set of discrete services into an end-to-end process relatively easily (development-wise and conceptually). • There is a solution - BPEL

22. Business Process Execution Language BPEL BPEL: Is a technology to create a program that can invoke web services It presents a very intuitive flow-chart type representation that can be easily understood and modified More technically, it is a markup language for composing a set of discrete services into an end-to-end process flow BPEL Process is a web service, hence has a WSDL document that describes its operation invokes operations described in interfaces in the WSDL of other services. 22

23. BPEL Example – Internet Banking Account Manager Card Manager Services that can be automated Intra-bank transfer Application Server Bank customer calls up at call center Services that require human interaction Requests Complaints ADF Bank customer logs on to website Services provided by other vendors Billing services InterBankTransfer Web Payment Gateway

24. Can services be created for EVERY conceivable system in this world Yes Really !! ?? How do I create a service out of a database ? Use “Adapters” 24

25. Some of the Adapters Available for Oracle SOA Suite… Technology • SOAP • HTTP, HTTP-S • Email – POP3, SMTP, IMAP • FTP, FTP-S • Flat Files • LDAP • JMS • Oracle AQ • IBM MQSeries • TIBCO Rendezvous • Socket Legacy • CICS • IMS/DB • IMS/TM • VSAM • ADABAS • Natural • Tuxedo • CA-Datacom • Screen Scraping • CA-IDMS • C-ISAM,D-ISAM,K-SAM, QSAM • Applications • Oracle Applications • SAP R/3, mySAP • Peoplesoft • JD Edwards • Siebel • Clarify • Lotus Notes • Ariba • AXIOM mx/open • Baan • BroadVision • Clarify • Commerce One • Hogan Financials • i2 Technologies • Lawson • Livelink • Manugistics • Microsoft CRM • Vantive • Walker Interactive • Remedy • Salesforce.com Databases • Oracle 8i and above • IBM DB/2 • Informix • Clarion • Clipper • Cloudscape • DBASE • Dialog • Essbase • FOCUS Data Access • Great Plains • Microsoft SQL Server • MUMPS (Digital Standard MUMPS) • Navision Financials (ODBC 3.x) • Nucleus • Paradox • Pointbase • PROGRESS • Red Brick • RMS • SAS Transport Format • Sybase • Teradata • Unisys DMS 1100/2200 • UniVerse

26. Oracle SOA Suite • Provides “components” for designing, deploying, and managing “composite applications”. • “Composites” enable you to easily assemble multiple technology components into one SOA composite application • “Components” • BPEL • Mediator • Human Workflow • Business rules • Adapters (FTP, DB, AQ, JMS, MQ, Apps, Siebel, PSFT…) • BAM

27. What are we learning in this course In this course we are learning the most important offerings in Oracle SOA Suite BPEL, Adapters, Mediator, OBR, Human Workflow OSB Introduction Other things in Oracle SOA Suite BAM – real time monitoring, KPI etc OWSM – provide security to web services 27

28. Installation • Softwares • Oracle Weblogic Server • Oracle SOA Suite 11g / 12c • Oracle OSB 11g / 12c • Oracle JDeveloper 11g • Oracle 10g XE or Oracle DB 10g or Oracle DB 11g • System Requirements • P-IV or equivalent processor • 40GB HDD • 6GB RAM • OS – XP, Vista, Windows 7, Linux

29. D E M O N S T R A T I O N Oracle Fusion Middleware Integration

30. Course Objectives • After completing the course, you should be able to do the following: • Covered the most important topics from practical point of view • Covered most of the exam topics for Oracle Certification • Learnt installation of SOA Suite, structure of all directories • Created programs using BPEL, Mediator, Workflow, business rules

31. Recap • What are we learning in this course - Oracle SOA • Oracle SOA • Enterprise Service Bus • BPEL • Software Details • Demo • Course Objectives • Some differentiators

32. Thank you TEJA