[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Selecting data from a legacy database

Depends ... what is your legacy database? SQR can access several types of 
databases, but not all of them. It would be helpful if you told use the 
specifics of your legacy database.

>>> Justin Teckenbrock <teckenbrock@HOTMAIL.COM> 2002/05/06 12:15:19 pm >>>
I have PeopleSoft installed on an Oracle database.  However, I need data
from a legacy database
and have it formatted and written to a flat file.  A delivered SQR will then
grab the data from
that flat file.  Can I write an SQR program to log into this legacy
database, select the data,
and write it to a flat file?  If so, how and where do I let peoplesoft know
i want the sqr to be
run on the legacy database and not Oracle?  This will be a daily process.
Or would it be
easier to select the data and format it daily using a legacy tool and not go
through sqr?

Teckenbrock

_________________________________________________________________
Join the worldÆs largest e-mail service with MSN Hotmail.
http://www.hotmail.com