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."The API architecture makes it easy for orchestration."
"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."
"What I found most valuable in SnapLogic is the ETL feature, particularly the Transform Snap Pack, for example, any kind of reading or writing on Transform Snaps. Other than that, all the third-party connectivity tools such as the SAP Snap Pack, Salesforce Snap Pack, Workday Snap Pack, even the ServiceNow Snap Pack, I find all those are pretty useful in SnapLogic."
"SnapLogice is a low-code development tool."
"It is a stable solution."
"The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy."
"SnapLogic is a great platform for establishing integrations among various systems or patterns by using any kind of interface. If something is not supported by predefined snaps – snaps are connectors in SnapLogic – you can create them (custom snaps) or write a script."
"It is a scalable solution."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"It's saved time using visualization descriptions."
"The performance is good."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"We'd like zero downtime in the future."
"SnapLogic should have some inbuilt protocol mechanism in order to speed up."
"The solution isn't ideal for complex processing or logic. We use another solution for that."
"It needs some more snaps. I would like to see some of the features be changed in some of the snaps."
"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."
"There is room for improvement with APM management and how task execution looks."
"I am looking for more scheduling options. When it comes to scheduling, there are different tools in the market."
"Connecting to data behind enterprise firewalls has been tricky."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"It would be nice if you could run SSIS on other environments besides Windows."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"It needs more integration tools, so you can connect to different sources."
"This solution needs full support for real-time processing."
SnapLogic is ranked 14th in Data Integration with 21 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 IBM InfoSphere DataStage, AWS Glue, Azure Data Factory, Informatica Cloud Data Integration and Alteryx Designer, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Informatica Cloud Data 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.