RE: [sqr-users] Importing data into Peoplesoft 8

["Barnes, Tracy" <TBarnes@CIBER.com>]

Jim,

PeopleSoft likes to think they can control you and your interaction with the
PS database, but we know they can't.

Any tool that can be used to import/export/load database tables can and
should be considered for loading your data into the PS system.  Some tools
have distinct advantages over others, and some are better suited for certain
tasks and volumes of data.

Things to consider:
- If the data needs error checking, data validation or manipulation, then it
is best to use a Procedural language, such as SQR.
- If the data is a straight load from a fixed length flat file, and there is
a large amount of data, then it may be best to use a RDBMS specific tool
such as MSS DTS, or Oracle SQL*Loader.  This is good for PS setup tables.
- If the table is a stand-alone table, i.e. no parent/child tables, it will
also help your choice.  If there are parent/child relationships that need to
be adhered to, then be sure to load those necessary tables ASAP.  The RDBMS
does not have any Integrity constraints for the PS tables, but if all
Integrity is not enforced by the Programmer/DBA doing the load, the PS
Application will experience problems!

Hope this helps!

Tracy E. Barnes
Ciber Enterprise Solutions
Principal Consultant
Cell: (317) 374-7356

 -----Original Message-----
From:   Jim Engebretson [mailto:jengebretson@Cerritos.edu]
Sent:   Thursday, May 01, 2003 11:53 AM
To:     sqr-users@sqrug.org
Subject:        [sqr-users] Importing data into Peoplesoft 8

Are we required to use SQR for importing data into Peoplesoft data
tables?
Why can't computer administrators directly import data into Peoplesoft
user
data tables (i.e. using MS Sql Server DTS) since we are not affecting
control tables (panel field sizes or security)?



Thank you,



Jim Engebretson

Cerritos College

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users