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

Devart Excel Add-ins

Devart Excel Add-ins is really good for data comparison of one database table against another database table. There are plenty of times where the business users need help understanding with their Power BI data models are not connecting correctly and I use this tool to break down the differences between the tables they are trying to connect.
Scott Kennedy | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.0
Devart Excel Add-ins
Connect to traditional data sources
Actian DataConnect
10.0
Devart Excel Add-ins
Connecto to Big Data and NoSQL
Actian DataConnect
8.0
Devart Excel Add-ins

Data Transformations

Actian DataConnect
9.5
Devart Excel Add-ins
Simple transformations
Actian DataConnect
10.0
Devart Excel Add-ins
Complex transformations
Actian DataConnect
9.0
Devart Excel Add-ins

Data Modeling

Actian DataConnect
8.0
Devart Excel Add-ins
Data model creation
Actian DataConnect
8.0
Devart Excel Add-ins
Metadata management
Actian DataConnect
8.0
Devart Excel Add-ins
Business rules and workflow
Actian DataConnect
8.0
Devart Excel Add-ins
Collaboration
Actian DataConnect
8.0
Devart Excel Add-ins
Testing and debugging
Actian DataConnect
8.0
Devart Excel Add-ins
feature 1
Actian DataConnect
8.0
Devart Excel Add-ins

Data Governance

Actian DataConnect
9.0
Devart Excel Add-ins
Integration with data quality tools
Actian DataConnect
8.0
Devart Excel Add-ins
Integration with MDM tools
Actian DataConnect
10.0
Devart Excel Add-ins

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

Devart Excel Add-ins

  • Devart Excel Add-in supports connectivity with various databases - which really helps to customize and massage data.
  • Since data is available in cloud, it is easily accessible everywhere.
  • It can also be integrated with SSIS components making it possible to resolve complex problems.
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

Devart Excel Add-ins

  • The data pump feature breaks sometimes
  • The profile usage monitoring is slow
  • The event profiler is delayed
Scott Kennedy | 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

Devart Excel Add-ins

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

Devart Excel Add-ins

Devart Excel stacks up very well against its alternatives. It has significant advantages as it keeps getting an update. Features are very much suitable for smaller organizations. For larger organizations the features cannot be used directly because of the size of the company and more native requirements of IT software requirements.
Anonymous | 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

Devart Excel Add-ins

  • The data compare option saves our dev team a lot of time
  • The documenter feature is nice to use for explaining table definitions
  • The event profiler is great for usage metrics
Scott Kennedy | TrustRadius Reviewer

Screenshots

Actian DataConnect

Pricing Details

Actian DataConnect

General

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

Actian DataConnect Editions & Modules

Additional Pricing Details

Devart Excel Add-ins

General

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

Devart Excel Add-ins Editions & Modules

Edition
Standard Edition119.95
    Additional Pricing Details

    Rating Summary

    Likelihood to Recommend

    Actian DataConnect
    8.0
    Devart Excel Add-ins
    8.0

    Support Rating

    Actian DataConnect
    8.0
    Devart Excel Add-ins

    Add comparison