TrustRadius

Oracle Data Integrator (ODI) vs. Striim

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Oracle Data Integrator (ODI)
Score 6.2 out of 10
N/A
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.N/A
Striim
Score 8.3 out of 10
N/A
Striim is an enterprise-grade platform that offers continuous real-time data ingestion, high-speed in-flight stream processing, and sub-second delivery of data to cloud and on-premises endpoints.
$4,400
per month per 100 million Striim events
Pricing
Oracle Data Integrator (ODI)Striim
Editions & Modules
No answers on this topic
Striim Cloud Enterprise Platform
$4,400
per month per 100 million Striim events
Striim Platform
$20,000
per year per VCPU
Offerings
Pricing Offerings
Oracle Data Integrator (ODI)Striim
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Oracle Data Integrator (ODI)Striim
Considered Both Products
Oracle Data Integrator (ODI)
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
This is very easy to integrate with Oracle data sources and as most of my databases are in oracle so I gave preference to this tool.
Cameron Gable | TrustRadius Reviewer
Cameron Gable
Software Engineer III
Chose Oracle Data Integrator (ODI)
I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
Oracle Data Integrator works very well if the rest of your systems are in the Oracle environment. There are some other good alternatives out there, but for what Oracle Data Integrator has to offer, it is good. It is also a little harder to use compared to the other ones I have …
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
We were using Actian Pervasive before switching to Oracle and the main reason was the cost. We were getting less functionality at even more cost. Although it is much faster in terms of operation, Oracle makes it easy to connect to all data sources making data integration easier …
zahit bogus | TrustRadius Reviewer
zahit bogus
Business Intelligence Consultant
Chose Oracle Data Integrator (ODI)
I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user …
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
Powerful features and Oracle based
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
I think that Oracle Data Integrator is much better because of the user interface it provides.
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
Chose Oracle Data Integrator for its compatibility and integration with Oracle Goldengate
Ashwini Chandorkar | TrustRadius Reviewer
Ashwini Chandorkar
Senior Analyst
Chose Oracle Data Integrator (ODI)
ODI is best suited for Oracle Hyperion environments. We have also used it to manage files on different operating systems.
Paolo Borghi | TrustRadius Reviewer
Paolo Borghi
Oracle Business Intelligence Consultant
Chose Oracle Data Integrator (ODI)
Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, …
Jérôme Françoisse | TrustRadius Reviewer
Jérôme Françoisse
Data Integration Lead
Chose Oracle Data Integrator (ODI)
ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle database.
Unlike Informatica, ODI generates all the code in the native underlying …
Gurcan Orhan | TrustRadius Reviewer
Gurcan Orhan
Senior Solutions Architect
Chose Oracle Data Integrator (ODI)
Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment.
  • Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler.
