Populating the PeopleSoft Interaction Hub User Profile Table

A sample integration based on the Workforce service operation is provided to populate job-related data from the PeopleSoft HCM database. You must configure Integration Broker for the source database and the PeopleSoft Interaction Hub database, then run the PeopleSoft Publish utility for the source database, and verify the results in the PeopleSoft Interaction Hub database.

To populate the PeopleSoft Interaction Hub User Profile table using the delivered service:

1. Configure Integration Broker in PeopleSoft HCM:

   1. Navigate to PeopleTools > Integration Broker > Integration Setup > Service .

   2. Open the WORKFORCE_FULLSYNC service.

   3. Select the default service operation WORKFORCE_FULLSYNC.INTERNAL and set it to active.

   4. Add a routing from PeopleSoft HCM to PeopleSoft Interaction Hub.

   5. Select the Routing Parameters tab, and enter the following values to transform the transaction to the VERSION_2 service operation:

      Field or Control	Description
      External Alias	WORKFORCE_FULLSYNC.VERSION_2
      Message.Ver into Transform 1	WORKFORCE_FULLSYNC.INTERNAL
      Message.Ver out of Transforms	WORKFORCE_FULLSYNC.VERSION_2

      Note: Some earlier PeopleSoft HCM 9.1 builds have WORKFORCE_FULLSYNC.VERSION_2 as the default service operation version instead of WORKFORCE_FULLSYNC.INTERNAL. In that case the transformation step is not needed, as the external alias should match the service operation external alias in PeopleSoft Interaction Hub (WORKFORCE_FULLSYNC.VERSION_2).

      Note: If a routing already exists for the Resource Finder integration, a separate routing should be created since the Resource Finder routing requires the WORKFORCE_FULLSYNC.VERSION_2 to be transformed to WORKFORCE_FULLSYNC.VERSION_1

2. Configure Integration Broker in PeopleSoft Interaction Hub:

   1. Navigate to PeopleTools > Integration Broker > Integration Setup > Service.

   2. Open the WORKFORCE_FULLSYNC service.

   3. Select the service operation WORKFORCE_FULLSYNC_V2.VERSION_2 and set it to active.

   4. Activate the handler.

   5. Activate the Any-to-Local routing.

   6. Select the Parameters tab and verify External Alias = WORKFORCE_FULLSYNC.VERSION_2.

3. In PeopleSoft HCM, run the PeopleSoft Publish utility:

   1. Navigate to Enterprise Components > Integration Definitions > Full Data Publish Rules.

   2. Select the WORKFORCE_FULLSYNC service and select the Create Message Header and Create Message Trailer options if they are not already selected.

   3. Navigate to Enterprise Components > Integration Definitions > Initiate Processes > Full Data Publish.

   4. Add a run control, or use an existing one.

   5. Set Service Operation to WORKFORCE_FULLSYNC and click Run.

   6. Select the Full Table Data Publish option and click OK.

   7. Verify the process status updates to Success.

   8. Navigate to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services.

   9. Go to the Publication Contracts page and verify the transactions are successful.

4. Verify the results in PeopleSoft Interaction Hub.

   1. Access PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services.

   2. Access the Subscription Contracts page and verify the transactions are successful.

   3. Verify the user profile has been populated by querying the EPPCW_PROF_HDR table.