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.
Find out what your peers are saying about Snowflake Computing, Teradata, Google and others in Cloud Data Warehouse.
We earned back our investment in Amazon Redshift within the first year.
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.
Suppose there was an issue resolution time of 10 hours for the previous manual effort; now it is reduced to one hour or half an hour.
Whenever we need support, if there is an issue accessing stored data due to regional data center problems, the Amazon team is very helpful and provides optimal solutions quickly.
Documentation that allows anyone with prior knowledge of Redshift or SQL to resolve technical issues.
It's costly when you enable support.
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 scalability part needs improvement as the sizing requires trial and error.
We have successfully increased our storage space, which was a smooth process without server crashes before or after scaling.
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.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
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.
They should bring the entire ETL data management process into Amazon Redshift.
Integration with AI could be a good improvement.
Integration with AI features could elevate its capabilities and popularity.
We require a data pipeline that can be read without latency and without any delay.
IP whitelisting is the area that SnapLogic definitely has to improve.
If the AI capabilities and integrations were more intuitive and easy to learn for new users, it would be greatly beneficial.
The cost of technical support is high.
It's a pretty good price and reasonable for the product quality.
The pricing of Amazon Redshift is expensive.
I feel SnapLogic is very expensive compared to others.
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.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
Scalability is also a strong point; I can scale it however I want without any limitations.
The specific features of Amazon Redshift that are beneficial for handling large data sets include fast retrieval due to cloud services and scalability, which allows us to retrieve data quickly.
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.
| Product | Mindshare (%) |
|---|---|
| Amazon Redshift | 7.1% |
| Snowflake | 15.3% |
| Databricks | 9.5% |
| Other | 68.1% |
| Product | Mindshare (%) |
|---|---|
| SnapLogic | 4.0% |
| Boomi iPaaS | 7.0% |
| MuleSoft Anypoint Platform | 6.7% |
| Other | 82.3% |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 21 |
| Large Enterprise | 29 |
| Company Size | Count |
|---|---|
| Small Business | 12 |
| Midsize Enterprise | 7 |
| Large Enterprise | 18 |
Amazon Redshift is a dynamic data warehousing and analytics platform offering scalability and seamless AWS integration for high-performance query processing and diverse data management.
Amazon Redshift provides robust data integration capabilities with AWS services like S3 and QuickSight, enabling efficient data warehousing and analytics. It is known for fast query performance due to its columnar storage and can handle diverse file formats. With a user-friendly SQL interface, Redshift supports data compression and offers a strong cost-performance ratio. Its secure VPC configurations and compatibility with data science tools enhance its functionality, although there is room for improving snapshot restoration, dynamic scaling, and processing large datasets.
What are the key features of Amazon Redshift?In industries, Amazon Redshift is essential for managing extensive datasets for business intelligence, operational insights, and reporting. It supports data integration from ERPs and S3, handles SQL queries for comprehensive analysis, and facilitates data storage and transformation. Companies use it for predictive modeling and connect with BI tools like Tableau and Power BI to derive actionable insights.
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.
We monitor all Cloud Data Warehouse 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.
