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"
