Java Development Tools

Hi,

In my application I need to use two different databases like Oracle and SQL Server. There are screens I need to develop in ADF where I need to involve fields of tables from these two different databases. I just want to know is it possible to do it in ADF application?

Or we need to create some kind of link between these databases in the back-end? And then create a View Object involving some distributed SQL query. What all I can do with this kind of query? I mean, can i use both insert or update operation using such VO?

Or is there some other way to do this?

Please assist, some help here would really be appreciated. I've been stuck with this issue for sometime now. I did seach our forums for this issue, but was not able to reach to some reliable solution.

Thanks,
Vijay