Re: connectivity - integration Oracle - SQL server

On Fri, 07 Nov 2003 20:42:54 +0100, ITAPORT06 <mokat67_at_hotmail.com> wrote:

>I have a question about connectivity between different databases.
>Oracle, DB2400 and SQL_server.
>
>It is easy to integrate application products that are running on
>different DB platforms?

No. Likely you are just using the lowest common denominator.

>What products can be used to achieve this? Our consultant is
>mentioning .NET but then we have to run everything on SQL server.
>
>Currently we are running on Oracle but our third party generic
>applications are first developed for SQL server and later ported to
>Oracle (So Oracle has no priority for them)

And usually when a Sql server app is just 'ported', it will proof to be a nightmare for Oracle.

>
>We are now looking to additional applications that are only available
>on SQL server and we like to integrate these applications in our
>current environment that is running on Oracle DB. The information I
>get is that the integration is much easier to achieve with products
>like MS .NET if all the application will run on SQL server
>Oracle seems to be less open.

This is just utter nonsense. Which Microsoft products work *properly* with third party databases? NONE.

Do not get me wrong with less open: I
>mean that there are less integration products or programmer skills
>available on the market.
>

This is also just utter nonsense
Luckily the universe doesn't stop with Microsoft, but apparently you haven't a clue about the Oracle market.

>We can choose to migrate totally for SQL server. Additional info: We
>run on Win2000. Hardware platforms like Unix is no issue)
>

Guess you will most benefit from locking yourself in the closed world of Microsoft.

>What is your opinion?

--
Sybrand Bakker, Senior Oracle DBA