Pushing data from oracle into sql server?

[joeblow]

Hey folks,

We have our own isolated network that we keep critical and confidential
and important and all those words machines, instrumentation and data on.
On this network is an oracle 7.3 database running on solaris 2.5.1. This
is part of the primary application that is running on this 'inside'
network.

There is now a <justifiable> business need to make the data on this
database available to others on the enterprise, but we must maintain the
sanctity and reliability of the 'inside' network and data and application.

Before today, part of protecting this inside network was a policy of
'no connectivity outside, nohow, nowhere'. Obviously can't do this now.
So we've modified our policy to 'connections to outside systems shall only
be initiated from our side', and then we can do the pix firewall and
'fixup protocol' thing.

But....

The MIS folks want to use an SQL Server for the enterprise-available
database. They insist that the only way to move data from an
oracle database to an SQLServer database is that their SQLServer must
initiate a connection to our oracle and 'pull' data.

this is the method that my googling keeps bringing up as well.

I'm not seeing anywhere that tells me how to set up where oracle goes out
and connects to their sqlserver and 'pushes' our data into their
sql server database.

So, in a nutshell:

Can Oracle 7.3 initiate a connection thru a pix (fixup protocol
1521) to an sqlserver database and transfer data -into- the sqlserver? If
so, can someone provide pointers or urls where.

Many thanks in advance

[Jim Kennedy]

"joeblow" <dadude@casselout.dk> wrote in message
news:pan.2004.06.22.23.03.08.809663@casselout.dk... Hey folks, We have our own isolated network that we keep critical and confidential and important and all those words machines, instrumentation and data on. On this network is an oracle 7.3 database running on solaris 2.5.1. This is part of the primary application that is running on this 'inside' network. There is now a <justifiable> business need to make the data on this database available to others on the enterprise, but we must maintain the sanctity and reliability of the 'inside' network and data and application. Before today, part of protecting this inside network was a policy of 'no connectivity outside, nohow, nowhere'. Obviously can't do this now. So we've modified our policy to 'connections to outside systems shall only be initiated from our side', and then we can do the pix firewall and 'fixup protocol' thing. But.... The MIS folks want to use an SQL Server for the enterprise-available database. They insist that the only way to move data from an oracle database to an SQLServer database is that their SQLServer must initiate a connection to our oracle and 'pull' data. this is the method that my googling keeps bringing up as well. I'm not seeing anywhere that tells me how to set up where oracle goes out and connects to their sqlserver and 'pushes' our data into their sql server database. So, in a nutshell: Can Oracle 7.3 initiate a connection thru a pix (fixup protocol 1521) to an sqlserver database and transfer data -into- the sqlserver? If so, can someone provide pointers or urls where. Many thanks in advance
Something else could push the Oracle data out. I would recommend upgrading
Oracle to something supported like 9i. Then there are a myriad of ways to
push the data to SQLServer from Oracle.
Jim

[Greg Forestieri]

joeblow <dadude@casselout.dk> wrote in message news:<pan.2004.06.22.23.03.08.809663@casselout.dk>... Hey folks, We have our own isolated network that we keep critical and confidential and important and all those words machines, instrumentation and data on. On this network is an oracle 7.3 database running on solaris 2.5.1. This is part of the primary application that is running on this 'inside' network. There is now a <justifiable> business need to make the data on this database available to others on the enterprise, but we must maintain the sanctity and reliability of the 'inside' network and data and application. Before today, part of protecting this inside network was a policy of 'no connectivity outside, nohow, nowhere'. Obviously can't do this now. So we've modified our policy to 'connections to outside systems shall only be initiated from our side', and then we can do the pix firewall and 'fixup protocol' thing. But.... The MIS folks want to use an SQL Server for the enterprise-available database. They insist that the only way to move data from an oracle database to an SQLServer database is that their SQLServer must initiate a connection to our oracle and 'pull' data. this is the method that my googling keeps bringing up as well. I'm not seeing anywhere that tells me how to set up where oracle goes out and connects to their sqlserver and 'pushes' our data into their sql server database. So, in a nutshell: Can Oracle 7.3 initiate a connection thru a pix (fixup protocol 1521) to an sqlserver database and transfer data -into- the sqlserver? If so, can someone provide pointers or urls where. Many thanks in advance


There is a serious split between the problem you are trying to solve
and the version you own.

Let me guess they want to use ODBC.

Good luck.