Re: Conversion from legacy system

["Sengupta, Rajib (CC-Contractor)" <Rajib.Sengupta@CONAGRAFOODS.COM>]

That's true if the two database you are talking on are somehting like SQL
Server and Oracle or DB2 and Oracle in Unix only.
But we had problem in doing this between DB2 in mainfarme and Oracle in
Unix. It didn't worked- we tried to use tit but without result and then only
we decided to go via two step process. And the two step process is always
better as per my experience.
Rajib Sengupta
Systems Analyst
ConAgra Business Systems
Peoplesoft AR and Order Management
222 South 15th St,North Tower(CT-930)
Omaha NE 68102
Phone: (402) 595-7928,Fax: (402) 595-7024



-----Original Message-----
From: Knapp, Richard [mailto:KnappR@UMSYSTEM.EDU]
Sent: Wednesday, October 02, 2002 1:48 PM
To: SQR-USERS@list.iex.net
Subject: Re: Conversion from legacy system


You don't need to write two different programs in the case of different
databases if the 'remote' db supports ODBC. The 'remote' db doesn't need an
SQR engine.  See the -DB argument in the begin-select documentation.

The most important things that need to be decided ahead of time are the
'functional' questions, e.g. how do the legacy codes convert to PS?  The
users need to do massive amounts of headwork (planning) before the technical
side even picks up a pencil.  Of course, they won't even be aware of the
issues without the help of the techies.

Richard Knapp
Database Programmer/Analyst
Administrative Systems Project
University of Missouri System
573-884-3157
knappr@umsystem.edu


-----Original Message-----
From: Sengupta, Rajib (CC-Contractor)
[mailto:Rajib.Sengupta@CONAGRAFOODS.COM]
Sent: Wednesday, October 02, 2002 1:26 PM
To: SQR-USERS@list.iex.net
Subject: Re: Conversion from legacy system


There are couple of things which you have to decide before going with this:
The approach will be different if you are moving from one database/platform
to another database/platform then between the same platform.
Approach a.
a. Moving from legacy(I assume this is IBM mainframe or OS/390 and database
DB2 or file system VSAM ) to Peoplesoft in UNIX/ORACLE
   In that case I guess you will not have the SQR engine to run in
mainframe. Then what you have to do is to create your mainframe program ,
cobol or any other mainframe tools to create text files of data from DB2 or
VSAM. Then transfer it to Unix. Then write your SQR program to upload it.
This SQR program will have all the conversion rules. Say for e.g in Psoft
HRMS- a company which use SSN number for employee identification - they have
to change it to Peoplesoft ID by using some logic. Similarly in financial
say some company have do not have SETID - in that case they have to create
the SETID to craete data in Peoplesoft tables. And all this will be done in
the SQR program. So there is not one single SQR program which can do this.
There are couple of peoplesoft delivered SQRs with different module which
you can use as template.

b. Moving from legacy to same platform - i.e peoplesoft will be installed in
same platform i.e say OS/390 and database DB2
  In that case you might right one SQR to do both task- i.e read from old
files /tables and write it into new peoplesoft tables. This will require
running the SQR in the same LPAR of the mainframe. Though the better idea
will be to craete two different programs - first program will dump all data
into a text file. The second SQR will do the upload with the conversion.
I have tried to give an idea how it works- the conversion of data is a very
imporatnt project while implementing peoplesoft and this can't be done just
by one people or sqr - it requires a whole conversion group which should
consists of analysts from old legacy system who knows the existing system
well along with peoplesoft functional and technical people. The technology
of choosing SQR or App.engine or cobol is not the issue , the issue is
defining the business process and conversion process first .

Thanks,
Rajib Sengupta
Systems Analyst
ConAgra Business Systems
Peoplesoft AR and Order Management
222 South 15th St,North Tower(CT-930)
Omaha NE 68102
Phone: (402) 595-7928,Fax: (402) 595-7024




-----Original Message-----
From: kadevari madhukethan [mailto:madoo6@YAHOO.COM]
Sent: Wednesday, October 02, 2002 11:06 AM
To: SQR-USERS@list.iex.net
Subject: Conversion from legacy system


Hello SQR Gurus,

I am working on conversion of data from legacy system
into peoplesoft
systems and what i thought of using SQR for conversion
or Interface
for exracting data from legacy system.Now my question
is can any of
the gurus share there idea as how to begin writing SQR
Conversion
program or any sample conversion program is greatly
appreciated to my
email OR is there any other tool used in conversion or
interface
instead of SQR to make my job easy.please help me
ASAP.

THANKS IN ADVANCE

Madhu

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com