1 / 17

SAP Integration with Oracle 11g Muhammad Raza Fatmi

SAP Integration with Oracle 11g Muhammad Raza Fatmi. Web Service. A Web service is a method of communication between two electronic devices over the World Wide Web .

emilie
Download Presentation

SAP Integration with Oracle 11g Muhammad Raza Fatmi

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP Integration with Oracle 11gMuhammad Raza Fatmi

  2. Web Service A Web service is a method of communication between two electronic devices over the World Wide Web. The term Web services describes a standardized way of integrating Web-based applications using the XML, SOAP, WSDL and UDDIopenstandards over an Internet protocolbackbone. XML is used to tag the data, SOAP is used to transfer the data, WSDL is used for describing the services available and UDDI is used for listing what services are available. Used primarily as a means for businesses to communicate with each other and with clients, Web services allow organizations to communicate data without intimate knowledge of each other's IT systems behind the firewall

  3. SOAP SOAP, originally defined as Simple Object Access Protocol, is a protocol specification for exchanging structured information in the implementation of Web Services in computer networks. It relies on Extensible Markup Language (XML) for its message format, and usually relies on other Application Layer protocols, most notably Hypertext Transfer Protocol (HTTP) and Simple Mail Transfer Protocol (SMTP), for message negotiation and transmission.

  4. Web Services in Oracle 11g Web services are becoming the preferred way to expose data to client applications. http://www.liberidu.com/blog/2007/08/10/oracle-11g-how-to-enable-native-wsdl-services/

  5. Business Process Management Integration Tools Packaged Integration XML Services Message Queuing Connectivity Oracle: Complete e-Business Integration Infrastructure OracleIntegration Services Standards

  6. Enterprise Application IntegrationIntegrate Oracle and Non-Oracle Applications OracleApplicationAdapters Non-OracleAdapters SAP R/3 OracleE-Business Suite BusinessProcessManagement ApplicationAdapters XML Gateway XML/AQAdapter SemanticTransformation LegacyApps MessageGateways OAG XML / AQ AppsDatabase Messaging Oracle DBAdapter Other SDK AS Triggers / SPs

  7. How to use Web service in Oracle 11g • Native Oracle XML DB Web Services • Consuming Web Services using the UTL_DBWS package • Consuming Web Services using the UTL_HTTP package • Calling a Web service from Oracle Forms 11g • Oracle Application ServerAdapter for SAP R/3 https://forums.oracle.com/forums/thread.jspa?messageID=1819753&#1819753

  8. Native Oracle XML DB Web Services Oracle 11g Database makes the conversion of existing PL/SQL code into web services easier than ever by providing Native XML DB web services. With some simple configuration, this functionality exposes PL/SQL code, code as web services. http://www.oracle-base.com/articles/11g/native-oracle-xml-db-web-services-11gr1.php http://www.liberidu.com/blog/2007/08/10/oracle-11g-how-to-enable-native-wsdl-services/ http://docs.oracle.com/cd/B28359_01/java.111/b31225/chtwelve.htm http://docs.oracle.com/cd/B14117_01/java.101/b12021/callouts.htm

  9. Consuming Web Services using the UTL_DBWS package Consuming Web Services using a basic SOAP implementation using the UTL_DBWS package, which is essentially a PL/SQL wrapper over JPublisher. http://www.oracle-base.com/articles/10g/utl_dbws-10g.php http://steveracanovic.blogspot.com/2009/12/11g-database-webservice-callout- steps.html http://www.joords.nl/index.php?file=kop15.php https://forums.oracle.com/forums/thread.jspa?messageID=10448611&tstart=0 http://frohikyoracle.tumblr.com/post/56310959/consuming-web-services-using-pl-sql

  10. Consuming Web Services using the UTL_HTTP package Making your application logic reusable helps you achieve efficiency and consistency within your organization. And Web Services are one way to provide reusability—creating an easily accessible way to leverage the code within your enterprise, as well as outside it. You can easily create Web Services with the Oracle Application Server, but you may wonder how to call a Web Service from your PL/SQL code. Using the utl_http package supplied by Oracle, you can call Web Services hosted either across the globe or anywhere on your intranet by making HyperText Transfer Protocol (HTTP) calls to them. The UTL_HTTP package makes Hypertext Transfer Protocol (HTTP) callouts from SQL and PL/SQL. You can use it to access data on the Internet over HTTP. http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/u_http.htm http://martin-mares.com/2010/08/oracle-db-consume-wsdl-webservice-in-plsql/ http://www.sqlquery.com/dbm0415.htm http://www.rampant-books.com/t_hunter_using_utl_http_and_oracle_wallet_to_establish_secure_url.htm http://www.oracle-base.com/articles/9i/consuming-web-services-9i.php http://wiki.sdn.sap.com/wiki/display/XI/Triggering+webservice+from+Oracle+Database+with+UTL_HTTP+supplied+package https://forums.oracle.com/forums/thread.jspa?threadID=2455998&tstart=1

  11. Calling a Web service from Oracle Forms 11g Oracle Forms, a component of Oracle Fusion Middleware, is Oracle's long-established technology to design and build enterprise applications quickly and efficiently. Oracle remains committed to the development of this technology, and to the ongoing release as a component of the Oracle platform. This continuing commitment to Forms technology enables you to leverage your existing investment by easily upgrading and integrating existing Oracle Forms applications to take advantage of web technologies and service oriented architectures (SOA). http://www.oracle.com/technetwork/developer-tools/forms/webservices-forms-11g-094111.html http://www.oracle.com/technetwork/developer-tools/forms/overview/index.html http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_14/jdtut_11r2_14.html

  12. Oracle Application Server Adapter for SAP R/3 Oracle Application Server connects to an SAP system through Oracle Application Server Adapter for SAP R/3 (OracleAS Adapter for SAP). OracleAS Adapter for SAP provides connectivity and carries out interactions on an SAP system. http://docs.oracle.com/cd/E14571_01/doc.1111/e17054/toc.htm http://docs.oracle.com/cd/B10464_05/integrate.904/b10299/intro.htm http://docs.oracle.com/cd/E14571_01/doc.1111/e17656.pdf http://www.oracle.com/technetwork/middleware/adapters/documentation/index.html http://docs.oracle.com/cd/E14571_01/doc.1111/e17656.pdf

  13. Adapter Architecture: A2A Implementation • Business Events • Transformations • Routing Rules Applications Repository SAP Adapter Peoplesoft AQ Agent Bridge Siebel CommonView AppView Ariba To Hub C1 Transport and/orApplication Specific(Manages Conversation) Other Metadata DrivenTransformation

  14. Adapter Features OracleAS Adapter for SAP is a remote function call adapter that provides a means to exchange real-time business data between SAP R/3 systems and other application, database, or external business partner systems. OracleAS Adapter for SAP uses XML messages to enable non-SAP applications to communicate and exchange transactions with SAP using services and events. The role of services and events is outlined. Services and events are described as follows: • Services: Enable applications to call an SAP business object or business operation. • Events: Enable applications to access SAP data only when an SAP business event occurs.

  15. Integration with SAP You can use OracleAS Adapter for SAP to initiate an SAP business process, such as add/update account, or you can use the adapter as part of an integration effort to connect SAP and non-SAP systems. BAPI and RFC are called synchronously by the adapter and always return data (either technical error information or a well-formed response document). IDocs are processed asynchronously. • The adapter is bidirectional and can process an event in SAP by receiving RFC and • IDocs directly from SAP. The output sent by SAP can be in any of the following forms: • An RFC request, for example, RFC_CUSTOMER_GET • A BAPI request, for example, BAPI_COMPANYCODE_GETLIST • An IDoc

  16. SummaryOracleAS Integration • Single product solution for A2A, B2B, and Web Services integration • Fully integrated feature of OracleAS • Open, standards-based architecture • Complete general-purpose enterprise integration infrastructure • Best solution for Oracle E-Business

  17. Q & Q U E S T I O N S A N S W E R S A

More Related