mif workshop raquel bortoluci sep 2012
TRANSCRIPT
![Page 1: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/1.jpg)
© 2011 IBM Corporation
®
Integration Framework Integration Framework
![Page 2: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/2.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
History
Integration has been an integral part of the Enterprise Asset Management system Maximo for more than 10 years.
The first integration used PL/SQL with triggers and store procedures. It was called the MIG (Maximo Integration Gateway).
When Maximo began conversion to Java. The JMIG (Java MIG) was implemented in the Maximo version 4.x.
When Maximo was fully implemented in Java the JMIG was renamed MEA (Maximo Enterprise Adapter) for Maximo 5 and 6.
With the acquisition of MRO Software by IBM the integration was renamed Integration Framework and is part of the Tivoli process automation engine used for several IBM applications
![Page 3: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/3.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Introduction: Maximo Integration Framework
3
Integration
Framework
External
System
Application
Synchronization/
Integration of data
The integration framework is a set of applications that help you to integrate the system to your external applications. You also can create business flows between the system and your external applications.
![Page 4: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/4.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Asynchronous processing means the two systems do not have a real-time connection. The transaction is sent from the application to a queue then from the queue to the external system. The same thing happens for transactions coming from the external system: the transaction is sent from the external system to a queue then from the queue to the application.
Synchronous processing means the two systems have a real-time connection. The transaction is sent from the application directly to the external system. The same thing happens for transactions coming from the external system: the transaction is sent from the external system directly to the application.
Asynchronous X Synchronous
![Page 5: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/5.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Cqin - Continuous inbound
Cqinerr - Continuous inbound error
Sqin - Sequential inbound
Sqout - Sequential outbound
Queues - definition
![Page 6: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/6.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Properties: The Integration Framework system properties start with mxe.int.xxx.
mxe.int.globaldir: Specifies the global directory to install Service Request Manager.
mxe.int.webappurlSpecifies the URL of the main installation to Service Request Manager.
![Page 7: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/7.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 8: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/8.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Object Structure: Defines the content of a message sent to an external system or the content of a message received from an external system.
![Page 9: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/9.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Activity: Create a Object Structure for Job Plan
• Enter Object Structure and Consumed By
• Enter Source Objects: JOBPLAN and JOBTASK
• Exclude/Include fields
![Page 10: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/10.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 11: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/11.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
A publish channel is the pipeline for sending data asynchronously from the system to an external system.
The records can go through a series of transformation layers using rules (no programming), Java or XSL. The result is an external record that is sent to the external system in a format the external system understands.
![Page 12: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/12.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 13: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/13.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Activity: Create a Publish Channel
• Enter Publish Channel name
• Attach the object created previously
• Enable Listener
![Page 14: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/14.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 15: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/15.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
The enterprise service is a pipeline for querying system data and importing data into the system from an external system
The external record can go to a series of transformation layers to convert it to the format that the application using Integration Framework understands.
![Page 16: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/16.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 17: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/17.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Activity: Create an Enterprise Server
• Enterprise Service name
• Attach the object created previously
![Page 18: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/18.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 19: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/19.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
End point: Modes that you use to communicate with external applications.
Activity: Edit the End Point
• End point name
• Handler: XMLFILE
• Properties: PRETTYPRINT and FILEDIR
![Page 20: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/20.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 21: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/21.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 22: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/22.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Activity: Create an External System
• Enter System name
• End Point: edited previously
• Enter queue values
• Attach the Publish Channel (enable it)
• Attach the Enterprise Server (enable it)
• Enable the External System
![Page 23: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/23.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 24: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/24.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
A cron task, which is a facility in the Tivoli process automation engine that enables the scheduling of jobs, checks the queue and sends any records in the queue to the external system.
Activity: active JMSQSEQCONSUMER crontask
Sequencial queues are processed using the cron task
![Page 25: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/25.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 26: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/26.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
The continuous queues are processed using instances of a Message Driven Bean that is comes with the Integration Framework.
The MDB is a java class that is called to receive a message passed to it from the JMS queue. This process is like trigger: as soon as a message arrives in the queue the MDB is called and a message is passed
..\SMP\maximo\applications\maximo\mboejb\ejbmodule\META-INF
ejb-jar.xml
ibm-ejb-jar-bnd.xmi
![Page 27: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/27.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 28: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/28.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Activity: Perform an outbound operation
• Go to external system → publish channel and export it.
Verify XML file
• Listener
Create a new job plan
Verify XML file
![Page 29: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/29.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Activity: Perform an inbound operation
• Change the XML file in order to do the import
Go to external system → enterprise service, the enterprise service for
the job plan and import it.
• Cron task – XMLFILECONSUMER
![Page 30: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/30.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
ACTION Column
![Page 31: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/31.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Using Interface Interface Tables
Interface tables are used for outbound or inbound transaction.
Outbound transactions: The message is sent to the outbound queue and then the router sends the transaction to the end point for interface tables.
Inbound transactions: An external system writes the data to interface tables and a polling cron task reads from the interface table, converts the data to XML, and writes the data to the inbound queue.
![Page 32: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/32.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Outbound
Transactions
![Page 33: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/33.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Inbound
Transactions
![Page 34: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/34.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Object Structure for Interface Table
Should support Flat Structure
With no alias conflict
![Page 35: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/35.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
The Interface Table should be set in Publish Channel and in
the Enterprise Service
![Page 36: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/36.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
The Interface Tables can be local or remote.
![Page 37: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/37.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Creating Interface Tables
![Page 38: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/38.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
The cron task reads from the interface table, converts the data to XML, and writes the data to the inbound queue
![Page 39: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/39.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Perform outbound and inbound operations using Interface Tables
![Page 40: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/40.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Web Services Concepts
Web services is a distributed computing approach that is language and platform independent. It does not require a specific environment and it is not dependant on a specific language.
Web services are loosely coupled. They expose only the external interfaces.One of the most important characteristics of Web Services is that they are based on Standards
Data is represented in XML which is a standard for data representation.Web services are self describing and discoverable using WSDL and UDDI.Web Services use the SOAP standard protocol of communication.
![Page 41: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/41.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
A transaction can be sent asynchronously through the queue to a Web service end point or a transaction can be sent with a synchronous call to the end point.
The asynchronous case requires configuring of the end point and assigning the end point to an external system or a publish channel.
Synchronous processing requires the creation of a Java class to call the end point. The Java class can be executed from a menu action, from a button in the current application, or from customization in an attribute validation, or Mbo customization.
Integation Framework for Web Services
![Page 42: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/42.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Creating Web Service from Object Structure
For the object structure the process is always synchronous. In these two cases there is not a transformation layer. That means that the XML transaction cannot be modified before it is processed by the object structure
![Page 43: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/43.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Deploying and Verifying WSDL
Global Dir
![Page 44: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/44.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
End Point
![Page 45: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/45.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Query example
![Page 46: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/46.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Create example
![Page 47: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/47.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 48: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/48.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
![Page 49: MIF Workshop Raquel Bortoluci Sep 2012](https://reader033.vdocuments.us/reader033/viewer/2022052315/554bdde4b4c905ac708b55c7/html5/thumbnails/49.jpg)
IBM Software Group | Lotus software
IBM Software Group | Tivoli software
IBM Confidential – For Internal Use
Only
Questions