Skyvia vs. SQL Server Integration Services (SSIS) vs. Zoho Flow

1. It can be connected to slack for companies that uses that system. 2. Also can be connected to Google Drive to share information from spreadsheets and csv data. 3. It works efficiently with WordPress websites which are the most used platform for web development. 4. It connects ORACLE's databases with different systems online and that's very useful.

As I mentioned earlier SQL Server Integration Services is suitable if you want to manage data from different applications. It really helps in fetching the data and generating reports. Its automation make it very easy and time efficient. It works well with large database as well. But it doesn't work well with real time data, it will take some time to gather the real time data. I would not recommend using it in a real time/fast-paced environment.

Incentivized

For small—to medium-sized connections between different applications, Zoho Flow is quick and easy to set up and test. However, as a Flow becomes more complicated with multiple connections and decisions, it becomes more difficult to track errors and faults and manage changes. Some of this is due to the history not being detailed enough, and some is just the UI, where you can't zoom in and out and clearly see connecting lines for flows.

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

• Standard ETL use cases for daily loads
• Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
• Creating outgoing data files and writing them to Vendor FTPs
• Easy Active Directory integration for seamless connections to SQL Server
• CI/CD by hosting the code on visualstudio.com

Incentivized

• Works with all other Zoho apps to connect them together and share data
• User interface and dashboard are nice. Gives you a detailed look into flow history and/or audit of your flows
• The ability to set logic responses and incorporate custom functions makes the app even more powerful

Incentivized

• Increased ability for asymmetric process window changes.
• Continue to integrate into new applications with the same quality.
• Add some automation options in the tree.

Incentivized

• Connection managers for online data sources can be tricky to configure.
• Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
• Mapping destination using OLE DB command is difficult as destination columns are unnamed.
• Excel or flat file connections are limited by version and type.

Incentivized

• Some history is missing, and not all error reporting is comprehensive enough on more complex functions.
• The ability to run tests on custom functions exists in other apps like CRM.
• Ability to create custom connections for OAuth like in the CRM application.

Incentivized

Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure

Incentivized

Because as a developer and programmer is very easy to work with and provides many options to very complex problems. It provides guides for integration that are very useful and makes us save a lot of money and time on integrations. Also Skyvia is constantly adding more data systems on their lists for us to provide as web managers.

SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.

Incentivized

Flow can accomplish almost anything you want to do. It's imperfect, but it could be with just a few more features and better error management/visibility. For someone who's not a developer, this is a no-brainer. Having used other products in the past, like Zapier, this is as easy to use, if not even easier.

Incentivized

SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.

Incentivized

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

The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.

Incentivized

I've reached out to the support team several times with assistance requests in Zoho Flow. Each time the team has answered my questions promptly and accurately. And because we are mainly integrating other Zoho apps their teams are perfectly positioned to solve our problems.

Incentivized

The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools

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

I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer

Incentivized

I've used Zapier and both programs are similar. Zapier has deeper integrations or more apps to integrate with but considering Flow's association with other Zoho apps this does it for us!

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

• Without this, we would have to manually update a spreadsheet of our SQL Server inventory
• We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
• We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.

Incentivized

• Quick and Easy to set up without the need for a Developer.
• Visibility into the history of flows and the ability to rerun is a big time saver.

Incentivized