InterSystems IRIS vs. Oracle Warehouse Builder

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
InterSystems IRIS
Score 7.8 out of 10
N/A
InterSystems IRIS is a complete cloud-first data platform that includes a multi-model transactional data management engine, an application development platform, and interoperability engine, and an open analytics platform. It is is the next generation of InterSystems' data management software. It includes…N/A
Oracle Warehouse Builder
Score 8.7 out of 10
N/A
Oracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.N/A
Pricing
InterSystems IRISOracle Warehouse Builder
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
InterSystems IRISOracle Warehouse Builder
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
Additional Details
More Pricing Information
Community Pulse
InterSystems IRISOracle Warehouse Builder
Features
InterSystems IRISOracle Warehouse Builder
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
InterSystems IRIS
-
Ratings
Oracle Warehouse Builder
9.5
5 Ratings
15% above category average
Connect to traditional data sources00 Ratings10.05 Ratings
Connecto to Big Data and NoSQL00 Ratings9.02 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
InterSystems IRIS
-
Ratings
Oracle Warehouse Builder
10.0
5 Ratings
22% above category average
Simple transformations00 Ratings10.05 Ratings
Complex transformations00 Ratings10.04 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
InterSystems IRIS
-
Ratings
Oracle Warehouse Builder
8.2
5 Ratings
5% above category average
Data model creation00 Ratings10.04 Ratings
Metadata management00 Ratings6.04 Ratings
Business rules and workflow00 Ratings9.04 Ratings
Collaboration00 Ratings8.94 Ratings
Testing and debugging00 Ratings7.04 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
InterSystems IRIS
-
Ratings
Oracle Warehouse Builder
8.0
3 Ratings
2% above category average
Integration with data quality tools00 Ratings8.03 Ratings
Integration with MDM tools00 Ratings8.02 Ratings
Best Alternatives
InterSystems IRISOracle Warehouse Builder
Small Businesses
Google Cloud SQL
Google Cloud SQL
Score 8.8 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
Google Cloud SQL
Google Cloud SQL
Score 8.8 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
SAP IQ
SAP IQ
Score 10.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
InterSystems IRISOracle Warehouse Builder
Likelihood to Recommend
7.5
(44 ratings)
8.0
(5 ratings)
Likelihood to Renew
8.2
(1 ratings)
-
(0 ratings)
Usability
8.2
(3 ratings)
-
(0 ratings)
Support Rating
7.4
(4 ratings)
-
(0 ratings)
Implementation Rating
8.2
(1 ratings)
-
(0 ratings)
User Testimonials
InterSystems IRISOracle Warehouse Builder
Likelihood to Recommend
InterSystems
Intersystems IRIS is a really great tool for Interoperability. It has so many capabilities out of the box and then such a great developer community on top of that, that there are really no limits to what you can do in terms of data manipulation and translation. Personally I find it to be a great tool if you are looking for Interoperability software.
Read full review
Oracle
The best place for Oracle Warehouse Builder is at the business IT level. It's not suited for business-level users. They are easy confused. One way to reduce the confusion for the developers is to set up the workspaces based on the requirements that are discovered in design sessions. Once this is complete, the implementation of Oracle Warehouse Builder can take flight and be successful.
Read full review
Pros
InterSystems
  • Connecting with mutliple vendor platforms and systems allowing us to consume and provide data as needed.
  • Allowed us to implement our own RESTful api engine to server data to our internal applications.
  • Setting up their recommendations for high availability allow us to perform server maintenance with minimal down time to our users.
Read full review
Oracle
  • Easy transformation.
  • Easy implementation from Oracle to Oracle systems.
  • Ease of usage and easy to learn.
  • Starting component of metadata management.
Read full review
Cons
InterSystems
  • Enhanced documentation, more comprehensive and user-friendly documentation, including detailed tutorials and examples
  • Improving compatibility and integrations with others programming languages
  • Introducing tools and techniques to optimize the performance of ObjectScript applications, such as profiling tools, performance monitoring utilities, and code optimization guidelines
  • A better compatibility with Python libraries
Read full review
Oracle
  • What I noticed is that sometimes OWB doesn't generate the best SQL in the package especially when there are a high number of source tables in the ETL. It would be nice if ETL developers were allowed to update the generated packages in the database directly.
  • Another thing - moving OWB ETLs from one database to another one could be easier - for example it would be nice to just copy the generated packages from one database to the other one without doing the deployment of these ETLs through OWB.
Read full review
Usability
InterSystems
The interface is very intuitive, the documentation is very good so it is not complicated to operate.
The security is complex, but you can create a special role to access and the user ONLY can operate with the part that it allows.
Also, you can examine the data very quick with the SQL Browser integrated.
Read full review
Oracle
No answers on this topic
Support Rating
InterSystems
The InterSystems WRC has always been helpful and responsive. The folks I have spoken with are always understanding of our needs and questions and regardless of if the question is simple or complex we are always met with the same professionalism and helpfulness every time. I have no hesitations contacting InterSystems for help!
Read full review
Oracle
No answers on this topic
Implementation Rating
InterSystems
Will done based on a proper planning, so this will makes execution more easier and better.
Read full review
Oracle
No answers on this topic
Alternatives Considered
InterSystems
We are using InterSystems IRIS [especially] for database operations as the query performance is really good for [a large] amount of customer data. You can easily integrate for any application like web, desktop, and many more. It also provides BI functionality which is also very easy to implement using InterSystems IRIS[.]
Read full review
Oracle
Ab>initio, IBM Datastage 8.0
Read full review
Return on Investment
InterSystems
  • Very Fast and scalable software to deal with big data flow, safe and robust.
  • The studio IDE is quite old fashion and lacks a few facilities
  • amazing for complex data consumption, its milyi-model capability wich allows multiple different models for a single set of codes.
Read full review
Oracle
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Read full review
ScreenShots