The many ways of integrating with Product Data Hub
By Anurag Batra on Jun 03, 2009
Oracle Product Hub provides a full set of business services and data services, both at granular level and at business object level. These include Items creation/update, item change management process support, Items data gathering and data federation.
Oracle Product Hub provides several ways to integrate with external systems, based on industry standards. These are indipendent from the integration platform used in the customer IT environment.• Java Service Interface: A Java service interface is the tool by which Oracle Product Hub employ service oriented architecture (SOA) and Web services to facilitate integration with each other and with third party trading partners. A Java service interface represents a self-describing, stand-alone service component that can ultimately be deployed as a Web service. For more information about administering Java service interfaces using Oracle Integration Repository, see "Oracle® Integration Repository - User's Guide" Administering Java Service Interfaces, page 4-1.
• XML Gateway Message Maps: Oracle XML Gateway comprises a set of services that allows easy integration with Oracle Product Hub to support XML messaging Oracle Product Hub utilizes the Oracle Workflow Business Event System to support event-based XML message creation and consumption. For more information about XML Gateway, see "Oracle XML Gateway User's Guide".
• Oracle Product Hub Business Events: Oracle Product Hub utilizes the Oracle Workflow Business Event System to support event-based XML message creation and consumption. The Business Event System is an application service that uses the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. The Business Event System consists of an Event Manager, which lets you register subscriptions to significant events; and event activities, which let you model business events within workflow processes. When a local event occurs, the subscribing code is executed in the same transaction as the code that raised the event. Subscription processing can include executing custom code on the event information, sending event information to a workflow process, and sending event information to other queues or systems. For more information on Oracle Workflow Business Event System, see "Oracle® Workflow Developer's Guide".
• Web Services: Both Java service interfaces and XML Gateway message maps can be exposed as Web services, which are defined with Web Services Description Language (WSDL) content appropriate to the interface type. For more information about Web services, see "Oracle® Integration Repository - User's Guide" Administering Web Services, page 5-1.
• Oracle Product Hub APIs: A business interface can be based on a PL/SQL package from which you invoke procedures and functions appropriate to a narrowly defined integration goal.
• Java Methods: A business interface can be based on a Java class from which you invoke methods that are appropriate to a narrowly defined integration goal. For the Integration Repository information provided about PL/SQL, see PL/SQL Information, see "Oracle® Integration Repository - User's Guide" page 3-7. For more information on PIM DH APIs, see "Oracle® Product Information Management Implementation Guide".
• Concurrent Programs: In Oracle Product Hub, concurrent processing simultaneously executes programs running in the background with online operations to fully utilize your hardware capacity. A concurrent program runs as a concurrent process and is executed by the Concurrent Manager. Functions performed by concurrent programs are typically XML Publisher (aka Oracle BI Publisher) data-intensive and long-running, such as posting a journal, populating an interface table, and generating an EDI flat file. For the Integration Repository information provided about Concurrent programs, see "Oracle® Integration Repository - User's Guide" Concurrent Program Information, page 3-13. For more information about concurrent programs, refer to the "Oracle Applications System Administrator's Guide - Configuration".
• Interface Views: Interface views are database objects that make data from Oracle Product Hub products available for selection and use by destination applications. For the Integration Repository information provided about interface views, see "Oracle® Integration Repository - User's Guide" Interface View Information, page 3-18.
• Integration Repository: Oracle Integration Repository, an integral part of Oracle Product Hub, is a compilation of information about the numerous interface endpoints exposed by Oracle Product Hub. It provides a complete catalog of Oracle Product Hub business interfaces, and a comprehensive view of the interface mechanisms available. You can use this tool to easily discover and deploy the appropriate business interface from the catalog for integration with any system, application, or business partner. Exposed interfaces types are: Java Service Interfaces, XML Gateway Message Maps, Web Services, PL/SQL Procedures and Functions, Java Methods, Concurrent Programs, Open Interface Tables, Interface Views, etc. For the Integration Repository information, see "Oracle® Integration Repository - User's Guide".
Many thanks to our solution architect Roberto Negro for this information.