Yes you need to build a connection between the SQL database and the Oracle database.. Since you say Remedy is installed on SQL this is simple as MS-SQL has built in drivers for the Oracle database that will allow you to do this..
Upon building this connection, you can either build a db link to the Oracle database or use a feature of MS-SQL called DTS (data transformation services) that would allow you to copy the data from oracle to a local SQL table on a schedule basis, which would mean that this option would not allow for an online access of the latest data. Once you have these db links or external tables created, you can create a view form from Remedy to view this foreign data... If you are new to Remedy, look up information on building a View form in Remedy.. One of the primary requirements is that it should have at least one key that can qualify to the the Request ID by being a unique key, character field of greater than 5 and less than or equal to 15 characters.. Also make sure that all your character fields are Varchar2. You will need to convert Oracle Date time columns to Unix date time Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of El-Noor Rashid Sent: Friday, April 04, 2008 10:52 AM To: [email protected] Subject: Remedy Installed on DB1 but data from DB2 ** Folks, Any help is appreciated on this. Facts --------------- -- Remedy Server is installed with MS SQLServer which has useful data. -- There is an Oracle DB on another box that has other important data. Question --------------- -- Can we build forms that use the data from the Oracle DB? -- Is that native to how Remedy works? -- Is this something that we need to configure in MS SQLServer? -- Has anyone had any experience with this? -- When you use direct SQL in Remedy filters/active links it will use MS SQLServer, can we somehow get the data Oracle DB? I think this involves MS SQLServer config more than Remedy? We are non-profit organization, but I am willing to look at products that do this and of course read any documentation? Thank you - El-Noor No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.5/1359 - Release Date: 4/4/2008 8:23 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
