What users are saying about
5 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8 out of 100
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.4 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

Azure Data Factory

If you are just getting started and all your data is resident in the Azure cloud, then Azure Data Factory is likely to work fine without having to jump through too many hoops. However, in a hybrid environment (which is most of them these days), ADF will likely need a leg up. It works well for scheduling and basic scheduling/orchestration tasks, but the feature set is not at a level with SSIS (which has been around for 15 years so...). As ADF now supports deploying SSIS, it is also a good candidate if large amounts of your data are resident in the Azure cloud and you have an existing SSIS investment in code and licensing. We are using it in a hybrid fashion for the data warehouse and will slowly transition over to ADF as the feature set improves. We are also using it for cloud-native applications that only require supplemental data from on-prem resources
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.0
Azure Data Factory
7.0
Connect to traditional data sources
Actian DataConnect
10.0
Azure Data Factory
6.0
Connecto to Big Data and NoSQL
Actian DataConnect
8.0
Azure Data Factory
8.0

Data Transformations

Actian DataConnect
9.5
Azure Data Factory
6.5
Simple transformations
Actian DataConnect
10.0
Azure Data Factory
8.0
Complex transformations
Actian DataConnect
9.0
Azure Data Factory
5.0

Data Modeling

Actian DataConnect
8.0
Azure Data Factory
6.0
Data model creation
Actian DataConnect
8.0
Azure Data Factory
Metadata management
Actian DataConnect
8.0
Azure Data Factory
Business rules and workflow
Actian DataConnect
8.0
Azure Data Factory
6.0
Collaboration
Actian DataConnect
8.0
Azure Data Factory
Testing and debugging
Actian DataConnect
8.0
Azure Data Factory
6.0
feature 1
Actian DataConnect
8.0
Azure Data Factory

Data Governance

Actian DataConnect
9.0
Azure Data Factory
6.0
Integration with data quality tools
Actian DataConnect
8.0
Azure Data Factory
7.0
Integration with MDM tools
Actian DataConnect
10.0
Azure Data Factory
5.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

Azure Data Factory

  • Easy to set up and get started.
  • Runtimes make integration with on-prem data simple and also allow for support of existing investments in SSIS.
Anonymous | TrustRadius Reviewer

Cons

Actian DataConnect

  • Pace of implementation
  • Individualized training
Kyle Moninger | TrustRadius Reviewer

Azure Data Factory

  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Anonymous | TrustRadius Reviewer

Support Rating

Actian DataConnect

Actian DataConnect 8.0
Based on 1 answer
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

Azure Data Factory

Azure Data Factory 7.0
Based on 2 answers
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
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

Azure Data Factory

Azure Data Factory is a relatively new player in the space, and its feature set marks it as such. It does not have the full features of a more mature product set such as any of the above. However, it does allow for the creation of ETL/ELT flows/pipelines with minimal initial training. I would actually consider it a more approachable product for a first time ETL developer (with the possible exception of AbInitio, which is highly intuitive). If you are an Azure shop, you at least want to look into it. If you're not, stick with one of the more mature offerings, or a 3rd party cloud-based tool that spans clouds. We are an Azure shop with an SSIS lineage, so it makes sense for us.
Anonymous | TrustRadius Reviewer

Return on Investment

Actian DataConnect

  • Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment.
  • Problems are fairly easy to handle and rework.
David Byrd | TrustRadius Reviewer

Azure Data Factory

  • Limiting the amount of data moving up and down from the cloud for cloud-native applications.
  • Overall simple to use interface which is actually easier for a first time ETL developer than SSIS.
Anonymous | TrustRadius Reviewer

Pricing Details

Actian DataConnect

General

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

Azure Data Factory

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
Azure Data Factory
7.0

Support Rating

Actian DataConnect
8.0
Azure Data Factory
7.0

Add comparison