Communication between Oracle and SQL Server

[DBA_LUCAS]

Good afternoon friends,

I need to communicate between two distinct databases, I need to integrate between an Oracle database and a SQL Server database, where my Oracle database will insert data into the SQL Server database.

Does anyone know how to tell me a way to do this?

Thanks,

ATT,

[Trevisolli]

Brother, blzinha?

Dude, give a search (I do not know if it's the best way, so it's the open topic for our DBA's Opinion Amibos) about Heterogenous Services.

Maybe you can get this connection.

take a look at these links below, perhaps help:
[url=http://dbaforums.org/oracle/index.php?showtopic=4808]http://dbaforums.org/oracle/index.php?showtopic=4808 [url=http://www.dba-oracle.com/t_database_li ... oracle.htm]http://www.dba-oracle.com/t_database_li ... oracle.htm [url=http://www.dba-oracle.com/t_heterogeneo ... server.htm]http://www.dba-oracle.com/t_heterogeneo ... server.htm

Anything, send us.

[dr_gori]

Another way (which I am studying for these days) is to use the Oracle Data Integrator tool. (ODI).
My project is just to connect a SQL * server with Oracle, and we opted to use this tool, since in the EBS we already have that license.

I still pick up for her, but I can already say that this tool can integrate anything with anything! (Whatever type of database, text, web services, etc.)

[Trevisolli]

Brother,

would have any books of odi to make it available to us?
You may need to use here and, without matrial.
Thank you very much.

[dr_gori]

I have not found any good enough book.

has this site in SQL * magazine that gives us some noises: http://www.devmedia.com.br/websys.2/web ... _68#a-1807
has the blog of Odi Brasil: http://http://www.odibrasil.com.br/
But the main one, which I am studying is the very documentation that comes in ODI.
(when installing, has a document only directory)