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

Azure Data Factory

Suitable for virtually any scenario that involves working with linked Service, so that it is possible to connect Azure Data Factory to storage services for SQL data in the cloud, and that it is possible to access them at any time. Serves to make the information much cleaner and have the desired formats and structures in case of working with time tracking or general employee work tracking applications, so it is easy to create accurate and aesthetically acceptable analysis for general tracking software. It is extremely useful if you do not have any data server service, as Azure Data Factory has the ability to maintain almost 90 different data connectors without the need to use a server.
Murray Clear | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

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

Data Transformations

Actian DataConnect
9.5
Azure Data Factory
8.1
Simple transformations
Actian DataConnect
10.0
Azure Data Factory
8.8
Complex transformations
Actian DataConnect
9.0
Azure Data Factory
7.3

Data Modeling

Actian DataConnect
8.0
Azure Data Factory
8.7
Data model creation
Actian DataConnect
8.0
Azure Data Factory
9.3
Metadata management
Actian DataConnect
8.0
Azure Data Factory
8.0
Business rules and workflow
Actian DataConnect
8.0
Azure Data Factory
8.6
Collaboration
Actian DataConnect
8.0
Azure Data Factory
9.0
Testing and debugging
Actian DataConnect
8.0
Azure Data Factory
8.4
feature 1
Actian DataConnect
8.0
Azure Data Factory
9.0

Data Governance

Actian DataConnect
9.0
Azure Data Factory
8.3
Integration with data quality tools
Actian DataConnect
8.0
Azure Data Factory
8.5
Integration with MDM tools
Actian DataConnect
10.0
Azure Data Factory
8.2

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 create ETL workflows
  • Pre-defined templates to design the pipelines
  • Easy to create schedules to run the pipelines
  • Fast and reliable
  • Interactive user interface with drag/drop and multiple useful options on the dashboard
  • Easy integration with other Azure services
Panav Beri | 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

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 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

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

The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.
Niloofar Keshvari Nia | 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

Azure Data Factory

  • It is very useful and make things easier
  • Debugging can improve
  • Its better suited than other products with the same objective
Marco Urrea | TrustRadius Reviewer

Screenshots

Pricing Details

Actian DataConnect

General

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

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
8.8

Support Rating

Actian DataConnect
8.0
Azure Data Factory
7.0

Add comparison