ODI Snippets: Installing multiple ODI agents on one server

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Sometimes it may come in handy to have multiple agents running on the same server, e.g. if you want to use a particular agent to execute scenarios for a particular project. I had a requirement recently where users were dropping Excel ...

Losing timestamp in ODI when using ojdbc14.jar

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes The ojdbc14.jar version of the JDBC driver is losing timestamp information when returning DATE datatypes from Oracle. As per Oracle JDBC driver FAQ this is a known issue. As a workaround it is suggested to set the oracle.jdbc.V8Compatible JDBC parameter to ...