About “Integration Broker Case Study”

Thanks to the working environment, I have published this article in Infosys K-shop these days.

According to the suggestion, it will a kind of IP of the company ^_^

Integration Broker Case Study (Fileoutput) II

In this case, we are going to configure the intergration broker for the file output of the new/updated data in PeopleSoft, which means the system will give a file out when we enter a new record or update a record.

We use an available service DEPT_SYNC for department record updated or added. The following are main steps in the process:

• Start up Sub/Pub in PSadmin
• Configure PeopleSoft Listenning Connectors
• Configure PeopleSoft Traget Connectors
• Create the Nodes
• Create the Routing
• Put the Routing in a Queue
• Activate the service

1. Start up Sub/Pub in PSadmin

Open your PSadmin console to admin the app server and select your domain to configure. Put Pub/Sub Servers on in your configuration file and reboot the domain. We will be able to find the below info.

2. Configure PeopleSoft Listenning Connectors

In PIA, Main Menu > PeopleTools > Integration Broker > Quick Configuration, choose your local gateway, put your local gateway URL, like http://yourserver:yourport/PSIGW/PeopleSoftListeningConnector. If it is the correct address, you will ping the gateway successfully. In addition, you will also find your domain is in the intergration broker domains’ list, which is in active status.

Il y a longtemps

I am not sure why I can not visit my blog in last few days. Is it blocked or banned? Any ways, it is reachable now. Let’s keep on moving^o^

Integration Broker Case Study (Fileoutput)

Perface

It is from PeopleBooks that PeopleSoft Integration Borker facilitates exposing PeopleSoft business logic as services for PeopleSoft Applications to invoke, which means that IB (Integration Broker) helps PeopleSoft to work with other systems. The overview of the architecture is follow:

The integration process include configuring messaging systems as well as managing integration gateways, while we have the following items in the integration gateways:

• Nodes
• Messages
• Queues (“Queue” is once called “Message Channel” in pervious PeopleSoft version.)
• Services
• Service Operations
• Routings

I am able to give a general picture about the above items according to my understanding:

A service operation can develiery messages though a routing, while service operation is working in a queue. That’s it. Of course, there are also some pictures from PeopleBooks, which make out the mechanism.

These days, I was working on some IB in action to have a better understanding of it. There is an article,Using PeopleSoft Integration Broker, about how to get a fileoutput by using IB, but the tutorial is a little bit out of date. Now let us see how to make it work in our system.

PeopleCode Debug

Sometime, we will need to investigate in PeopleCode for debug. Here is a short introduction for doing so.

1. Use Getfile to debug PeopleCode

We simply use a file to log the data and variables.  Here is a similar article about this (http://peoplesoftexperts.blogspot.com/2005/12/debug-peoplecode-using-getfile.html ), I am also writing the PeopleCode as the following:

/* Debug Part*/

SQLExec(“select sysdate from dual”, &ddate);

&DFILE = GetFile(“\\machine_name\Output\dfile.txt“, “A”, %FilePath_Absolute);

If &DFILE.IsOpen Then

&DFILE.WriteLine(&ddate | “Your Data”);

&DFILE.Close();

End-If;

/* Debug Part End*/

What we do is to put the code in the place,  we are going to debug.

2. Debug Mode in Application Desinger

It would be better to have an IDE to debug the application and code, which is provided by Application Designer. We can use its debug mode to do the job. Here is way to enable the debug mode for 3-tier (PIA). There is a detail How-to in PeopleBook System and Server Administration, Chapter 12, Chapter 12 Configuring Trace and Debug Settings: http://download.oracle.com/docs/cd/E05317_01/psft/acrobat/pt849svt-b0307.pdf

While the following is a brief:

1. Enable PC Debugger in PSADMIN

2. Set the PSDBGSRV Listener Port in PSADMIN and Enable the log.  Normally, it is 9500, for example in .cfg file:

• Values for config section – PeopleCode Debugger
  PSDBGSRV Listener Port=9500
  DebuggerMsgLogEnable=1

3. Set Multiple PSAPPSRV Server Processes and Timeout to 0.  For example:

• Values for config section – PSAPPSRV
  Min Instances=2
  Max Instances=2
  Service Timeout=0
  Recycle Count=0
  Allowed Consec Service Failures=0
  Max Fetch Size=5000
  Auto Select Prompts=1
  Tuxedo Queue Size=65535

4. Open the Configuration Manager to ensure the PSDBGSRV Listener Port is 9500 on the same machine of Application Server

5. Login to Browser (PIA) and Application designer in three tier (App Server) with same and unique UserId.

6. In application designer, start debugger. Enable “break at Start” or set “break points” and access Page / Component to be debug in browser.

PeopleSoft Record Notes I

PeopleSoft is a database oriented application, which puts almost everything in the database.  We develop and update the metadata in database for the development. The following is the data structure as far as I know:

• Field->Record->Page->Component->Menu

Let’s Start:

1. Field:

Fields are the lowest-level definition in PeopleSoft, in general we can think of them as the column definiation in a database. Namely, we can find the definition in a table called PSDBFIELD in PeopleSoft Database. And we have a PSRECFILED, which keeps the relationship information of Records and Fields.

Related Tables: PSDBFIELD, PSRECFILED

2. Record:

A collection of fields is a record, while the core in peoplesoft definitions is “Record”. Their definitions are stored in the table named PSRECDEFN. And we now have the following record types:

• SQL Table
• SQL View
• A Derived Work Record (To store totals or buttons, messages or temp fields, only available during the session. No real table)
• Sub Record (For SubPages and the one-to-many relationship)
• Dynamic View
• Query View
• Temp Table

In order to create a standard record, such as SQL table, we will have to have the following operations:

1. In PIA, PeopleTools->Utilities->Administration->Tablespace Utilities to define the tablespace
2. Check PSTBLSPCCAT table for the new tablespace
3. Define the tablespace in Database
4. Create the record metadate in PSRECDEFN with Application Desinger
5. Build record with SQL generated by Application Desinger

Install PeopleSoft Step By Step Part III

5. PIA Setup:
• Use PIA Setup Wizard Program (PS_HOME\setup\PsMpPIAInstall\setup.exe) to create a PIA site
1. Setup your PIA site

2. Input your PS_HOME folder

3. Use WebLogic as the web server

4. Input WebLogic Application Home

5. Create a new domain with a domain name

6. The web server is for single server domain.

7. Specify a name for the web site.

8. Give the application server name and assign the port. (JSL Port should be the same as the one used in application server.)

9. Use the default User ID and Password for web profile. (The account is build in DB PSOPRDEFN)

10. Select your report repository location

11. Confirm your setting and parameters for PIA setup

6. PIA Service Startup:
• Find the web server startup file in PS_HOME\webserv\MyPeople\bin\startPIA.cmd
• Start your web server and be sure that Web Logic can connect your application server with JSL port
• Boot Your Application server with psadmin.exe (PS_HOME\appserv\psadmin.exe)

• 1. Start PSADMIN
• 2. Specify 1 for Application Server and press ENTER.
• 3. Specify 1 for Administer a domain and press ENTER.
• 4. Select the domain to administer and press ENTER.
• 5. Specify 1 to boot this domain and press ENTER.
• 6. Specify 1 to boot in serial mood and press ENTER

7. Testing:
• Open your web browser and input the local host IP address and HTTP port (http://127.0.0.1:80)

• Choose “default PeopleSoft logon page”

• Use PS/PS to log in