Getting data out of PeopleSoft

peoplesoft
bmw0128 picture bmw0128 · Jun 12, 2009 · Viewed 8.6k times · Source

We have a PeopleSoft installation and I am building a separate web application that needs to pull data from the PeopleSoft database. The web application will be on a different server than PeopleSoft, but the same internal network.

What are my options?

Answer

Epictetus picture Epictetus · Jun 21, 2009

Yes - Integration Broker is Peoplesoft's proprietary implementation of a publish/subscribe mechanism, speaking xml. You could of course just write code that goes against your database using JDBC or OLE/ODBC. Nothing keeps you from doing this. However, you must understand the Peoplesoft database schema, so that you are pulling from, or inserting/updating/deleting all of the proper data. Peoplesoft takes care of this for you.

Also, check out Component Interfaces - and they are exposed as an API to Java or C/C++.

Related questions

Updating a date in Oracle SQL table

I am trying to update a date in a SQL table. I am using Peoplesoft Oracle. When I run this query: Select ASOFDATE from PASOFDATE; I get 4/16/2012 I tried running this query UPDATE PASOFDATE SET ASOFDATE = '11/21/2012'; but it …

Read More
SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be …

Read More
SOAP returns data, but C# says null response

My C# app won't give me anything but null results from SOAP calls. We have exposed some PeopleSoft ERP data with a SOAP web service. I am accessing this SOAP service from a Visual Studio 2012 ASP.NET C# app. I …

Read More