4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 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

Oracle Data Integrator is a good solution for daily data warehousing needs. It is less suitable for business requirements that demand frequent data updates. Accessing static data with Oracle Data Integrator is much simpler than trying to extract, transform, and load dynamic data. It requires a skilled development team to use, so it is more appropriate in long term solutions where a team will be available to manage the code than it is for a short term solution.
James Parks profile photo

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
  • Oracle Data Integrator is a very powerful tool. The graphical user interface simplifies the generation of complex SQL statements which can be used to extract and transform large amounts of data.
  • ODI allows users to structure and schedule packages of code. It allows you to combine data extraction and transformation sequences based on business area, relationships, or whichever design technique best suits your organization.
  • ODI is able to provide detailed logging information and send out alerts via email, simplifying the process of monitoring and debugging issues.
James Parks 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
  • Error handling is quite complicated
  • Very cumbersome user interface
  • Too much complexity makes easy jobs harder to maintain
Samir Patel, PMP 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 your power to any kind of database, operating system, big data or others.
Gurcan Orhan profile photo

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
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 tool with a steep learning curve.
Samir Patel, PMP 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