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.
BI DWH Bala
asked Nov 25 '09 at 07:28 PM in Default
BI DWH BALA
Using heterogeneous services (using ODBC) to access DB2 will work too.
I wouldn't recommend it for production environments with more than small spontaneous data exchange.
answered Nov 26 '09 at 07:52 AM