Devart Excel Add-ins

Score9.4 out of 10

33 Reviews and Ratings

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

Data Integration

Media

1 / 4

Data model creation
Ability to create and maintain data models using a graphical tool to define relationships between data
Category average: 8.4
Connecto to Big Data and NoSQL
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Category average: 7.6
Metadata management
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
Category average: 7.5

Integration with data quality tools
Integration with tools for cleansing, parsing and normalizing data according to business rules
Category average: 7.4
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7.2
Complex transformations
Complex data transformations are data normalization, advanced data parsing, etc.
Category average: 7.4

Rohit Kumar View profile

Director HR in Human Resources at MNR Solutions Private limited (51-200 employees employees)

Use Cases and Deployment Scope

We were using different cloud and RDBMS to build apps. We were facing issue while capturing data in Excel. We were searching some tools which help us in automation. To get data, we always ask our MIS team to create a report and build dashboards. Also for CSV format is a pain.

Pros

Automated the whole process.
Create a direct live pipeline.
Visual Query building.
Data Validation, Pivot, Charts.

Cons

Only good for small to medium database
Role based security
Audit logs

Return on Investment

Now we don't need a large MIS team to generate reports
Time saving and cost effective
Good for mid level companies

Usability

Alternatives Considered

Dose for Excel, Excel Database Tasks (EDT) and Engage2Excel

Other Software Used

Akrivia HCM, Oracle APEX, AWS Chatbot

Scott Kennedy View 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

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

Devart Excel Add-ins

What is Devart Excel Add-ins?

Categories & Use Cases

Media