Ely Turkenitz | TrustRadius Reviewer
Ely Turkenitz
IS Manager, Data Services
Chose Oracle Data Integrator (ODI)
We migrated to ODI from OWB - and we found ODI to be light years ahead of OWB (features, performance, and connectivity). We also looked at Informatica, but were turned down by its cost. Being a SAP Business Objects shop, we also considered the SAP Data Integrator tool (it …
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
Oracle's own ETL tool was Oracle Warehouse Builder, initially. When Oracle built the Oracle Business Intelligence Applications Suite, Oracle is in need of a strong ETL. As Oracle Warehouse Builder is not a strong ETL that customers prefer and as already Informatica captured …
Chose Oracle Data Integrator (ODI)
We thought IBM was too expensive and more difficult to use. With Microsoft, since we have our main application running with Oracle DB, we understood it’d be easier for us to work with ODI.
Samir Patel, PMP | TrustRadius Reviewer
Samir Patel, PMP
SQL Development Team Lead
Chose Oracle Data Integrator (ODI)
Oracle Data Integrator is a superior tool when dealing with Hyperion Planning and Essbase cubes and applications. The native connectors allow for easy data movement and transformations from one environment to the other. I do believe that Oracle Data Integrator is a very complex …
James Parks | TrustRadius Reviewer
James Parks
Technology Consultant
Chose Oracle Data Integrator (ODI)
Informatica was slightly more intuitive but slightly less powerful than Oracle Data Integrator. My use of Informatica was much less extensive than Oracle Data Integrator, so I can not speak as in-depth about the strengths and weaknesses of Informatica. We used ODI much more for …
Chose Oracle Data Integrator (ODI)
ODI is less user friendly than FDM and DRM but is much easier to deploy than core ETL tools such as HAL or Informatica. The tool is easier to master and is usually more than capable of handling the run of the mill tasks required for Hyperion deployments. It has been a good …
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
IBM Infosphere, Informatica. I worked on the mentioned tools as well as ODI. I liked ODI because it is easy to use with great features that every other ETL tool has in the market.
Verified User
Anonymous
Chose Oracle Data Integrator (ODI)
Our organization was using the Oracle BPM and the Oracle Data Integrator has good integration with BPM. We got good support from Oracle in setting up the integrated environment.
Striim
Chose Striim
Faster, checkpointing better. CDC works well. The loading is faster. Easy upgrade and installation. Uses less resource.
Features
Oracle Data Integrator (ODI)Striim
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Oracle Data Integrator (ODI)
9.6
Ratings
13% above category average
Striim
10.0
Ratings
18% above category average
Connect to traditional data sources9.90 Ratings10.00 Ratings
Connecto to Big Data and NoSQL9.30 Ratings10.00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Oracle Data Integrator (ODI)
9.9
Ratings
19% above category average
Striim
8.9
Ratings
9% above category average
Simple transformations9.90 Ratings10.00 Ratings
Complex transformations9.90 Ratings7.80 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Oracle Data Integrator (ODI)
9.2
Ratings
14% above category average
Striim
8.5
Ratings
6% above category average
Data model creation9.30 Ratings8.40 Ratings
Metadata management9.50 Ratings8.40 Ratings
Business rules and workflow9.10 Ratings9.00 Ratings
Collaboration8.50 Ratings7.80 Ratings
Testing and debugging9.30 Ratings7.20 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Oracle Data Integrator (ODI)
9.1
Ratings
11% above category average
Striim
9.5
Ratings
16% above category average
Integration with data quality tools9.50 Ratings9.00 Ratings
Integration with MDM tools8.70 Ratings10.00 Ratings
Best Alternatives
Oracle Data Integrator (ODI)Striim
Small Businesses
Skyvia
Skyvia
Score 9.9 out of 10
Skyvia
Skyvia
Score 9.9 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Oracle Data Integrator (ODI)Striim
Likelihood to Recommend
8.0
(0 ratings)
8.8
(0 ratings)
Likelihood to Renew
10.0
(0 ratings)
-
(0 ratings)
Implementation Rating
7.0
(0 ratings)
-
(0 ratings)
User Testimonials
Oracle Data Integrator (ODI)Striim
Likelihood to Recommend
I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write
Verified User
Anonymous
Read full review
Below samples are the well suited use cases; - Change data capture feature seamlessly works on popular RDMS. You can make enrichments on several data sources within the same Striim application. - You can install stand alone agents and start streaming log files to Striim servers. This is mainly useful for security operations or audit trail use cases.
Verified User
Anonymous
Read full review
Pros
  • Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
  • Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
  • Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.
Verified User
Anonymous
Read full review
  • GoldenGate Trail reader which iss faster than Oracle CDC. It does not used logminer, hence there is no load on source Oracle database.
  • Easy installation and upgrade in 5 minutes
  • Support is very good. Fast and user friendly.
RJ
Read full review
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
Verified User
Anonymous
Read full review
  • License a bit expensive
RJ
Read full review
Likelihood to Renew
It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
Verified User
Anonymous
Read full review
No answers on this topic
Alternatives Considered
Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.
Paolo Borghi | TrustRadius Reviewer
Paolo Borghi
Oracle Business Intelligence Consultant
Read full review
Faster, checkpointing better. CDC works well. The loading is faster. Easy upgrade and installation. Uses less resource.
RJ
Read full review
Return on Investment
  • Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
  • Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
  • Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.
James Parks | TrustRadius Reviewer
James Parks
Technology Consultant
Read full review
  • We got the license at a discount price
RJ
Read full review
ScreenShots