Skip to content

Tag Archives: etl

Setting up ODI file-CDC capabilities

How to set up a trick called ‘put a file in a folder and it’ll dissappear in DWH’ with Oracle Data Integrator. Imagine that we need to upload a text file in DWH whenever it appears in some folder with no defined schedule. It really easy to do in ODI: 1) Create a package with [...]

Posted 06 April 2010 † ykud § oracle ‡ Comments (0) ° Also tagged:

Oracle Data Integrator, Oracle XE and JDBC NLS problems

Since I’ve spent a day breaking through this mess, I’d share my way of getting ODI to work with XE as a repository. ODI repository creation is sucessfull, but after that Topology Manager and all other ODI modules won’t work, throwing “ORA-12705: invalid or unknown NLS parameter value specified” while connecting to XE. There are [...]

Posted 26 February 2010 † ykud § oracle ‡ Comments (3) ° Also tagged: ,