#1 most frequent
United States of America
62.4%357 installations of 572
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
Categories & Use Cases
Videos
Top Performing Features
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.8
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.1
Complex transformations
Complex data transformations are data normalization, advanced data parsing, etc.
Category average: 7.2
Areas for Improvement
Business rules and workflow
Ability to define and manage business rules and workflows
Category average: 8.3
Integration with MDM tools
Integration with master data management tools to ensure data consistency across the organization
Category average: 7.8
Collaboration
Collaboration is enabled by a shared repository of project information and metadata
Category average: 7.4
Who Buys & Uses Oracle Data Integrator (ODI)
#2 most frequent
Canada
4.4%25 installations of 572
#3 most frequent
United Kingdom of Great Britain and Northern Ireland
4.2%24 installations of 572
ODI Tool for Huge Data
Pros
- The User Interface is pretty neat and clean which is very easy to use.
- There are a lot of transformation options available to choose from.
- The scalability and performance are top notch.
Cons
- The cost part is bit high as compared to its peers.
- Sometimes there is a lag and it gets hanged.
- Real time data Integration cannot be handled.
Return on Investment
- This has made our whole process much more efficient.
- Customer service is positively impacted.
- Business process has been improved tremendously.
Other Software Used
Snowflake, Google Cloud AI, Google Cloud IoT
What i think about Oracle Data Integrator
Pros
- Extract, transform and load the data
- Work well with large volume of data
- Use with multiple sources
Cons
- Bit difficult to use as compare to other tools
- Sometime feels slowness while working
Return on Investment
- It is bit costly as compare to other tools in same category.
- If you have good technical experience in ODI then you can implement effective solution for problems
Alternatives Considered
MuleSoft Anypoint Platform and Alteryx Platform
Other Software Used
Alteryx Platform, Microsoft Power BI, Microsoft SQL Server
Oracle Data Integrator is great for any ETL use cases
Pros
- High-volume, batch load ETL processes
- Data transformations before data warehousing
- Flexible big-data extractions
Cons
- More easily used in other clouds/platforms
- More features in UI
- Updated flow of ETL processes in UI
Return on Investment
- Cleaner data loaded into BI platform
- Refined data inside data warehouse
- High-quality reporting using dashboards after ETL from Oracle Data Integrator
Alternatives Considered
Trifacta
Other Software Used
Google Cloud Spanner, Google Cloud SQL, Google Cloud Storage
Oracle Data Integrator review
Pros
- There are enough aggregate functions to design a Data Warehouse. In this way, summary tables can be created.
- Works compatible with Oracle databases. By making ODBC connections, database connections are made more stable.
Cons
- The end user interface of Oracle Data Integrator ETL can be made simpler and more convenient.
- Oracle external database connections are time out after a certain period of time. Therefore, data transfers can be disrupted.
Return on Investment
- I think it's a useful product to be able to make data warehouse and ETL designs. It is exceptionally compatible with Oracle databases.
- I think the data transfer performance is adequate. With different scenarios, it is possible to increase data transfer performance with Oracle Data Integrator product.
Alternatives Considered
SQL Server Integration Services and Pentaho
Other Software Used
Microsoft SQL Server, Pentaho, PostgreSQL, Microsoft Power BI, MongoDB, Oracle Database 12c, Visual Studio IDE, NetBeans
Oracle Data Integrator enthusiast!
Pros
- Complex transformations.
- Compatibility with almost any knows valid source.
- Suited for batch loading processes.
Cons
- Small bugs related to Java.
- The user interface is not intuitive.
- The complexity of the tool makes difficult to find qualified people in the market.
- Expensive.
Return on Investment
- Because of its architecture, ODI requires fewer hardware resources (compared to other ETL tools on the market).
- Expensive, but it's worth it.
