In this post we will see few of the initial steps for developing BizTalk Solutions for integrating with PeopleSoft Enterprise Systems using PeopleSoft Adapter. In order to proceed further, you must have Installed and Configured PeopleSoft Adapter properly, both on BizTalk side and PeopleSoft System side. This particular post is based on PeopleSoft HRMS 9.0 system. But the steps shown below should be same for any PeopleSoft Enterprise System.
The steps will be same to connect to any Component Interface of PeopleSoft System. Here we will be connecting to the Employee Personal Data component interface.
BizTalk Server 2010
Visual Studio 2010
SQL Server 2008 with SP2
PeopleSoft HRMS 9.0 with PeopleTools 8.52
- Open Visual Studio 2010 and create a new BizTalk Solution. In this case we named it as PSDemo.
- Open BizTalk Server Administration Console and you can use any Application or you can create a new Application. Here we are using the BizTalk.EnterpriseApplication.
- Go to Send Ports for this application and right click and create a new Static Solicit Response Send Port.
- Name the send port appropriately and select PeopleSoft as the Transport Type and XML Transmit and XML Receive as the pipelines as shown in the screenshot.
- Click Configure for the PeopleSoft Adapter and fill in the appropriate values for the PeopleSoft adapter properties. You can keep other values as default ones apart from the Application Server Path, Java_Home, Password, PeopleSoftJarFile and Username.
- Click Apply –> Ok. Restart the BizTalk Host Instance and then Stat this particular Send Port. Check the event log if you have any errors after starting the Send Port.
- Go back the the Visual Studio solution. Right click the project and click Add Generated Items.
- Click Add Adapter Metadata.
- From the list of registered adapters, select PeopleSoft Adapter and wait for a second and you will see the list of Send Ports registered with PeopleSoft Adapter. Select the one which we created above and click Next.
- Wait for few seconds and you will see all the Component Interfaces for the PeopleSoft System. If you don’t see any CI then there might be some issue in your PeopleSoft Adapter configuration on the send port side. Check the Event Log for any error. For any JVM related errors, check out this blog post to fix them. It also discusses other error fixes.
- Select the component interface from the list for which you want to generate the metadata for. Here we will be using CI_Personal_Data which is a component interface for PeopleSoft HRMS Employee Personal Data.
- Once selected click Finish and after few seconds you will see the schemas and orchestration added for this CI.