Swanand, you can ask your DBA team to create views of the Remedy tables to put real table names instead of numbers. Remedy may have already done some of this work for you. In my 6.3 system, there are some existing views with real names. If you can do that, wouldn't you be able to dump the 6.3 server but keep the database? Then use a view form to look at the data. This differs from Misi's suggestion in that the db is external. If you load the data into your ITSM system, you won't have to maintain that extra database.
This is partly related - when we go after the views created by Remedy, using the ODBC client, we only see a few fields per table. I'm guessing that the Remedy 6.3 ODBC setup doesn't play well with the much newer OS/Office software. I hope this helps. Drew SCAB, Honduras On Thu, Aug 11, 2011 at 9:40 PM, Swanand <swanand.deshpa...@gmail.com>wrote: > Hello, > > We have put our old Remedy Legacy System ( 6.3) system in read only mode > after the ITSM launch last year in July. We are now working on > decommissioning the old Remedy system but we need to keep the data in the > Remedy system intact for auditing / reporting purpose. The version of the > Remedy we are running on is dependent upon PA-RISC processor which HP > doesn't sell any more. So if the hardware was to fail and we were beyond > vendor support , we would not be able to restore remedy on another HP > Server. > > So we are exploring options to pull Remedy report / data without going > through the application server. The data we are targeting is from Helpdesk > and Change forms and its associated join forms. > > One way to get the data from Oracle is via Oracle ODBC (DB is Oracle) and > as per our reporting team's suggestion creating reports using Oracle ODBC > from Crystal will not be feasible as some of the data stored in database > tables are in numbers. E.g date fields, date in Work log field and drop > down fields. > > Is there any better way ( using some tools / utilities) to pull this data > from AR Schemas on Oracle database? > > Did any of you face this scenario when your company was migrating from 6.3 > to 7.x? > > I would really appreciate for your valuable suggestion here. > > Note: Our current ARS version is 7.5 and ITSM version is 7.6.00 but in 2 > weeks time we will be on AR 7.6.04 SP1 and ITSM 7.6.04 SP1. Our new database > is oracle > > Thanks...Swanand > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
