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

[Al H <star111lists@mindspring.com>]

The tools you use for data loading are strictly a decision of
technical business policy. There is no encryption in PeopleSoft tables
that would require you to use any specific tool. 

Size considerations (200 records vs 2 million), purpose (initial data
conversion, ongoing interfaces etc), data sources and available
expertise on the tools that might be used are all considerations.

SQR, DTS, Data Mover, PS Import Manager (8.1x tools and prior),
Application Engine, Component Interface all have there values in
getting data into the system.

One big consideration is the volume of data.  Massive amounts of data
to be loaded in one run may be best loaded using the database platform
tools where the journalling can be turned off.

On Thu, 01 May 2003 09:52:53 -0700, you wrote:

>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)?
>


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