Victor,

Using the AIE should get you "close" where you want to be..

Its straight forward, once you have AIE installed.. All you need to do is 
configure AIE to access the MS-SQL database using the AIE configuration console 
(its straight forward), and then create that link. You then can use AIE 
schedules to exchange data. This means that you would need a container table to 
hold that data. You cannot to the best of my knowledge create a view form 
directly to a table in MS-SQL using the AIE plugin.. So data got this way will 
not be online data but will take a while to refresh depending on your refresh 
schedules.

To create a direct connection from Oracle to MS-SQL by creating a table view of 
you would need to install the Oracle ODBC drivers. Check this article..
http://www.dba-oracle.com/t_database_link_sql_server_oracle.htm

Using JDBC to access MS-SQL. This however may not allow you to create a DB link 
from Oracle to MS-SQL
http://msdn.microsoft.com/en-us/library/ms378749.aspx

Have you considered using Web Services for whatever you want to do? Does that 
other application driven by that foreign data publish web services you could 
consume? That would be perhaps more straight forward..

There are also third party tools you may want to consider if you want data 
connections to be online and real time.. Tibco is a name that comes to my mind 
as I have used it in the past.

Hope this helps..

Cheers

Joe

  -----Original Message-----
  From: Action Request System discussion list(ARSList) 
[mailto:[email protected]]on Behalf Of Victor Olufowobi
  Sent: Monday, December 07, 2009 10:14 AM
  To: [email protected]
  Subject: View form to MS SQL database from Oracle based ARSystem


  ** 
  Listers,

  I need to create view forms to MS SQL databese to be used by ARS 7.5 with 
Oracle database.
  Do I need to create linked server from Oracle Database or can I just use 
available plugins from ARS (for example the one used by AIE)?

  Any link to relevant documentation will be appreciated

  Victor

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to