The PeopleSoft Connector provides real-time connectivity to query and update all PeopleSoft modules, using a common integration interface known as the Component Interface.

Oracle's PeopleSoft applications are designed to address the most complex business requirements. They provide comprehensive business and industry solutions, enabling organizations to increase productivity, accelerate business performance, and provide a lower cost of ownership.

Additional Info

Requires Mule Enterprise License

Yes  

Requires Entitlement

Yes  

Mule Version

3.6.0 or higher

Configs

Configuration

<peoplesoft:config>

Connection Management

Attributes

Name Java Type Description Default Value Required

name

String

The name of this configuration. With this name can be later referenced.

x 

server

String

Generally conformed by the host:port (e.g. localhost:9999)

x 

username

String

The username to access the service

x 

password

String

The password to access the service

 

componentInterfaceIdsWhiteList

List<String>

List of the CI names (IDs) that will be gathered for DataSense.

 

componentInterfaceInteractiveMode

Boolean

Controls whether to apply values and run business rules immediately, or whether items are queued and business rules are run later, in a single step.

Note: You should use interactive mode when testing and debugging a component interface. Interactive mode in a production environment slows performance because of the number of server trips required.

If you are using a component interface as part of a batch process in which thousands of rows are to be inserted, running in interactive mode may reduce performance so much on some UNIX servers that the application times out with a connection failure.

false

 

componentInterfaceGetHistoryItems

Boolean

Controls whether the component interface runs in Update/Display mode or Correction mode when the underlying component is effective-dated. If GetHistory is set to true, then historical data can be retrieved but not modified. GetHistory items work in accordance with EditHistory items.

false

 

componentInterfaceEditHistoryItems

Boolean

Controls whether the component interface runs in Update/Display All mode, Update/Display mode, or Correction mode when the underlying component is effective-dated. If EditHistory items are set to true, then historical data can be modified. EditHistory items work in accordance with GetHistory items.

false

 

Processors

Invoke Component Interface

<peoplesoft:invoke-operation>

  DataSense enabled

Invoke Operation will invoke a PeopleSoft operation depending on the type selected. DataSense discovers the structure of the entities in the system in Designtime/Runtime and uses it to perform the operation for the type selected. This will vary for Find, Get, Create and the rest.

../../../doc/peoplesoft-connector.xml.sample peoplesoft:invoke-operation

XML Sample

<peoplesoft:invoke-operation config-ref="PeopleSoft" key="JOB_TASK_TABLE||Find" />
<peoplesoft:invoke-operation config-ref="PeopleSoft" key="JOB_TASK_TABLE||Get" />
<peoplesoft:invoke-operation config-ref="PeopleSoft" key="JOB_TASK_TABLE||Create" />
<peoplesoft:invoke-operation config-ref="PeopleSoft" key="JOB_TASK_TABLE||Save" />

Attributes

Name Java Type Description Default Value Required

config-ref

String

Specify which config to use

x 

key

String

+++The type of the entity as determined by DataSense. Once all the types are gathered from Sandbox, Entities are composed as {CI}

{Operation} like JOB_TASK

Get.+

x 

payload

Returns

Return Java Type Description

List<Map<String,Object>>

The result of the operation.