Vishal Modi

Architecture of PeopleSoft Adapter:

The BizTalk PeopleSoft Adapter is based on the BizTalk Server Adapter Framework. More info: How the Adapter Is Designed: The Adapter Framework. The PeopleSoft adapter basically communicates with the PeopleSoft Component Interfaces via the PeopleSoft JOLT protocol (over TCP/IP). The adapter communicates with PeopleSoft system by receiving a XML message which is later encapsulated into a SOAP request using the PeopleSoft psjoa classes. With this connection we can get the metadata to call into the existing Component Interfaces and generate the API schemas and use them within BizTalk Server for mapping, orchestrations at design time and runtime. According to Microsoft, if you need to have PeopleSoft Enterprise to initiate the call to BizTalk Server, they recommend using the HTTP adapter. More info : Creating a PeopleSoft HTTP Host and Port

More detailed information on PeopleSoft Adapter Architecture can be found on MSDN.

Requirements for PeopleSoft Adapter:

• BizTalk Server Enterprise Adapters installed and configured and of course BizTalk Server 2010 installed and configured.
• Java Development Kit (JDK) 1.4.2 or later.
• Access to the PeopleSoft Application Designer to deploy Component Interface. The PeopleSoft Application Designer does not have to be on the BizTalk server.

Installing BizTalk Server Enterprise Adapters:

• Open the BizTalk Server 2010 setup and click Install Microsoft BizTalk Adapters.

• Install Adapters packs for all the 4 Steps.

• This concludes the installation the BizTalk Adapters for Enterprise Applications. Don’t worry about the warning in Step1.

Configuring PeopleSoft Adapter for BizTalk Server:

• Open BizTalk Server Administration Console –> Platform Settings –> Adapters –> Right Click –> New –> Adapter

• In the new window, choose name as PeopleSoft and from the adapter dropdown choose PeopleSoft Enterprise. Click Apply –> OK and restart your Host Instances. Now you can see the PeopleSoft Adapter as the installed BizTalk Adapters.

• This concludes the configuration of PeopleSoft adapter on the BizTalk side. Next is to create a Component Interface on the PeopleSoft side though which BizTalk PeopleSoft adapter can communicate.

Configuring a New Component Interface for PeopleSoft:

Environment

- PeopleSoft PeopleTools 8.52

- PeopleSoft Enterprise HRMS 9.0

- Oracle Web Logic Server 10.3.4.0

- Tuxedo 10gR3

- JRockit JDK R28.1

Step1: Creating a New Component Interface:

• Go to the Server where you have PeopleSoft Enterprise Application installed.
• Go to Start –> All Programs –> PeopleSoft (can differ according to version you have installed) –> Application Designer. Log in with your PeopleSoft user ID.

• On the File menu, click New. In the New dialog box, select Component Interface.

• Click Select on the next window and it will show list of current CI. Select any Component Interface which does not have any keys. After you select the appropriate component, you see a message asking if you want the fields exposed in the selected component to become the default properties of the Component Interface.

• Click Yes to confirm the Default Property Definitions or No if you don’t want any properties initially created.

• On the File menu, click Save As. In File Name, enter GET_CI_INFO, and then click OK.

• Right-click any method of your new Component Interfaces, and then click View PeopleCode. A new blank window will pop up.

• Copy and paste the contents of <PeopleSoft installation directory>\PeopleSoft Enterprise\config\get_ci_info.pc into the window. Open the file in notepad and copy the contents of it.

• On the File menu, click Save. You now have a new Component Interface.
• Just to verify if you perfomed the steps correct. Close the Application Designer. Reopen Application Designer and Log in with your PeopleSoft user. Go to File –> Open –> Component Interface and browse to GET_CI_INFO and open it. You should see something similar as shown below.

Step2: Set the PeopleSoft Component Interface security:

In the below steps, the Permission lists, Roles and User Profile are just selected randomnly to display the steps. Please select the appropriate Permission List, Roles and User Profile according to your use and accessibility. Highly recommend setting up this security with a PeopleSoft Administrator person or a PeopleSoft expert.

• Sign in to PeopleSoft Web Portal.

• Select PeopleTools, Security, Permissions & Roles, Permission Lists.

• Click Search, select the relevant Permission List, and click the appropriate list hyperlink. The Permission List pane opens on the right.

• Click the right arrow next to the Sign-on Times tab to display the Component Interfaces tab. Click the Component Interfaces tab.

• Click the + button to add a new row to the Component Interfaces list.

• Select the GET_CI_INFO component interface and click Edit.

• Click Full Access (All) to set the methods to Full Access. Click OK.

• Scroll down to the bottom of the Component Interfaces window and click Save.

• Select PeopleTools, Security, Permissions & Roles, Roles. Click Search, select the relevant Role and click the appropriate list hyperlink.

• The Role pane opens on the right. Click the Permission List tab.

• Click the + button to add a new row to the Permission List.

• Select the GET_CI_INFO Permission List.

• Scroll down to the bottom of the Roles window and click Save. [Save as GET_CI_ROLE]

• Select PeopleTools, Security, User Profiles, User Profiles.

• Click Add New Value, type BizTalk into the text box, and click Add to display the General tab

• Select a Symbolic ID in the drop-down box.

• Type a Password and Confirm Password.

• Choose an appropriate Navigator Homepage.

• Choose an appropriate Process Profile.

• Choose an appropriate Primary Permission List for the Primary field.

• Choose an appropriate Row Security Permission List for the Row Security field.

• Click the Roles tab.

• Click the + button to add a new row to the Roles list.

• Select the GET_CI_INFO Role.

• Select the PeopleSoft User Role.

• Select the Standard Non-Page Permissions Role.

• Scroll down to the bottom of the User Profile window and click Save.

Step3: Testing the Component Interface:

• Start  PeopleSoft Application Designer. Click File, Open and select Definition = Component Interface.

• Select GET_CI_INFO CI from the list of Component Interfaces.

• After opening GET_CI_INFO, right-click anywhere in the right pane of your Component Interface definition and select Test Component Interface.

  The Component Interface Tester dialog box appears.

• GET_CI_INFO should not contain any keys. If keys are present, you need to return to Application Designer and remove them.

This concludes the set up of the GET_CI_INFO Component Interface needed to communicate with BizTalk Server.

In the next coming blog posts we will see how we can generate metadata with this GET_CI_INFO Component Interface.

Regards,

Vishal Mody

PS: Reference from MSDN article : Microsoft BizTalk Adapters for PeopleSoft