What users are saying about
13 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.2 out of 100
121 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

Actian DataConnect

If your company houses a lot of data locally and needs to free up space, the Actian DataConnect Hybrid Cloud Data Warehouse is an excellent solution for the price. It also allows for complex queries and even some basic data analytics, like Market Basket Analysis. Their free trial period is extremely convenient and you may discover more uses for it than you originally think.
Kyle Moninger | TrustRadius Reviewer

Oracle Data Integrator

Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
Paolo Borghi | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.0
Oracle Data Integrator
Connect to traditional data sources
Actian DataConnect
10.0
Oracle Data Integrator
Connecto to Big Data and NoSQL
Actian DataConnect
8.0
Oracle Data Integrator

Data Transformations

Actian DataConnect
9.5
Oracle Data Integrator
Simple transformations
Actian DataConnect
10.0
Oracle Data Integrator
Complex transformations
Actian DataConnect
9.0
Oracle Data Integrator

Data Modeling

Actian DataConnect
8.0
Oracle Data Integrator
Data model creation
Actian DataConnect
8.0
Oracle Data Integrator
Metadata management
Actian DataConnect
8.0
Oracle Data Integrator
Business rules and workflow
Actian DataConnect
8.0
Oracle Data Integrator
Collaboration
Actian DataConnect
8.0
Oracle Data Integrator
Testing and debugging
Actian DataConnect
8.0
Oracle Data Integrator
feature 1
Actian DataConnect
8.0
Oracle Data Integrator

Data Governance

Actian DataConnect
9.0
Oracle Data Integrator
Integration with data quality tools
Actian DataConnect
8.0
Oracle Data Integrator
Integration with MDM tools
Actian DataConnect
10.0
Oracle Data Integrator

Cloud Data Integration

Actian DataConnect
Oracle Data Integrator
7.9
Pre-built connectors
Actian DataConnect
Oracle Data Integrator
7.7
Connector modification
Actian DataConnect
Oracle Data Integrator
8.1
Support for real-time and batch integration
Actian DataConnect
Oracle Data Integrator
7.4
Data quality services
Actian DataConnect
Oracle Data Integrator
7.9
Data security features
Actian DataConnect
Oracle Data Integrator
8.0
Monitoring console
Actian DataConnect
Oracle Data Integrator
8.0

Pros

Actian DataConnect

  • The large connector base for DataConnect is outstanding. However even when they do not have a custom connector, they have a web services Invoker which allows you to connect to any web services.
  • The underlying scripting language is Visual Basic-ish. Very easy to start.
  • The product has been around a long time, through multiple company acquistions, and still is a competitive player via pricing.
  • Support team is awesome.
  • Large user community.
David Byrd | TrustRadius Reviewer

Oracle Data Integrator

  • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
  • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
  • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
  • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
Anonymous | TrustRadius Reviewer

Cons

Actian DataConnect

  • 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 | TrustRadius Reviewer

Oracle Data Integrator

  • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
  • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
  • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
James Parks | TrustRadius Reviewer

Likelihood to Renew

Actian DataConnect

No score
No answers yet
No answers on this topic

Oracle Data Integrator

Oracle Data Integrator 10.0
Based on 4 answers
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.
Anonymous | TrustRadius Reviewer

Support Rating

Actian DataConnect

Actian DataConnect 8.0
Based on 2 answers
Actian DataConnect is a great product for data storage, processing, and complex querying. It also has the added benefits of basic data analytics and data mining. We were surprised at how easy it was to perform Market Basket Analysis. I would highly recommend this system to a large business and encourage you to start a free trial period.
Kyle Moninger | TrustRadius Reviewer

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian DataConnect

As I stated earlier, DataConnect makes a head-to-head run against the others. It has advantages and disadvantages compared to the competitors. The choice really comes down to pricing and specific requirement needs for the project you are planning. Questions such as On-premise or Cloud, Security, and Specific Connectors available will drive your decision.
David Byrd | TrustRadius Reviewer

Oracle Data Integrator

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.
Cameron Gable | TrustRadius Reviewer

Return on Investment

Actian DataConnect

  • 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 | TrustRadius Reviewer

Oracle Data Integrator

  • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
  • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
  • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
Anonymous | TrustRadius Reviewer

Pricing Details

Actian DataConnect

General

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

Oracle Data Integrator

General

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

Rating Summary

Likelihood to Recommend

Actian DataConnect
8.0
Oracle Data Integrator
8.0

Likelihood to Renew

Actian DataConnect
Oracle Data Integrator
10.0

Support Rating

Actian DataConnect
8.0
Oracle Data Integrator

Implementation Rating

Actian DataConnect
Oracle Data Integrator
7.0

Add comparison