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.
The reports and pipelines run, leading to cost savings that reduce manual effort and save 50,000 to 150,000 USD annually.
It improved our productivity by fifteen percent and shifted work from IT to business users.
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 responsiveness, technical expertise, knowledge base and documentation, support channels, and continuous improvement were impeccable.
They are providing the best customer support to the organization and the vendors.
I have been very impressed with how responsive they are and how well they take feedback and they value my team's experience.
The first line of support needs to be more knowledgeable.
After implementing SnapLogic, pipelines that processed one to two million records per week can now handle five to 10 million records without additional infrastructure.
That means you can connect any system or application anytime, whether day or night, scheduled or dynamic, and anywhere, whether it is cloud or on-premises.
It supports enterprise-wide integration and has a cloud-native architecture.
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.
I would rate the stability of SnapLogic as nearly ten out of ten.
But recently, in a year, I haven't found many performance issues in SnapLogic.
However, sometimes we see that SnapLogic is unstable during patch releases or Snap Pack releases.
It processes large volumes of data quickly.
We require a data pipeline that can be read without latency and without any delay.
Having more granular control and deeper insights into execution performance would really help.
IP whitelisting is the area that SnapLogic definitely has to improve.
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.
In terms of setup cost, it is relatively low compared to traditional on-premises tools.
I feel SnapLogic is very expensive compared to others.
There would be only one point of improvement if the price could be lower.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
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.
However, it could be a bit cheaper.
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 provides inbuilt Snaplets, such as creating and closing an audit ID, removing duplicates, joining tables, writing to Oracle, files, XML, SF, SMTP connections, and more.
SnapLogic excels in data transformations, monitoring, and observability, providing scalability controls for the pipelines.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
SSAS is included in the base installation of SQL Server.
| Product | Mindshare (%) |
|---|---|
| SSIS | 3.6% |
| SnapLogic | 1.2% |
| Other | 95.2% |
| Company Size | Count |
|---|---|
| Small Business | 12 |
| Midsize Enterprise | 7 |
| Large Enterprise | 18 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
SnapLogic offers a flexible, low-code environment for data integration and automation, utilizing an intuitive drag-and-drop interface with pre-built components to streamline the integration of multiple systems like Salesforce, SAP, and Workday, optimizing workflow automation.
SnapLogic provides robust ETL capabilities and broad connectivity options, enabling custom script implementation. Its visual design supports seamless deployment and efficient error management. Users benefit from automating data flows and enhancing data consistency through API integrations while managing both synchronous and asynchronous processes. However, areas needing improvement include user-friendly integrations, API management, and dashboard functionalities, as well as better transparency and error debugging. There is a call for improved handling of large datasets, enhanced connectivity, and advanced monitoring, DevOps integration, and AI functionalities. Customer support and documentation could be more comprehensive, especially for intricate operations.
What are SnapLogic's key features?In industries like finance, healthcare, and logistics, SnapLogic is extensively implemented for ETL processes, data migration, and automating complex workflows to improve data accuracy and enhance operational efficiency. These capabilities allow organizations to streamline operations and focus on strategic initiatives.
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.
