Apache Sqoop vs. Datameer

Sqoop is great for sending data between a JDBC compliant database and a Hadoop environment. Sqoop is built for those who need a few simple CLI options to import a selection of database tables into Hadoop, do large dataset analysis that could not commonly be done with that database system due to resource constraints, then export the results back into that database (or another). Sqoop falls short when there needs to be some extra, customized processing between database extract, and Hadoop loading, in which case Apache Spark's JDBC utilities might be preferred

Incentivized

Datameer's workbooks include an intuitive GUI for maximum usability. Anyone with an analytical mind may easily compile data using the built-in worksheet capability without requiring much technological knowledge. Ad hoc reports may now be made and scheduled. In addition, I haven't had too much problem fixing things because I can get most of the answers I want there.

Incentivized

• Provides generalized JDBC extensions to migrate data between most database systems
• Generates Java classes upon reading database records for use in other code utilizing Hadoop's client libraries
• Allows for both import and export features

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.

• Sqoop2 development seems to have stalled. I have set it up outside of a Cloudera CDH installation, and I actually prefer it's "Sqoop Server" model better than just the CLI client version that is Sqoop1. This works especially well in a microservices environment, where there would be only one place to maintain the JDBC drivers to use for Sqoop.

Incentivized

• Data visualization and graphics. Right now it's not very user friendly. Creating dashboards requires a lot of work that can be done by the application

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.

• Sqoop comes preinstalled on the major Hadoop vendor distributions as the recommended product to import data from relational databases. The ability to extend it with additional JDBC drivers makes it very flexible for the environment it is installed within.
• Spark also has a useful JDBC reader, and can manipulate data in more ways than Sqoop, and also upload to many other systems than just Hadoop.
• Kafka Connect JDBC is more for streaming database updates using tools such as Oracle GoldenGate or Debezium.
• Streamsets and Apache NiFi both provide a more "flow based programming" approach to graphically laying out connectors between various systems, including JDBC and Hadoop.

Incentivized

I have compared Datameer with the tools listed above and it blows them out of the water. Datameer is much more user friendly than these tools and is also a lot more powerful. Once the Q1 release comes out with drill down capabilities on the infographics, Datameer will surpass Tableau and Spotfire in visualization.

• When combined with Cloudera's HUE, it can enable non-technical users to easily import relational data into Hadoop.
• Being able to manipulate large datasets in Hadoop, and them load them into a type of "materialized view" in an external database system has yielded great insights into the Hadoop datalake without continuously running large batch jobs.
• Sqoop isn't very user-friendly for those uncomfortable with a CLI.

Incentivized

• Quick time to value. Transition from developer to learning Datameer is less than a day.
• Workspace is drag and drop, which makes it intuitive and easy to use.
• Speed of data transformations.
• Pulling data from various sources.
• Easy to schedule data pipelines.
• Tailor made for Snowflake and Redshift.
• Documentation is sometimes not updated quickly.
• Training videos are a bit long.