Likelihood to Recommend Well-suited Scenarios for Azure Data Factory (ADF): When an organization has data sources spread across on-premises databases and cloud storage solutions, I think Azure Data Factory is excellent for integrating these sources. Azure Data Factory's integration with Azure Databricks allows it to handle large-scale data transformations effectively, leveraging the power of distributed processing. For regular ETL or ELT processes that need to run at specific intervals (daily, weekly, etc.), I think Azure Data Factory's scheduling capabilities are very handy. Less Appropriate Scenarios for Azure Data Factory: Real-time Data Streaming - Azure Data Factory is primarily batch-oriented. Simple Data Copy Tasks - For straightforward data copy tasks without the need for transformation or complex workflows, in my opinion, using Azure Data Factory might be overkill; simpler tools or scripts could suffice. Advanced Data Science Workflows: While Azure Data Factory can handle data prep and transformation, in my experience, it's not designed for in-depth data science tasks. I think for advanced analytics, machine learning, or statistical modeling, integration with specialized tools would be necessary.
Read full review 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
Read full review Pros It allows copying data from various types of data sources like on-premise files, Azure Database, Excel, JSON, Azure Synapse, API, etc. to the desired destination. We can use linked service in multiple pipeline/data load. It also allows the running of SSIS & SSMS packages which makes it an easy-to-use ETL & ELT tool. Rajarshi Maitra Director/Client Engagement Leader- P&C Insurance (Digital Transformation)
Read full review 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. Read full review Cons Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using. Does not yet have parity with SSIS as far as the transforms available. Read full review 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. Read full review Likelihood to Renew 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
Read full review Usability Easy to use for most things, starts to require some planning as your projects get more complex.
Mike Blizman Administration of Hadoop cluster - Cloudera, Datameer
Read full review Support Rating We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
Read full review Alternatives Considered The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of
Microsoft Azure products and services stack up against other similar products.
Read full review 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.
Read full review Return on Investment It is very useful and make things easier Debugging can improve Its better suited than other products with the same objective Read full review 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. Read full review ScreenShots