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
Improvements to 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.
Room for 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.
Use of Solution
I've been using it for six years.
We have had no issues with the deployment.
There have been no performance issues.
It's been able to scale for our needs.
Customer Service and Technical Support
9/10 Technical Support
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.
It was straightforward. I used an application server for the initial setup and I did not find any challenges.
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.
Pricing, Setup Cost and Licensing
It is not as costly as other ETL tools.
You should use Oracle Data Integrator for your data transformation, or at the very least give it a try.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jun 09 2016