none
ADO.NET provider for oracle peoplesoft RRS feed

  • Question

  • Hi,

    I would like to know whether I can use the ADO.NET provider for Oracle to retrieve/connect PeopleSoft database.

    Thanks

    HP

    Thursday, November 22, 2012 12:14 PM

Answers

  • I don't think PeopleSoft uses an Oracle database so the answer is probably no. PeopleSoft appears to support creation of web services so that may be the direction you need to take. In any event, you may want to contact Oracle, since they own PeopleSoft, or try one of their support forums.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Alexander Sun Friday, December 7, 2012 1:59 AM
    Friday, November 23, 2012 1:24 PM
  • PeopleSoft application can use any one of below database platform.

    1. Oracle
    2. IBM DB2 z/OS
    3. IBM DB2/ LUW
    4. IBM Informix
    5. Microsoft SQL Server
    6. Sybase

    And all above database supports OLEDB provider and many of above database released their own database connection provider for .net. So the answer is yes – using .net you can connect to any of the databse of peoplesoft.

    What is your underlying database platform for PeopleSoft?  If it is Oracle then you can connect to oracle database through C# using Oracle Data Access Component (ODAC.net) from here.

    AFIK, A PeopleSoft database comprises of two databases as below.

    1. Application Data - The Application Data layer houses the actual user-entered data in the database
    2. RDBMS Catalog - The RDBMS Catalog houses the core structures that make up the database

    The biggest challenge you may face is to understand schema of your database as it is not fixed.

    Another approach would be to connect using the three-tier approach, the PeopleSoft Configuration Manager would be needed to configure to connect to the database server through a web services.


    Lingaraj Mishra

    • Marked as answer by Alexander Sun Friday, December 7, 2012 1:58 AM
    Sunday, November 25, 2012 3:43 AM

All replies

  • I don't think PeopleSoft uses an Oracle database so the answer is probably no. PeopleSoft appears to support creation of web services so that may be the direction you need to take. In any event, you may want to contact Oracle, since they own PeopleSoft, or try one of their support forums.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Alexander Sun Friday, December 7, 2012 1:59 AM
    Friday, November 23, 2012 1:24 PM
  • PeopleSoft application can use any one of below database platform.

    1. Oracle
    2. IBM DB2 z/OS
    3. IBM DB2/ LUW
    4. IBM Informix
    5. Microsoft SQL Server
    6. Sybase

    And all above database supports OLEDB provider and many of above database released their own database connection provider for .net. So the answer is yes – using .net you can connect to any of the databse of peoplesoft.

    What is your underlying database platform for PeopleSoft?  If it is Oracle then you can connect to oracle database through C# using Oracle Data Access Component (ODAC.net) from here.

    AFIK, A PeopleSoft database comprises of two databases as below.

    1. Application Data - The Application Data layer houses the actual user-entered data in the database
    2. RDBMS Catalog - The RDBMS Catalog houses the core structures that make up the database

    The biggest challenge you may face is to understand schema of your database as it is not fixed.

    Another approach would be to connect using the three-tier approach, the PeopleSoft Configuration Manager would be needed to configure to connect to the database server through a web services.


    Lingaraj Mishra

    • Marked as answer by Alexander Sun Friday, December 7, 2012 1:58 AM
    Sunday, November 25, 2012 3:43 AM