TrustRadius: an HG Insights company

Devart Excel Add-ins

Score9.3 out of 10

33 Reviews and Ratings

Get a Demo

What is Devart Excel Add-ins?

Devart Excel Add-ins allow you to use Excel capabilities to import, process, and analyze data from cloud applications and relational databases. The Excel Add-ins also allow users to make data changes and then save those changes back to the data source they were originally imported from.

Categories & Use Cases

Media

1 / 4

Reviews

What users are saying about Devart Excel Add-ins.
View all reviews

Devart is a great tool for the cost

Incentivized
Scott KennedyView profile
Director, eCommerce Analytics and Digital Marketing in Marketing at Franklin Sports (201-500 employees employees)

Pros

  • Source control
  • Unit testing
  • Schema comparisons

Cons

  • The data pump feature breaks sometimes
  • The profile usage monitoring is slow
  • The event profiler is delayed

Return on Investment

  • 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

Alternatives Considered

Oracle Data Integrator and Zapier

Other Software Used

Workato, Zapier, IFTTT

Devart excel add-in review

Incentivized
Verified User
Analyst in Information Technology (10,001+ employees employees)

Pros

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

Cons

  • It has room for improvement in terms of security and making it possible for large organizations like us to use it in a more secure way with integrating with our in-house security systems.
  • Pricing could be reduced further for it to be adopted world-wide.
  • it isn't foolproof. Excel has no means of checking for human error during data entry, which means that the wrong information can skew all the results - sometimes severe.
  • Users unfamiliar with Excel syntax may also find entering calculations and calling up other functions a bit frustrating until they get a solid understanding.

Return on Investment

  • It had a positive ROI as we used it on its strengths. We could save time and make some of our processes simpler.
  • It does help us up to a certain limit - but it acts as a part of our general IT infrastructure. It cannot solve our direct business objectives.
  • It cannot be expanded in all directions as we need a lot more native coding and IT infrastructure.

Alternatives Considered

ASAP Rent, Rakuten Attribution and Invantive Query Tool

Other Software Used

Salesforce Analytics Cloud, Avidian CRM, Base CRM, Azure SQL Database