Azure Data Factory vs. ibi Data Migrator vs. Skyvia

Azure Data Factory is a great data integration tool for developing a cloud data platform, especially within the Azure ecosystem. Azure Data Factory is very good for the Data Ingestion part. It can work for simple data transformation with its Data Flow, but it will also need cluster configuration, and there is some cost. Also, it is an excellent tool for orchestrating data pipelines. But for complex data transformations, you may need to use technologies like Databricks and PySpark.

Incentivized

A great tool for both prototyping and developing models to extract or query of data. When you don't have a specialised developer for pulling data, Skyvia is great solution. Very affordable for us. We did not find any areas where Skyvia let us down so very happy to recommend it to other users.

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

Incentivized

• Skyvia is good at scheduled bidirectional data integration to/from multiple sources
• The mapping is done automatically which saves a lot of time
• I like that all connectors are included in the price, so I don't have to pay for using some new ones additionally

Incentivized

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

Incentivized

• If there's something they can improve could be cheaper prices for LaTam
• They can market their services in a larger scale, globally.
• They can market their services in a larger scale, globally.

So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.

Incentivized

Loved using Skyvia for our projects, it saved time, allowed us to reach the desired outcome quickly and was easy to maintain. When we first used it we weren't sure we would be able achieve the outcome desired but during the trial it was quickly obvious we would be able to achieve what we needed for data connection and reporting.

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

Incentivized

I think guys have a really good support team, and even from different time zones we managed to get worthy support.

Azure Data Factory is more of a universal pipeline. SAP BW is a tool offering good SAP connectivity but very limited third-party connectivity. The same is the case with BW4hana. SAP Datasphere is offering better connectivity with SAP sources, but not so good when compared to adf. Power Center of Informatica is a legacy tool, and Anaplan is a planning tool with limited connectivity options.

Incentivized

Compared to similar user-friendly data integration systems like Integrate.io, Stitch, or Azure, Skyvia still wins in the number of connectors and pricing policy. Skyvia is a tool for companies like ours, starving for simple but, at the same time, robust and cost-effective data transfer solutions. It doesn't require additional knowledge for implementation and usage because it's no code. We'd recommend Skyvia as the best solution for non-technical staff.

Incentivized

• Cost Savings: By automating our ETL processes with Azure Data Factory, we've reduced manual data handling by approximately 60%. This translates to savings from reduced man-hours and the overhead of maintaining legacy systems.
• Timeliness: Our report generation time has reduced by 70% with Azure Data Factory's scheduled pipelines. Faster insights mean quicker decisions for us, enabling our teams to capitalize on time-sensitive opportunities. We can easily share the data visualizations to all stakeholders.

Incentivized

• The core of our business lies in analyzing data from various sources, and while ETL itself is not our primary focus, it is a necessary process to achieve our goals. Thanks to Skyvia, we are able to streamline the ETL process at a reasonable price, allowing us to dedicate our efforts to data analysis without the burden of ETL complexities.

Incentivized