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 [...]
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 [...]
I’m currently building a warehouse using ODI, so I’ll share some findings as it goes. And there’s be Cognos BI on top of it and EP is one of the sources, so I’m still close to the roots ) Disclaimer: I’m Oracle & ODI n00b — there are (?) better ways of accomplishing these tasks [...]
on DMR’s pros and cons
on DMR’s pros and cons on DMR’s pros and cons
on DMR’s pros and cons on Macro functions and prompts in Cognos BI reports