What is most valuable?
It can do so much more than just load data. It can basically automate any task that you can think of, such a executing scripts for servers outside of your Oracle environment, executing any task that the IT team wishes to execute can be done via ODI. I created a button on a user’s machine once, this button executed only her job in ODI regardless of all the other jobs that were created. I love working with ODI because it tests your thought limits and creativity and the possibilities are endless when it comes to innovative tasks.
How has it helped my organization?
I work in a consulting role but I believe that by implementing it a lot of organizations’ manual processes have been automated
What needs improvement?
With ODI there is a lot of manual work to be done with the initial setup.
For how long have I used the solution?
I've been using it for four years.
What was my experience with deployment of the solution?
There were no issues with the deployment.
What do I think about the stability of the solution?
We've experienced no issues with performance.
What do I think about the scalability of the solution?
It's been able to scale for our needs.
How are customer service and technical support?
99% of the time we do our own trouble shooting.
Which solution did I use previously and why did I switch?
I started with this product.
How was the initial setup?
The initial setup was rather complex but I knew what I needed to do to achieve the end result. There are also allot of reading material on these products if you get stuck
What about the implementation team?
We used an in-house team. My advice would be to know what you want to achieve with the tool because it is very flexible.