This chapter discusses how to:
Define dataset rules and roles.
Set up PIM preferences.
Set up PIM user settings.
Install PeopleSoft Infosync Client.
Set up Integration Broker.
Specify conflict resolution rules.
Modify synchronization settings.
Note. This chapter covers all the tasks that are involved in setting up the integration between PeopleSoft CRM and PIM clients. Administrators can take full advantage of the system-delivered data that is predefined for some tasks (for example, dataset rules, dataset roles, PIM preference, and so on), or they can modify and create new rules and preferences that best fit their business needs.
This section provides an overview of discusses how to:
Define dataset rules.
Define dataset roles.
A dataset is a collection of dataset rules that are used to determine what data end users receive on their PIM clients as a result of synchronization. In the integration setup process, you define the relationship between end users and dataset rules using this logic:
Each user is associated with a PIM preference.
Each PIM preference specifies a dataset role for each synchronization object (contact, consumer, worker, calendar, and task).
Each dataset role is associated with a dataset (group of dataset rules) for each synchronization object.
When synchronization completes, end users receive updates on data based on the associated dataset rules. For example, suppose that you use the system-delivered dataset rules for synchronizing sales user tasks. After synchronization, the updates that sales users get for the task object come from their own tasks (rule: MY TASKS), tasks that are assigned to their leads (rule: TASKS ON MY LEADS), and opportunities (rule: TASKS ON MY OPPORTUNITIES). PeopleSoft delivers predefined datasets and dataset rules for this integration. You can modify them or create custom dataset rules to work with your implementation.
Note. If an end user is no longer associated with a contact, consumer, or worker (for example, a sales user reassigns a lead task to another person and therefore does not receive any updates about the lead's contacts from the CONTACTS_FOR_LEAD_TASK_ASSIGNEE dataset rules), the record is removed from the end user's address book.
Page Name |
Object Name |
Navigation |
Usage |
EOEC_DATASET |
Enterprise Components, Component Configurations, Datasets, Dataset Rules |
Define rules that comprise a dataset. Dataset rules are associated with users through dataset roles; they are used in the synchronization process to determine what data gets updated in PeopleSoft CRM and the PIM client. |
|
PIM_ROLE |
Set Up CRM, Install, PIM, PIM Dataset Role |
Define dataset roles and associate them with dataset rules. |
Access the Dataset Rules page.
Rule |
Enter the name of the rule. When you save the page, this field becomes unavailable. |
Search Record Name |
Enter the name of the search record for this rule. You can create a view specifically for use in the rule. |
((... and ))... |
If you leave the AND or OR field blank, specify the nesting level for this condition. Be sure to match opening and closing parentheses. |
Field Name |
Select the field name on which this rule operates from the drop-down list of fields in the selected component. |
Operator |
Specify the operation with which to compare the specified field value. Select from standard conditional operators. |
Field Value |
Enter the value of the specified field against which to compare. |
Test SQL (test structured query language button) |
Click this button to test the validity of the rule conditions. The result is returned below the button. |
Show SQL (show structured query language) |
Click this button to view the SQL statement generated by the rule. |
See Also
PeopleSoft 8.9 Enterprise Components PeopleBook
Access the PIM Dataset Roles page.
The system delivers two PIM dataset roles: thePIM Field Service Role and the PIM Sales Role.
Dataset Name |
Select a dataset for each synchronizable object: contact, consumer, worker, task, and calendar. All of the rules that are associated with this dataset are then available in the Rule grid. |
Rule |
Select a dataset rule that is applicable to this role. Note. You can update, add, or remove rules from datasets for PIM roles. For example, if sales users prefer not to see tasks that are assigned to other users (even though the tasks belong to their leads and opportunities), administrators can delete the TASKS ON MY LEADS and TASKS ON MY OPPORTUNITIES rules from the task dataset of the PIM sales role. |
See Also
PeopleSoft 8.9 Enterprise Components PeopleBook
This section discusses how to:
Specify overall PIM preference.
Specify PIM preference for contacts.
Specify PIM preference for consumers.
Specify PIM preference for workers.
Specify contact method mapping.
Specify PIM preference for calendar items.
Specify PIM preference for tasks.
Note. When you configure PIM preferences, consider it a one-time implementation process. Avoid changing PIM preferences after PeopleSoft Infosync Client is in production.
Page Name |
Object Name |
Navigation |
Usage |
PIM_PREFERENCE_PG1 |
Set Up CRM, Install, PIM, PIM Preferences, Setup |
Specify the PIM application type for end users who take this PIM preference. |
|
PIM_PREF_CONTACT |
Set Up CRM, Install, PIM, PIM Preferences, Contact |
Specify the synchronization preference for contacts. |
|
PIM_PREF_CONSUMER |
Set Up CRM, Install, PIM, PIM Preferences, Consumer |
Specify the synchronization preference for consumers. |
|
PIM_PREF_WORKER |
Set Up CRM, Install, PIM, PIM Preferences, Worker |
Specify the synchronization preference for workers. |
|
PIM_PREF_ADDRESS |
Set Up CRM, Install, PIM, PIM Preferences, Address |
Specify contact method mapping for contacts, consumers, and workers. |
|
PIM_PREF_CALENDAR |
Set Up CRM, Install, PIM, PIM Preferences, Calendar |
Specify the synchronization preference for calendar items. |
|
PIM_PREF_TASK |
Set Up CRM, Install, PIM, PIM Preferences, Task |
Specify the synchronization preference for tasks. |
PIM Preference ID |
Enter the name of the PIM preference that is being defined. Associate each user with a PIM preference by specifying a PIM preference ID in the user preference on the Overall Preferences page. |
Debug |
Select to allow more specific information (for example, technical errors and message logs that are sometimes not end-user friendly) to be captured and displayed on the PIM Errors page. This is useful for administrators to debug and troubleshoot the application. |
Information that is entered in this group box pertains to PeopleSoft Infosync Server and does not apply to PeopleSoft Infosync Client. However, PeopleSoft recommends that you select the PIM application type.
PIM Application Type |
Select the type of PIM server (Lotus Domino or Microsoft Exchange server) that is used by PIM clients:Domino Server (default) and Exchange Server. |
Information that is entered into this group box pertains to PeopleSoft CRM.
PIA URI |
Enter web server information to generate a URI on the contact page in PIM. This URI takes the end user to the associating Contact record in the 360 Degree View. If your web server address includes a port number, also include this in the address. Note. A URI does not include the content information in the link. Think of it as a subset of the URL that points to the location of the resource, but does not include any parameters passed to that resource. |
PIA Portal |
Enter the level of portal access that PIM users will have. |
PIA Node |
Enter the PIA node that your system uses for integration. |
Contact
Specifies the synchronization preference that applies to contacts.
Contact 360 Degree View |
Select to enable the Contact URL to be synchronized to the PIM Client. The URL address is specified using the PeopleSoft CRM URL field on the Setup page of the PIM Preferences component. If this is disabled the URL will not be synchronized. Note. You must associate the contact with a company for this URL to link to the contact. |
Specifies the synchronization preference that is specific to My Contact List.
Add |
Select to enable contacts to be added to the PIM Client. |
Delete |
Select to enable contacts to be deleted from the PIM Client. |
Consumer
Specifies synchronization preferences that are specific to consumers.
Specifies the synchronization preference that applies to My Contact List.
Add |
Select to enable consumers to be added to the PIM Client. |
Delete |
Select to enable consumers to be deleted from the PIM Client. |
Worker
Specifies the synchronization preference that applies to workers.
Specifies the synchronization preference that is specific to My Contact List.
Add |
Select to allow workers to be added to the PIM Client. |
Delete |
Select to allow workers to be deleted from the PIM Client. |
Addresses and Phones
Home Address Type, Business Address Type, and Other Address Type |
Enter contact method purposes (defined in PeopleSoft CRM) that home, business, and other addresses in the PIM client are mapped to in PeopleSoft CRM after synchronization. A contact method purpose indicates when to use the specified contact method. For example, you typically send business-related correspondence to a contact using the contact's business address. To deliver an urgent document to the contact after office hours, you can use the home address. The default contact method purposes for home, business, and other address types are Home, Business, and Other. If you change the address types, the next synchronization becomes an initial synchronization. Note. The Other address type is applicable to Microsoft Outlook only. |
Primary Address Type |
Select the primary address type: Home, Business, or Other. If a contact has multiple addresses, the one that belongs to this address type becomes the primary address for the contact in PeopleSoft CRM. |
Home Phone Type, Business Phone Type, and Other Phone Type |
Enter contact method purposes (defined in PeopleSoft CRM) that home, business, and other phones in the PIM client are mapped to in PeopleSoft CRM after synchronization. The default contact method purposes for home, business, and other phone types are Home, Business, and Other. Note. The other phone type is applicable to Microsoft Outlook only. |
Phone Ext (phone extension) |
Enter a prefix for phone extensions. PeopleSoft Infosync Client supports phone extensions in all phone types. |
Calendar
Specifies the synchronization preference that is specific to calendar items.
Calendar Role Name |
Select the role for which the PIM preference is created. Dataset roles are defined on the PIM Roles page. |
Task
Specifies the synchronization preference that applies to tasks.
This section discusses how to associate PIM preferences with users.
Page Name |
Object Name |
Navigation |
Usage |
PIM_PREF_USERS |
Set Up CRM, Install, PIM, PIM Preferences, Users |
Associate end users with or disassociate end users from the PIM preference. |
|
OPR_DEF_TABLE_RB1 |
Set Up CRM, Security, User Preferences, Overall Preferences |
Associate users with the PIM preference. |
Note. You can associate PIM preference with users by accessing either the Users page or the Overall Preferences page.
User ID |
Click to select the PeopleSoft user ID of end users to be associated with the given PIM preference. You can add or delete end users from the list as necessary. If you add a new user who is currently linked to another PIM preference, doing so associates the user with the new PIM preference. Complete the prerequisite on saving the user preference record for each PIM end user; otherwise, all of the user IDs may not be available for selection. |
Last Sync Date (last synchronization date) |
Displays the date and time when the last synchronization occurred. The last transaction date for different end users varies upon whether data updates actually occurred between PeopleSoft CRM and the PIM client. If there's no data update for some end users after synchronization, their last synchronization date displays an earlier time stamp than other users who have just received data update. |
Access the Overall Preferences page.
SetID |
Enter a setID for the end user. This setID is used as the default setID for consumers (created by the end user in the PIM client) as the records are synchronized in PeopleSoft CRM (if sales business units are not applicable to that end user). |
Enter a country code for the user. Note. You must specify this value for PIM end users because PeopleSoft Infosync Client uses it as a default value in scenarios where a user adds a contact in the address book but forgets to enter a country for the contact. When synchronization occurs, the process populates the contact's missing country value with the localization country value of the end user (who creates the contact); otherwise, the user receives synchronization errors. |
|
PIM Preference ID |
Select a PIM preference with which the user is associated. When synchronization occurs, the process verifies the user's PIM preference and dataset rules that are associated with that preference to determine what data gets updated in the PIM client for the user. Set up PIM preference using the PIM Preferences component. |
See Also
Refer to the supplemental installation instructions for PeopleSoft Infosync Client for information on how to install the client application. This document is available on Customer Connection. Select Support, Documentation, Documentation Updates, Customer Relationship Management, All in Selected Product Line.
Additional Note for Installing PeopleSoft Infosync Client
After client installation is complete, you must configure the client. When you are in the Choose Translator dialog box to select which PIM application to run, these three operations are available for selection: Import, Export and Synchronize.
Select Import for the integration to perform one-way data update from the PIM Client to PeopleSoft CRM.
Select Export for the integration to perform one-way data update from PeopleSoft CRM to the PIM Client.
Select Synchronize for the integration synchronize data between PeopleSoft CRM and the PIM client.
A complete Integration Broker setup is provided as part of PeopleSoft Infosync Client. This setup synchronizes data between PeopleSoft CRM and PIM clients. The setup delivers these Integration Broker objects, which are used in this integration:
Two nodes: PSFT_INFOSYNC and PSFT_PIM.
One transaction message: PIM_CONTACT_SYNC.
Two codesets for data translation: INFOSYNC TO PIM and PIM TO INFOSYNC.
PeopleSoft recommends that you perform these tasks before using Integration Broker:
Change the default password that is used in the external node (that is, PSFT_PIM) by selectingPeopleTools, Integration Broker, Node Definitions.
After you've changed the password on the Node Info page, do the same to the URI parameter in the DCSSettings.cfg file.
Modify the IntegrationGateway.properties file under PSIGW\WEB-INF:
If the integration gateway supports only one database, set up the IntegrationGateway.Properties file with the default application server like this:
ig.isc.serverURL=//<yourappserver:jsl_port> ig.isc.userid=VP1 ig.isc.password=JekncVtPdNg= ig.isc.toolsRel=8.43
If the integration gateway supports more than one database and you cannot set the default application server to point to the correct database, set up a node as follows:
ig.isc.<default local node in PIM database>.serverURL=//<yourappserver:jsl_port> ig.isc.<default local node in PIM database>.userid=VP1 ig.isc.<default local node in PIM database>.password=JekncVtPdNg= ig.isc.<default local node in PIM database>.toolsRel=8.43
In every database, there is only one default local node. The Default Local Node check box is selected for this node.
Note. Make sure that the toolsRel value matches the version of your PeopleTools release.
If you change the Integration Broker user ID and password, make sure they are updated in the IntegrationGateway.properties file.
Enter the password in the encrypted form. PeopleSoft provides a utility that returns an encrypted version for the password that you provide. The utility is called pscipher.bat and it's available under the peoplesoft domain in the web server. Run the file in the command prompt like so:
c:\bea\wlsever6.1\config\peoplesoft>pscipher <your_password>
Verify that the gateway URL is updated (with the web server name on which Integration Broker resides) in the Gateways page.
Select PeopleTools, Integration Broker, Gateways, and click the Load button to populate the connector information and save.
Note. Do not log on to PeopleSoft Infosync Client and perform synchronization using the same user ID that Integration Broker uses, as specified in the IntegrationGateway.properties file.
Refer to the PeopleTools 8.45 PeopleBook: PeopleSoft Integration Broker for more details on how to set up and administer Integration Broker.
Considerations for Modifying Integration Broker Setup
Here are guidelines for modifying any Integration Broker setup data that is delivered with PeopleSoft Infosync Client:
Do not change node names, even if you must modify system-delivered nodes.
Follow the structure of the nodes listed here as you make modification:
Node Name |
PSFT_INFOSYNC (internal node) |
Node Type |
PIA |
Routing Type |
Implicit |
Authentication Option |
None |
Code Set Group Name |
INFOSYNC |
Gateway ID |
LOCAL |
Transaction Request Message |
PIM_CONTACT_SYNC |
Node Name |
PSFT_PIM (external node) |
Node Type |
External |
Routing Type |
Explicit |
Authentication Option |
Password (delivered password is infosync) |
Code Set Group Name |
PIM |
Gateway ID |
LOCAL |
Transaction Request Message |
PIM_CONTACT_SYNC |
See PeopleTools 8.45 PeopleBook: PeopleSoft Integration Broker
Do not change the transaction message.
See PeopleTools 8.45 PeopleBook: PeopleSoft Integration Broker
Do not change the names of codesets or codeset groups because it requires corresponding code changes in the system, which is a consulting project.
For each delivered codeset group, the supported match names are company, title, and status. A match name is the name of a data field that might be part of a message sent by a node belonging to this codeset group. You can enter match values (possible values of the data field represented by the match name) for match names, as well as return values to facilitate data translation. For example, end users may enter the country United States of America differently in the PIM client: U.S.,United States,U.S.A., and so on. If PeopleSoft CRM uses the term USA as the name of the country, and you want the translation program to recognize U.S., United States,and U.S.A.the same as USA, add additional codeset group entries using country as the match name, U.S., United States, and U.S.A. (three entries in total) as the match value and USA as the return value in the PIM TO INFOSYNC codeset.
Currently, if you want to add new match names (using XML names in the field mapping tables) to translate data in other data fields, it's considered a consulting project (because it requires certain code change).
The implementation of data translations for PeopleSoft Infosync Client is a three-step setup and verification process, which includes the setting up of codeset groups, codesets, and codeset values. For more information on how the data translation framework works, refer to the Performing Data Translation section of the Applying Filtering, Transformation, and Translation chapter in the PeopleSoft Integration Broker PeopleBook.
Access the Conflict Resolution page.
Note. Conflict resolution rules are predefined in PeopleSoft Infosync Client. Administrators should determine which rule to use before the client application is distributed to end users.
Add all conflicting items |
Select to add both conflicting items to the database. |
Ignore all conflicting items |
Select to ignore all items if they are conflicting. Warning! It is recommeded to not use this option. There is a potential for overwriting data. |
Notify me when conflicts occur |
Select to notify the user when there is a conflict, giving the user the flexibility to select which item to update (default value). |
PeopleSoft InfoSync Wins |
Select to allow entries made in PeopleSoft CRM to overwrite what is in the PIM client. |
Lotus Notes Wins |
Select to allow entries made in PIM to overwrite what is in PeopleSoft CRM. PeopleSoft supports Lotus Notes 4.6, 5.x, and 6.0. MS Outlook Wins (Microsoft Outlook wins) appears if the selected PIM application is Microsoft Outlook. |
Note. For information on how to use the Infosync Client, refer the online help available in the client application. Missing important information about the Infosync Client is documented in this PeopleBook.
See Also
After PeopleSoft Infosync Client is installed, you must apply several changes to the configuration file, DCSSettings.cfg. The file is located under C:\Program Files/PeopleSoft/PeopleSoft Infosync.
Note. PeopleSoft provides a utility called Infosync Admin Console Wizard to facilitate the deployment of configuration changes to PIM end users. It collects the configuration information that is entered by administrators and creates a compression file that PIM end users use to apply the update. Refer to the Supplemental Installation Instructions for PeopleSoft Infosync Client document for more information on the utility.
Apply these changes:
Update the Server URL parameter to the web server name on which Integration Broker is running, the Port parameter to indicate the port number that Integration Broker listens to. indicate the web server name on which Integration Broker is running, and the URI parameter to reflect the default node that you use. For example:
[Connection]
Server URL=<web_server_name>
Port=<Intgration_broker_listening_port>
URI=/PSIGW/HttpListeningConnector?From=PSFT_PIM&To=<default_node_name>&MessageName=PIM_CONTACT_SYNC&MessageType=sync&Password=infosync
If you use a secure connection, make sure that the information on secure server URL, secure port, and secure URI is accurate.
Change the value of the Email2 Field parameter to 1:
[Contact Options]
mail2 Field=1
Other Street=0
In addition to the DCSSettings.cfg file, administrators are recommended to increase the timeout value in the pstools.properties file under the PSIGW\WEB-INF\classes directory to allow Integration Broker longer for initial synchronization. To do so, copy the file from the PORTAL\WEB-INF\psftdocs\ps directory and change the value of the tuxedo_receive_timeout parameter to 1200 (in seconds). For example:
tuxedo_receive_timeout=1200