servers (Oracle)

I'm interested in linking to an Oracle 8i database that is storing
data for a COTS program we are using which does not support the
detailed level of reporting that my organization needs. Anybody have
any tips or advise for this type of operation?
--
HTH
Dale FyePretty broad question... in general it's doable. Queries
with linked servers aren't necessarily known for their
blazing speed but whether that impacts you or not, too hard
to say. You'd have options with this but it all depends on
what will work for your data, your requirements, your
hardware/network, number of users, general use, latency
tolerance, security requirements, etc.
You could look at OpenQuery to do pass-through queries, you
could look at loading the Oracle data needed during off
hours. There are a lot of different ways you could approach
it all depending on what the business, technical needs are.
-Sue
On Mon, 20 Oct 2003 10:34:27 -0400, "Dale Fye"
<spam.saic.com@.nomore.dale.fye> wrote:
>I'm interested in linking to an Oracle 8i database that is storing
>data for a COTS program we are using which does not support the
>detailed level of reporting that my organization needs. Anybody have
>any tips or advise for this type of operation?|||I guess that was a little cryptic.
The Oracle database is the backend for an Commercial product.
Unfortunately, the organization I work for is interested in
investigating the level of usage of the product and generating reports
on these issues, a function that is not provided by the product,
although it does have a table which records many admin defined
transactions. Since I don't need real-time access to the data, we
anticipate migrating the data from the Oracle db to SQL Server (our db
of choice) each night, but would prefer to do an incremental update of
the SQL db rather than wiping the tables and copying the entire tables
worth of data each night.
I'm open to ideas(DTS, Linked Server, or any other options that might
be available) for this relatively simple process. Unfortunately, we
have no one with any Oracle experience.
--
HTH
Dale Fye
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:k3o8pv03dohhacnfd8q1naa1p5tdrurt47@.4ax.com...
Pretty broad question... in general it's doable. Queries
with linked servers aren't necessarily known for their
blazing speed but whether that impacts you or not, too hard
to say. You'd have options with this but it all depends on
what will work for your data, your requirements, your
hardware/network, number of users, general use, latency
tolerance, security requirements, etc.
You could look at OpenQuery to do pass-through queries, you
could look at loading the Oracle data needed during off
hours. There are a lot of different ways you could approach
it all depending on what the business, technical needs are.
-Sue
On Mon, 20 Oct 2003 10:34:27 -0400, "Dale Fye"
<spam.saic.com@.nomore.dale.fye> wrote:
>I'm interested in linking to an Oracle 8i database that is storing
>data for a COTS program we are using which does not support the
>detailed level of reporting that my organization needs. Anybody have
>any tips or advise for this type of operation?|||If you were asking...yes you can do incremental updates. You
could use dts and insert the Oracle records that don't exist
in the SQL Server tables. If you had a date time value
updated for modifications on the Oracle side, you can use
this to compare for any changes, needed updates as well.
-Sue
On Tue, 21 Oct 2003 08:49:10 -0400, "Dale Fye"
<spam.saic.com@.nomore.dale.fye> wrote:
>I guess that was a little cryptic.
>The Oracle database is the backend for an Commercial product.
>Unfortunately, the organization I work for is interested in
>investigating the level of usage of the product and generating reports
>on these issues, a function that is not provided by the product,
>although it does have a table which records many admin defined
>transactions. Since I don't need real-time access to the data, we
>anticipate migrating the data from the Oracle db to SQL Server (our db
>of choice) each night, but would prefer to do an incremental update of
>the SQL db rather than wiping the tables and copying the entire tables
>worth of data each night.
>I'm open to ideas(DTS, Linked Server, or any other options that might
>be available) for this relatively simple process. Unfortunately, we
>have no one with any Oracle experience.