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

Informatica Intelligent Cloud Services

[Informatica Intelligent Cloud Services] is very well suited for all the organizations with huge amount of data. This also can amazingly migrate all your Legacy system data into the cloud. This is very easy to learn because of normal drag and drop functionality.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.0
Informatica Intelligent Cloud Services
Connect to traditional data sources
Actian DataConnect
10.0
Informatica Intelligent Cloud Services
Connecto to Big Data and NoSQL
Actian DataConnect
8.0
Informatica Intelligent Cloud Services

Data Transformations

Actian DataConnect
9.5
Informatica Intelligent Cloud Services
Simple transformations
Actian DataConnect
10.0
Informatica Intelligent Cloud Services
Complex transformations
Actian DataConnect
9.0
Informatica Intelligent Cloud Services

Data Modeling

Actian DataConnect
8.0
Informatica Intelligent Cloud Services
Data model creation
Actian DataConnect
8.0
Informatica Intelligent Cloud Services
Metadata management
Actian DataConnect
8.0
Informatica Intelligent Cloud Services
Business rules and workflow
Actian DataConnect
8.0
Informatica Intelligent Cloud Services
Collaboration
Actian DataConnect
8.0
Informatica Intelligent Cloud Services
Testing and debugging
Actian DataConnect
8.0
Informatica Intelligent Cloud Services
feature 1
Actian DataConnect
8.0
Informatica Intelligent Cloud Services

Data Governance

Actian DataConnect
9.0
Informatica Intelligent Cloud Services
Integration with data quality tools
Actian DataConnect
8.0
Informatica Intelligent Cloud Services
Integration with MDM tools
Actian DataConnect
10.0
Informatica Intelligent Cloud Services

Cloud Data Integration

Actian DataConnect
Informatica Intelligent Cloud Services
8.6
Pre-built connectors
Actian DataConnect
Informatica Intelligent Cloud Services
8.6
Connector modification
Actian DataConnect
Informatica Intelligent Cloud Services
8.5
Support for real-time and batch integration
Actian DataConnect
Informatica Intelligent Cloud Services
9.2
Data quality services
Actian DataConnect
Informatica Intelligent Cloud Services
8.5
Data security features
Actian DataConnect
Informatica Intelligent Cloud Services
8.5
Monitoring console
Actian DataConnect
Informatica Intelligent Cloud Services
8.3

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

Informatica Intelligent Cloud Services

  • Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
  • The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
  • The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.
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

Informatica Intelligent Cloud Services

  • Some of the error messages are cryptic and difficult to discern the meaning and cause of the error
  • The ability to use sophisticted and complex SQL is somewhat limited
  • Some of the syntax for the built-in data formatting is a little difficult to understand
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

Informatica Intelligent Cloud Services

Informatica Intelligent Cloud Services 8.0
Based on 6 answers
I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.
Anonymous | TrustRadius Reviewer

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

Informatica Intelligent Cloud Services

First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.
Vaibhav Khanna ☁⚡ | 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

Informatica Intelligent Cloud Services

  • Cut costs on the number of staff we need for data import.
  • Cut costs for automation that can be done for data that no longer has to be manually imported.
  • We've saved countless dollars by eliminating duplicates in our system with this tool.
Anonymous | TrustRadius Reviewer

Pricing Details

Actian DataConnect

General

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

Informatica Intelligent Cloud Services

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
Informatica Intelligent Cloud Services
8.6

Likelihood to Renew

Actian DataConnect
Informatica Intelligent Cloud Services
9.0

Support Rating

Actian DataConnect
8.0
Informatica Intelligent Cloud Services
8.0

Add comparison