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
Best Answer
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.
