What is most valuable?
Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step. Easy to learn & develop.
Now, ODI has Cloud Service which you can deploy your repositories to Oracle Data Integrator Cloud Service for you to use both on prem, Big Data and cloud environments.
Oracle Data Integrator (ODI) can support any type of databases that has a jdbc driver in a native way. I have accessed and retrieve data from an Ingress database. Big data connectors are implemented to ODI 220.127.116.11 (out-of-the-box) and upper version that support many well-known Big Data architecture.
Knowledge Module architecture helps you to build your data integration activities with less effort.
You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.
Variables can help you to perform loops and conditional statements in packages for helping ETL
How has it helped my organization?
It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds.
Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
What needs improvement?
They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
For how long have I used the solution?
I've been using it for more than 10 years, since Oracle acquired Sunopsis.
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?
I've experienced no issues with performance. Since sky is the limit, you can do what you want to do within ODI in several ways.
What do I think about the scalability of the solution?
It's been able to scale for our needs. ODI will fit your needs.
How are customer service and technical support?
10. I generally create a service request per year and they are being solved within a week. Technical Support
They're very efficient.
Which solution did I use previously and why did I switch?
We switched because of ODIs impressive increasement in development productivity.
How was the initial setup?
It was straightforward and very easy. Almost the same as setup>next> next>next.
What about the implementation team?
What was our ROI?
What's my experience with pricing, setup cost, and licensing?
There are various options in licensing, either per seat or per target core count. It depends how you want to use it.
Which other solutions did I evaluate?
We also looked at Informatica Power Center, AbInitio, Business Objects Data Integrator (BODI), and SQL Server Integration Services (SSIS).
What other advice do I have?
If you want a robust, flexible solution with no extra hardware that is easy to learn, then ODI is the right product for you. ODI is a tool, that can talk or learn how to talk, with any database or operating system in its own language. This is the power of ODI.
Which version of this solution are you currently using?
10G, 11G, 12C