3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 3.3 out of 101
93 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Actian Pervasive Data Integrator

I wouldn't recommend Data Integrator over SSIS, but it may be a better tool than other ETL offerings. Having a background in the Microsoft Stack, I am hesitant to recommend any other products especially in a Microsoft-centric company. If this was the only option to use, I think it does a good job at integrating systems after taking time to learn the approach. "Maps" in Data Integrator is definitely different than "process flow" philosophy in SSIS.
Justin Duperre profile photo

Oracle Data Integrator

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
No photo available

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Oracle Data Integrator
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Oracle Data Integrator

Data Transformations

Actian Pervasive Data Integrator
7.0
Oracle Data Integrator
Simple transformations
Actian Pervasive Data Integrator
9.0
Oracle Data Integrator
Complex transformations
Actian Pervasive Data Integrator
5.0
Oracle Data Integrator

Data Modeling

Actian Pervasive Data Integrator
4.3
Oracle Data Integrator
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Oracle Data Integrator
Collaboration
Actian Pervasive Data Integrator
3.0
Oracle Data Integrator
Testing and debugging
Actian Pervasive Data Integrator
5.0
Oracle Data Integrator

Platform-as-a-Service

Actian Pervasive Data Integrator
Oracle Data Integrator
7.1
Ease of building user interfaces
Actian Pervasive Data Integrator
Oracle Data Integrator
7.3
Scalability
Actian Pervasive Data Integrator
Oracle Data Integrator
8.2
Platform management overhead
Actian Pervasive Data Integrator
Oracle Data Integrator
6.4
Workflow engine capability
Actian Pervasive Data Integrator
Oracle Data Integrator
8.2
Platform access control
Actian Pervasive Data Integrator
Oracle Data Integrator
7.3
Development environment creation
Actian Pervasive Data Integrator
Oracle Data Integrator
7.3
Development environment replication
Actian Pervasive Data Integrator
Oracle Data Integrator
7.3
Issue monitoring and notification
Actian Pervasive Data Integrator
Oracle Data Integrator
6.4
Issue recovery
Actian Pervasive Data Integrator
Oracle Data Integrator
6.4
Upgrades and platform fixes
Actian Pervasive Data Integrator
Oracle Data Integrator
6.4

Pros

  • Map multiple source and destination tables - what would be done in many steps in SSIS can be done in one or two "maps" in Data Integrator.
  • Platform independent, cloud based, no client software.
  • Conversion of data types, write flat files - this helps us with integrating systems.
  • Fairly straightforward to use if the user has ETL experience.
Justin Duperre profile photo
  • It's fast. If you have used OWB before, you will notice how much faster ODI is.
  • The Knowledge Modules (KMs) are extremely useful.
  • Integrates really well with the rest of the Oracle Technology Stack (GoldenGate, WebLogic, OEM, and, of course, the Oracle Enterprise Database).
Ely Turkenitz profile photo

Cons

  • Sometimes the screen does not load- since it is a web based software, this can be seen as a reliability issue.
  • "Maps" can become somewhat complex, and between multiple developers this can be painful when sharing or explaining others' work.
  • The concept of macros adds flexibility in how to solve problems, but is a separate language and can take time to learn and master.
Justin Duperre profile photo
  • When you develop on ODI studio, you need to restart the program as it occupies a lot of RAM.
  • It is not meant for real time data integration.
  • It is hard to maintain the security setup.
Ashwini Chandorkar profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Oracle Data Integrator10.0
Based on 4 answers
ODI is very good tool for the small business and less complex transformation but when I have a big client and their requirement is complex then chances are that I would recommend Informatica instead of ODI.
No photo available

Alternatives Considered

Data Integrator was initially a part of a package deal for us with our new Student Information System. It was chosen prior to my arrival at the institution. Since I discovered we have SQL Server licenses, we have decided to use SSIS instead since I have a background in the MSBI stack and SSIS appears to be more straightforward (process flow philosophy vs "map" philosophy.)
Justin Duperre profile photo
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 offers data lineage capability that could be very valuable) - but since our entire data platform is running on Oracle, we preferred staying with Oracle. Once ODI 12g came out with the OWB to ODI migration tool, it was a no-brainer.
Ely Turkenitz profile photo

Return on Investment

  • This tool was chosen prior to my arrival and was used to build three integrations. We have decided to switch to SSIS since we have licenses for it and it is a more common tool for ETL integrations.
  • It has been difficult to network with individuals that have experience with this tool.
  • Having been a part of a software package purchased, we have chosen to use a different tool for future integrations and plan to rewrite existing integrations.
Justin Duperre profile photo
  • Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up.
  • Reduced lead time helped in reducing project cost as less resources were spent in data conversion project.
  • Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.
No photo available

Pricing Details

Actian Pervasive Data Integrator

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Oracle Data Integrator

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details