question

BI DWH BALA avatar image
BI DWH BALA asked

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

oracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Christian13467 avatar image
Christian13467 answered

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.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

BI DWH BALA avatar image BI DWH BALA ·
Hi Christian13467, thanks for your valuable inputs.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.