Oracle Agile PLM Integration

Oracle Agile PLM Integration

Last update July 2014

Overview

Oracle Agile enables integrate Agile PLM with other business systems (ERP, CRM, etc) and build custom applications to access, or extend Agile PLM functionalities.

Oracle provides many tools to support Agile PLM integration. In this article, we are going to review those tools and take a look on how they are used for integration. We will keep updating based on the latest Oracle Agile PLM user guides.

First of all, let’s categorize those tools into two types, programmatic and non-programmatic tools.

Programmatic tools include:

  • Oracle Agile Software Development Kit (SDK)
  • Oracle Agile Web Services
  • Oracle Agile Integration Services (AIS)

Non-programmatic tools mainly include:

  • Oracle Agile Import
  • Oracle Agile Export
  • Oracle Agile Content Service (ACS)

Usually, programmatic tools are required for integration or customization and sometimes non-programmatic tools might be used as well to support integration.

Oracle Agile Software Development Kit (SDK) 

It includes three parts, Agile API, Process eXtensions and Event Framework.

Agile API – A Java API with interfaces that expose Agile business objects. Usually, it can be used to implement an interface (customization) between Agile PLM and external systems to transfer and process data among systems as shown in below figure.

integration_api

Process eXtensions (Custom PXs) – This framework enables Agile PLM customers extend the functionality of Agile PLM Clients by adding external reports, user-driven and Workflow-driven custom actions, custom tools, and custom autonumber sources. These PXs are implemented using the Java programming language. They are triggered through Agile actions or called back from external reports. Please refer to the following figure for a general case.

integration_px

Event Framework – This framework supports Java process extensions (Java PXs), and Script process extensions (Script PXs). Similar to Custom PXs, they make it easier for PLM customers to extend the functionality of PLM Clients to manage events. Java PXs are implemented using Java and Script PXs are implemented using a scripting language called Groovy. Compared with PX framework, it enables more trigger points which are called events in Agile.

integration_event

Oracle Agile Web Services 

Oracle’s Agile Web services use industry standard core technologies and expose all key PLM functionalities in the following services. Agile PLM OOTB Web Services support functionalities provided by PLM solutions, such as PC, PQM, PCM, PPM, PG&C, EC and RMW. Besides OOTB web services, user can extend and customize own Agile web services. Oracle Agile web services can be consumed by external applications which might not be implemented by Java but any language supporting web services.

integration_ws

Oracle Agile Integration Services (AIS) 

AIS is a collection of predefined Web Services in the Agile Integration framework that enable communication between PLM server and  disparate systems. It actually provides programmatic interface based on Web Services to specifically access Oracle Agile Import/Export functionalities. integration_ais

Oracle Agile Import

The Agile Import Wizard is the tool used to import data (from external systems) into the Agile PLM system. The supported formats include Excel workbooks (XLS), Delimited text files (TXT), Product Data Exchange Packages (PDX), Agile XML (or aXML) files.

Oracle Agile Export

The Agile Export supports extracting data from selected objects and exporting the data. The output file can Microsoft Excel, comma-delimited text file (CSV), aXML, or PDX package formats. Client usually can either e-mail or FTP the export output file to a supply chain partner.

Oracle Agile Content Service (ACS) 

ACS is a process for transferring data to other Agile PLM solutions or to any other external system. It can be configured to automatically publish the Item Master, BOM, and AML changes during any phase of the product lifecycle to multiple destinations. ACS can support transfers to multiple destinations and transfer protocols, including a file, FTP, HTTP(S), JMS queue, and Agile system. File type of the transfer file can be PDX or aXML. A general case is to use ACS to push data to a FTP site which can be monitored by external applications.