Datameer vs. Devart Excel Add-ins

Datameer is a great tool if someone is capable of keeping the most recent version of the tool up to date along with the most recent version of the distribution of Hadoop. The tool is easy to support but it must have someone who can run the back end processes

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.

Incentivized

• It leverages scalability, flexibility and cost-effectiveness of hadoop to deliver an end-user focused analytic platform for big data without involvement of IT.
• It overcomes Hadoop`s complexity by providing GUI interface with pre-built functions across integration, analytics and data visualization .
• Excel feature is awesome for business users which is already provided by Datameer.
• Using datameer now user can do smart analytic using Decision Trees, Column dependency and recommendation.
• Recently HTML5 inclusion is making application to available on a wider range of devices, including the iPad and other mobile devices which does not support Flash.
• It can be used in premise or in a cloud computing environment.
• Wizard-based data integration designed for IT and business users to schedule and do transformation of large sets of structured, semi-structured and unstructured data without any knowledge of Hadoop ecosystem.

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

Incentivized

• Concentration issues are possible while using a lot of tabs at once.
• In most cases, the length of a tutorial video is excessive.
• A more condensed design is certainly a viable option.

Incentivized

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

Incentivized

Employees with intermediate SQL and Hive knowledge can generate reports faster than using Datameer . It does have visualization tool but I don't think it is anything that cannot be accomplished by importing the data in Excel

Easy to use for most things, starts to require some planning as your projects get more complex.

Pricing, support, and ease of use. We plan to scale up our data over the net few years and Datameer gives us all the things we need in one tool. Handles large transformations quickly and works with all the cloud data warehouses.

Datameer's per-user pricing sealed the deal for us as we plan to transfer much more data over the next few years. We looked at Fivetran but the usage pricing discourages growth. We also looked at Informatica but it was too expensive and didn't work as well with other BI tools like Datameer does.

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.

Incentivized

• We have not been able to reach our business objectives just yet.
• Hadoop its a hard sell in most companies still.
• Legacy skills are still highly on demand and as long as an easier path leverage SQL for example is available, it would be hard to gain more adoption.

Incentivized

• 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

Incentivized