Oracle Data Integrator--a great tool for Oracle users
Rating: 8 out of 10
IncentivizedUse Cases and Deployment Scope
Oracle Data Integrator is a very good ETL tool that can be used for many different business cases. We currently use it as an ETL application that ties into many of our backend systems. It helps us connect with many systems with the great integrations it has and gives us the ability to closely tie our data together. We use this for our data teams currently which then gets used for reports, etc. to make workflow and processes more streamlined.
Pros
- It is well integrated within the Oracle ecosystem
- Great product for data cleansing and virtualization
- Can have everything done in one tool in most cases
- It has great scalability/performance
Cons
- Oracle support is not the best when needing help with the system
- The documentation is also very poor and takes very long to generate
- Some parts of it are not intuitive to use and get hard to troubleshoot
- Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
- Like all Oracle products, cost is high
Likelihood to Recommend
Oracle Data Integrator is best used for data warehousing, master data management, data migration, big data integration, and application integration. If you have an environment that is in the Oracle platform, this tool also works great with it. We have been using it as an ETL tool to get data from the different Oracle systems we have, and it works great. However, it does not work great with different environments if you have multiple types of systems. You will find yourself buying more than one application to satisfy your needs.
Vetted Review
5 years of experience