We performed a comparison between SnapLogic and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a scalable solution."
"The initial setup is very straightforward."
"The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."
"The solution is easy to implement and easy to use. It's basically just drag and drop."
"It's more developer-friendly, and development can be done at a faster phase."
"SnapLogic is more user-friendly than Boomi in terms of debugging. You can move the mouse to a place, and it will record and show the data easily."
"They are very good at building out new aspects according to customer requirements."
"It is a stable solution."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"Overall, it's a good product."
"SSIS' best feature is SFTP connectivity."
"The solution is stable."
"It has good data integration and good processes."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The scalability of SSIS is good."
"The support is the most important improvement they could make."
"The dashboards regarding scheduled tasks need further improvement."
"We'd like zero downtime in the future."
"We'd like there to be more ways for users to get more comfortable and have more experience with the solution to make it easier to use."
"They should expand in terms of features for SaaS-based market requirements in different sectors."
"There is room for improvement with APM management and how task execution looks."
"One of the areas for improvement in SnapLogic is that the connectors for some of the applications should be more available in terms of testing in the dev environment. Another area for improvement is that the logging should be standardized, for example, the integration with an ELK stack should be required out-of-the-box, so you can ship the log and have it in the ELK stack. There should be integration with ELK stack for the log shipping."
"Ultra Pipelines provides real-time ingestion but it needs some adjustment."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"This solution needs full support for real-time processing."
"It hangs a lot of the time."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Generic processes should be used instead of custom code for each table."
SnapLogic is ranked 14th in Data Integration with 20 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SnapLogic is rated 8.0, while SSIS is rated 7.6. The top reviewer of SnapLogic writes "Easy to set up, easy to use, and is low-code". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SnapLogic is most compared with Azure Data Factory, AWS Glue, IBM InfoSphere DataStage, Informatica Cloud Data Integration and Matillion ETL, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Boomi AtomSphere Integration. See our SSIS vs. SnapLogic report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
Snaplogic
I've found Matillion to be very intuitive and easy to use...
I wish I could answer that question, but my expertise is limited to SSIS only.
As far as I know 'talend' could be a better choice compare to the other tools.
you can address your question to our SAP department solutions@jet-bi.com
Informatica is the way forward
it depends on the infrastructure you are using and what's the total cost of ownership being authorized for the implementation. You can see the "Data Integration" partners within AWS-Redshift in the below link-
aws.amazon.com
Informatica undoubtedly is one of the best in the list. It's a great ETL tool but surely expensive in License.
Microsoft's SSIS is a light weight tool but not as robust as Informatica. Certain other software's like Talend and Matillion are also good. Talend has an open source option where developers can build their own APIs and then productionize those APIs and that's cost effective as well.
Traditionally SQL is a plus, automation is only by a ETL is smarter.
Any ETL tool that moves data to it's own server for processing will add overhead and will not use Redshift's power ( more specifically parallelism). It is recommended to use standard SQL for data processing.