Redshift is awesome!
June 17, 2019

Redshift is awesome!

Vibhakar Prasad | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Amazon Redshift

1)ETL(Talend) data from source applications (Salesforce, Jira, OpenAir, NetSuite, Sharepoint, Active Directory, Office 365, etc.) to S3 bucket and from S3 bucket push data to Redshift (sync time is 10 minutes intervals. Data is available almost real-time only lagging 10 minutes).
2) All Department use it—Engineering, Sales, and Marketing.
3) As I said data is almost in real-time, so it is very useful for taking real-time decisions for upper management. We also reduced Salesforce licenses, because most of the users only used it to see reports. Now they are happy to used Redshift.
  • We reduced the number of Salesforce licenses— Engineering, Sales and Marketing guys are happy to query data from Redshift.
  • Very fast to provide a huge data set with complicated measure.
  • Some of the calculations failed in Salesforce. Redshift returns with the same calculations very fast.
  • Very easy to maintain, no need to worry about hardware failure.
  • We are not able to modify column size.
  • I have not found any negative impact.
It is simple and easy to maintain and we saved a lot of dollars in a year.
I recommend all to use Redshift, It is easy to use and maintain. We have reduced the number of Salesforce licenses due to real-time data we have in Redshift. People are happy to use Redshift.