x

Hetrogenious services in oracle?

Hi,

I worked with hetrogenious services. The task was to extract data directly from Excel sheet as data source.. Its working fine. I did this by following Ask-Tom article.

I created a system dsn for excel then, I had done some configurations in int.ora file and so on. I was able to extract data from the sheets defined in the excel.

Now, I would like to do the same way for DB2 by creating systme dsn. Would that works? Or else do we need to install any transparent gate ways?

Please suggest me.

Regards,

BI DWH Bala

more ▼

asked Nov 25, 2009 at 07:28 PM in Default

BI DWH BALA gravatar image

BI DWH BALA
606 41 59 62

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Using heterogeneous services (using ODBC) to access DB2 will work too.
But its not fast as transparent gateway could be. Transparent gateway uses "direct" access from oracle to DB2 or SQL server. It maps from oracle directly to the specifics of destination database system. The heterogeneous services always map to ODBC and ODBC maps to destination.

I wouldn't recommend it for production environments with more than small spontaneous data exchange.

more ▼

answered Nov 26, 2009 at 07:52 AM

Christian13467 gravatar image

Christian13467
846 2

Hi Christian13467, thanks for your valuable inputs.
Nov 26, 2009 at 01:03 PM BI DWH BALA
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x378

asked: Nov 25, 2009 at 07:28 PM

Seen: 291 times

Last Updated: Nov 25, 2009 at 07:28 PM