(Uli Bethke) ODI comes with an LKM to extract data from another Oracle database instance using db links via a view that is created at the source system.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help