I would suggest purchasing the BMC Remedy Link for SQL Server http://www.bmc.com/products/proddocview/0,2832,19052_19429_43060234_1235 78,00.html If you ever wanted to go the other way you can get BMC Remedy for Oracle. Thanks
Kelly Gatewood ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, April 11, 2007 10:12 To: [email protected] Subject: Re: External MS SQL Data/SMS ** There are JDBC drivers available for a few $'s that provide you external cross database connectivity. You would need to buy one that provides support for connectivity between Oracle and MS-SQL.. Other than this Gidd has a plugin which I think might work for you.. but you would need to contact him or his company for it. Gidd's product is specifically designed for the ARS and might eliminate the need for you to define your database links etc when you use a JDBC driver to connect to the external database. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of John Kovalcik Sent: Wednesday, April 11, 2007 8:26 AM To: [email protected] Subject: External MS SQL Data/SMS Listers, What is the easiest way to access SMS data that resides in an external MS SQL database ? All I want to do is read the data. Our current environment is ARS 6.3 and Oracle 10g. Thanks, John M. Kovalcik Kennametal Inc. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
