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