Jul 16, 2017
S3 copy is the best solution to load data into Redshift. I have used Informatica to move data from On premise to S3 and used S3 Copy to load Redshift.
SSIS and SnapLogic are competing in the data integration space. SnapLogic possesses a broader feature set and cloud-native capabilities, making it the more forward-looking choice despite its higher price tag.
Features: SSIS provides robust scheduling, ETL processes, and data transformations, ideal for integrating with Microsoft environments. SnapLogic simplifies cloud services integration, enables real-time data flow, and provides an extensive library of pre-built connectors.
Room for Improvement: SSIS could improve its cloud capabilities and reduce infrastructure requirements. Additionally, enhancing support for non-Microsoft environments would broaden its appeal. SnapLogic's pricing is a concern for cost-conscious businesses. Users may seek improved features for on-premise systems, and better offline support is desirable.
Ease of Deployment and Customer Service: SSIS requires more infrastructure setup and suits Windows-centric organizations but has comprehensive Microsoft integration. SnapLogic's cloud-native design ensures faster deployment cycles and ongoing updates, appealing to those seeking speed and flexibility.
Pricing and ROI: SSIS is cost-effective, with lower initial setup costs for businesses invested in Microsoft tools, offering a strong ROI. SnapLogic, although pricier, can deliver a higher ROI via its scalable cloud-based platform and quicker implementation, attractive for companies prioritizing innovation.
SnapLogic is really helpful and processes in very little time, so it doesn't take much time compared to any legacy tool.
SnapLogic has helped automate manual data transfers significantly and improved our workflow efficiency, reducing integration development timelines considerably, which reflects a good ROI.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
The technical support from SnapLogic is excellent, and I would give it a complete ten.
Some SMEs are allotted for the organization, so in case of any issue, we have their email IDs to contact them for support, including SMEs and community.
Customer support scales well; as pipeline volume grows, we have been able to add more integrations and users without performance degradation.
The first line of support needs to be more knowledgeable.
I rate the scalability of SnapLogic as eight out of ten.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
But recently, in a year, I haven't found many performance issues in SnapLogic.
I would rate the stability of SnapLogic as nearly ten out of ten.
It processes large volumes of data quickly.
If the AI capabilities and integrations were more intuitive and easy to learn for new users, it would be greatly beneficial.
They can improve more visuals, with graphical representations, such as how many things can be added, how many users can be added or dropped, and how the back-end nodes can be graphically shown in a better way.
Some advanced features lack detailed documentation, and debugging complex pipelines could be more intuitive.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
The logging capabilities could be improved, particularly for error logging.
I would say the pricing is on the higher side, but it aligns with the capabilities offered for mid- to large integrations.
There would be only one point of improvement if the price could be lower.
SnapLogic is positioned at around seven or eight out of ten in terms of pricing.
However, it could be a bit cheaper.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
I also like the whole child-parent pipeline feature; it allows me to break up a process into smaller pieces and then have one big pipeline that controls these smaller pipelines.
SnapLogic has helped automate manual data transfers, improved workflow efficiency, and significantly reduced the integration development timelines, which is a measurable outcome.
I find SnapLogic to be user-friendly, especially for beginners with limited experience in data engineering or ETL.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
The main benefits SSIS provides for my company is to streamline processes.
The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.
| Product | Market Share (%) |
|---|---|
| SSIS | 4.0% |
| SnapLogic | 1.1% |
| Other | 94.9% |
| Company Size | Count |
|---|---|
| Small Business | 11 |
| Midsize Enterprise | 5 |
| Large Enterprise | 11 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
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.
