We are currently in the process of

[ChrisRAnthony]

We are currently in the process of programming a CRM staging solution and have a problem connecting from Oracle to SQL Server 2000.
For phase 1 of the project there will be a Siebel database that will look after customer creation across four busines units, with four separate legacy systems (two on Oracle and two on SWL server). When a customer record is created / update in Siebel it will pass a record to the staging server which in turn will determine which legacy systems/s need to be updated. A trigger will fire a stored procedure that will send the data to the chosen legacy system. Connectivity has been gained to all the servers databases sing linked servers.

However whilst two of the SQL server systems are able to communicate we cannot find a way of getting Oracle to talk back to SQL server. All the Oracle drives which enable us to get the linked server connectivity have been installed, but the DBA cannot find a way without purchasing software, to get Oracle to talk back. Oracle have not released a new version of the software to allow Oracle to talk to SQL.

Has anyone had any experience of this typer of scenario, and what advice can they offer?

Chris R Anthony

 

[mattisontara]

We use DTS packages to get info out of Oracle into SQL server. But as far as I know, you have to use SQL to query Oracle. I don't know of a way to get Oracle to talk to SQL server. Maybe you can change your methodology a bit to get this to work. Have a trigger fire off a dts package that gets the data you need?