Enterprise Integration Utilities

In addition to the integration technology provided by PeopleTools, there is a set of utilities shipped with your PeopleSoft applications that are also a part of the PeopleSoft integration solution.

Note: The documentation for these utilities is not part of the PeopleTools documentation; it is included with your PeopleSoft application documentation and resides in the PeopleSoft Enterprise Components for <your application> Online Help.

These additional utilities include:

  • Publish utility.

  • Error Handling utility.

  • Effective Date Publish utility.

  • Flat File utility.

  • XML Schema utility.

The Publish utility automates the process of copying the contents of an entire table into a remote database or legacy system. Use the utility to synchronize data from an existing system when a new PeopleSoft system is installed. The data is chunked based on the maximum size set for a message. You can control the size, number, and frequency of these data messages by using a series of data publishing rules and:

  • Whether to create header and trailer records.

  • Where the data comes from.

  • Whether to chunk the message.

  • Which related languages to publish.

The publishing rules include pages for full table publishing rules, batch publishing rules, record mapping, languages, and batch programs.

The Error Handling utility is a PeopleTools application that you use to view and correct messages that are received by the subscriber. You can also use this utility to correct data that is stored in staging tables.

PeopleSoft applications that receive flat file data from other systems through batch processes have built-in facilities to validate and correct data prior to updating the main application tables. Likewise, before updating core PeopleSoft application tables, the subscription process detects data errors in the messages that it receives. These error messages are stored in either message queues or staging tables.

In some cases, however, errors can’t be sent back to the third party for correction (such as when data is in a flat file). In these cases, you must provide error processing on incoming data so that messages that contain information on business objects, such as items and vendors, can be corrected and reprocessed in the PeopleSoft system. The Error Handling utility enables you to achieve this task.

The Effective Date Publish utility enables you to design processes to update external systems that process only current data and don't use or recognize effective dating.

For example, for full data messages that are intended for vendors who do not handle effective dating, the Effective Date Publish utility enables you to publish only those rows that are currently active. Any future-dated rows are not published and written to the delay table instead.

The Flat File utility enables you to develop complementary processes to translate incoming files into messages or translate outbound messages into files. You use this utility when external systems send you flat files, when external systems only accept flat files sent to them.

The Flat File utility reads the data in an incoming flat file and copies the rowsets of the data file into a message. When the utility sends the message to the subscribers, the subscribing systems receive the message an initiate normal inbound data processing. This process works in reverse for outbound flat files.

PeopleSoft Open Integration Framework enables near real-time messaging and transactions by using a format that is based on XML to convey information between diverse applications in a standard way. To take advantage of this standardization, you must obtain clear XML definitions (schemas) for each application message, component interface, or business interlink.

The XML Schema utility provides the following features:

  • Output options for the XML Schema utility, document type definition (DTD), or BizTalk definition for all application messages.

  • The ability to create an XML definition for a single object, for all of the objects, or for all of the objects by a specific owner.

  • A single flat file for each XML definition that is written to your system’s %TEMP directory (when you use the Microsoft Windows client) or the server’s common access file directory (when you use PeopleSoft Internet Architecture).

  • An application foundation for future standards of XML definitions.