Thursday, January 24, 2013

Integration Broker basics for the PeopleSoft developer

In the past year we have answered a lot of questions on OTN Forum on the Integration Broker and how to work with web services in PeopleSoft.

We have decided to share with you a training that we have written on the basics of Integration Broker and frequent integration scenarios that a PeopleSoft Developer is faced with. The training is written using PeopleSoft HCM 9.1/PeopleTools 8.51, but still valid for PeopleTools 8.52.

The training can be downloaded using the following link and some sources needed for the training can be downloaded using the following link.

This training also uses Non-PeopleSoft tools like:
The training uses JDeveloper for XSL mappings. The training does not cover how to setup JDeveloper for PeopleSoft, see this link on how to set this up.

This training has over 80 pages and covers the following subjects:

Setup Integration Broker

Setting up basic configuration like Integration Gateway, Pub/Sub Servers, Default Local & Internal nodes, Domains, Logging

Provide Component Interface Service

Providing a CI Based Service and testing this through SoapUI and PeopleCode

Call external service

Create a Mock Service in SoapUI to simulate an external service and write PeopleCode to call an external service

Custom PeopleSoft Application Class Service

Creating a service in PeopleSoft from scratch using an Application Class handler and testing this through SoapUI and PeopleCode

Translations

Creating a transformation program using the JDeveloper XSL Mapper

Application Engine Handler

Exposing an Application Engine as a service operation handler


Note: Writing code is dependent on the scenario and even more writing code is personal. The code used in this training is a guideline for you and definitively not the only way to achieve integration. Write code that you are comfortable with and write code that is readable for all.

31 comments:

  1. Excellent resource. Thanks.

    ReplyDelete
  2. Thank you very much for this helpful resource.

    ReplyDelete
  3. Thanks for providing these links for training. Integration Broker has some complexity that's unique.

    ReplyDelete
  4. Jason6:08 AM

    Great doc, thanks.

    ReplyDelete
  5. Michael D. Higgins9:33 PM

    Excellent Part 1. For Part 2, how about REST/WADL services? Working on those right now and Oracle cannot get me going with my first one.

    ReplyDelete
  6. Jackeline Vallejo8:15 PM

    This is great training material, Thanks

    ReplyDelete
  7. Manjunath Maller8:31 PM

    Excellent Information

    ReplyDelete
  8. Sreeni Reddy12:32 AM

    Thank you! I was able to configure the Gateway and nodes with these instructions.

    ReplyDelete
  9. Madan Honap4:56 PM

    Excellent, i have done some project on the same , but using xml file and ci , this is really good consolidated info.

    ReplyDelete
  10. Thank you so much for your kind service to the community. FYI - page 11 has a screenshot with an actual url that you prob intended to blur based on the pattern I see with the other screenshots.

    ReplyDelete
  11. Jigar7:23 PM

    Thank you. Appreciate your efforts.

    ReplyDelete
  12. Eh oops, thank you for pointing that out Sam :) I changed it and uploaded a new version, so if everybody could delete their old one and download the new version ;)

    ReplyDelete
  13. Hi john,

    great post..... but the line which says "The training can be downloaded using the following link and some sources needed for the training can be downloaded using the following link." the link is not accessible.Could you please check and tell me the right link for downloading basic of IB will be really a big help.

    ReplyDelete
  14. Manikanta4:49 PM

    Hi John
    I am not able to find any document guide in any of the link mentioned in the article Coup you please help me out...........

    ReplyDelete
  15. PS Novice9:40 PM

    Hi John
    I am not able to find any document guide in any of the link , could you please help. Thanks.

    ReplyDelete
  16. My apologies, for some reason the place I put the files changed their URL's. I'll place them on our own server later today when I can reach the files from another location.

    ReplyDelete
  17. The attachments are now updated to a better location :)

    ReplyDelete
  18. anvesh8:52 AM

    where is the document? i am not able to find

    ReplyDelete
  19. anvesh8:54 AM

    can any body mail me the document at anveshguntu@gmail.com

    ReplyDelete
  20. krishna1:25 PM

    Thank you, a very very helpful.

    ReplyDelete
  21. Hi
    Today I copied project from file and my application configurations are People Tools 8.51 and HCM 9.1 and Database Oracle 11g.But when I copied project. I was received below errors. Can you please suggest me.Why I received these below errors?

    Definition Name: IBCOURSE_AEH not copied, not found on source database. (62,18)
    Definition Name: IBCOURSE_XSL not copied, not found on source database. (62,18)
    Application Engine Sections Definition Name: IBCOURSE_AEH.MAIN not copied, parent definition does not exist in target database (62,33)
    Application Engine Sections Definition Name: IBCOURSE_XSL.MAIN not copied, parent definition does not exist in target database (62,33)

    Application Engine SQL Definition Name: IBCOURSE_AEHMAIN Runcntl S.1 not copied, parent definition does not exist in target database (62,33)

    Application Engine PeopleCode Definition Name: IBCOURSE_AEH.MAIN GBLdefault 1900-01-01.GetMSG.OnExecute not copied, parent definition does not exist in target database (62,33)
    3-09-03-09.11.53 (62,21)

    Definition Name: IBCOURSE_XSLMAIN Step01 X.6 not copied, not found on source database. (62,18)
    XSLT Application Upgrade Copy ended: 2013-09-03-09.11.53 (62,21)

    Thanks in advance

    Please help me out

    ReplyDelete
  22. Nouamane8:16 PM

    Just go to insert > definitions into project ..
    select the app engine and select also the related definitions in the right

    nouamane.larhlimi[at]gmail

    ReplyDelete
  23. Hi How can i get the document

    ReplyDelete
  24. Found it on the first link. I was looking on the second link. Thanks so much!

    ReplyDelete
  25. Hi Hakan,

    Could you please shed some light on how integration broker behaves in a Disaster Recovery Scenario?

    Thanks,
    Pankaj.

    ReplyDelete
  26. Nilgun2:19 PM

    Thank you very much. This document and project is wonderful :)

    ReplyDelete
  27. vinusaravanan k3:30 PM

    Hi All,
    I couldn't find the doc. Can anyone forward the same to vinusaravanan86@gmail.com
    Thanks

    ReplyDelete
  28. Satheesh kumar S5:41 AM

    Hi All

    i am not able to see the document can someone forward to satheeesh.y4k@gmail.com because i hope it should be very usefull.

    Thanks
    Satheesh

    ReplyDelete
  29. Thank you, the document is very resourceful.

    ReplyDelete
  30. Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Oracle Training in Chennai

    ReplyDelete
  31. Is there any difference between testing a Synchronous CI based web service (where third party integration is involved) using SOAPUI and handler tester (Peoplesoft Delivered), as for me handler tester was working fine, but the same was being tested with SOAPUI, the WSDL was not working.

    ReplyDelete