Posted by [IP Address: 142.154.103.77] 'DLeavy' on May 29, 2001 at 14:12:28 EST:
In Reply to: PeopleSoft Databases posted by [IP Address: 142.154.103.77] 'JD' on May 29, 2001 at 07:45:56 EST:
: 1)What databases does PeopleSoft use?
: 2)Does it have its own Proprietary database?
: 3)Can you export a PeopleSoft database to MS SQL, Oracle or DB2?
: 4)Can PeopleSoft import from MS SQL, Oracle or DB2?
: 5)In what ways can you access or extract the PeopleSoft database?
: Please help
: Regards
: JD
1. PeopleSoft is a database-independent software package - it's latest release supports DB2 (various 'flavours' - e.g. OS/390), Oracle, Informix, Sybase, MS SQL Server) and maybe more. Although I think SQLBase was recently dropped.
2. No, you might be thinking of Oracle Financials, a competing ERP package who's makers also produce the Oracle database.
3. Of course. If you want a functioning PeopleSoft instance running on the new database, then there's more to it. Depending on what version of PeopleSoft you're talking about, you need to consider two-tier vs. three-tier, application servers, web servers, server operating system, client operating system, etc., etc., etc. More things than I could possibly mention.
Generally, you install PeopleSoft with the new database and migrate the data over - a very involved process.
4. It's not up to PeopleSoft to do this. If your talking about linking tables from other databases or updating tables in the PeopleSoft database with information from another source, then you need your programmer and/or DBA to get together and develop something. PeopleSoft ships with third-party products (SQR, for example) that may be used, but you're free to develop something with other tools.
5. Many - and depends on the database.
PeopleSoft is an ERP package, or e-commerce package, or whatever buzz-word we're using now, it is not a database management tool. Those things ship with your database, and there are also many third-party products available to perform this function.