Outsourcer 2.9 contains enhancements for Oracle connections.
First, Outsourcer now supports ROWID and UROWID properly. In both cases, these Oracle data types are converted to VARCHAR in Greenplum.
Secondly, Oracle internally stores an Integer as a Numeric which doesn’t perform in Greenplum as a true Integer. Outsourcer now correctly identifies an Integer in Oracle.
The last enhancement is in the JDBC connection. Instead of using the SID, Outsourcer now uses the SERVICE NAME which supports Oracle Connection Manager.
Link to new download => OS_2_9.zip
Link to new documentation => Outsourcer_Administrator_Guide_2_9