What is most valuable?
The main features we use and has helped us to implement our ETL process are
- Data transformation
- In memory engine
- KM customization
- User friendly GUI
- Big Data support
- Security support
- Easy deployment
- Reusable Mapping
- Multiple Target Load
- ELT Architecture
- Application Server support for other vendor servers such as IBM Websphere
How has it helped my organization?
The features that we have applied to our project has helped us reduce manual effort and increased our scalability and growth. I worked on multiple domains where requirements were adversely different. We used many ODI features to enhanced our data transformation capability.
What needs improvement?
I am personally satisfied with current version, however, I think they should be able to provide a feature where we can easily use a configuration tool for TFS, GIT etc. This is essential for code management.
For how long have I used the solution?
I've been using it for six years.
What was my experience with deployment of the solution?
We have had no issues with the deployment.
What do I think about the stability of the solution?
There have been no performance issues.
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?
9/10 Technical Support
Which solution did I use previously and why did I switch?
I have not used any other product. However, I have seen other ETL tools in use such as BODS, SOA, and Informatica and I did not like them as I did not that they were user friendly.
How was the initial setup?
It was straightforward. I used an application server for the initial setup and I did not find any challenges.
What about the implementation team?
We performed an in-house one. If you have a technical team for ODI, then they can easily perform any implementation. If not, then you should have the vendor perform your implementation.
What was our ROI?
What's my experience with pricing, setup cost, and licensing?
It is not as costly as other ETL tools.
What other advice do I have?
You should use Oracle Data Integrator for your data transformation, or at the very least give it a try.