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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: External MS SQL Data/SMS
Hi John, What platform are you using for Oracle? If your Oracle is under Windows try using tg4msql. Otherwise you can still use a tg4msql, but you will need an intermediate Oracle-on-Windows instance. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kovalcik Sent: Wednesday, April 11, 2007 4:26 PM To: arslist@ARSLIST.ORG 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
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: arslist@ARSLIST.ORG 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. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.2.0/756 - Release Date: 4/10/2007 10:44 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: External MS SQL Data/SMS
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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