Amazon Redshift Leaves On-Premises Opening, Says ParAccel - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Comments
Amazon Redshift Leaves On-Premises Opening, Says ParAccel
Newest First  |  Oldest First  |  Threaded View
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
12/6/2012 | 11:27:30 PM
re: Amazon Redshift Leaves On-Premises Opening, Says ParAccel
Amazon finally responded to my questions today, but no interviews are possible until the release. Here's what the AWS had to say about loading Redshift & where to handle the BI:

What are the options for getting data up into Redshift, and what latency is introduced?

For data that is already in AWS, we offer direct, parallel loading from Amazon S3, Amazon DynamoDB. We also enable easy integration with other data sources within AWS by way of the AWS Data Pipeline.

For data that is on premise, Amazon S3 is a great option to get data to Amazon Redshift. Choices here include pushing multiple files in parallel to Amazon S3 across a network, doing so over an AWS Direct Connect link to ensure dedicated bandwidth, using AWS Storage Gateway, or using import/export where you ship drives to AWS, removing bandwidth considerations. S3 has a high network cross-section to absorb input traffic, so latency really turns into a question of how many threads can be used to push data. Generally, this can be set up to saturate on network bandwidth out of the source node and, as such, should not require meaningful additional time relative to moving data within an internal network.

AWS also has numerous partners who can help customers with their on-premise to AWS data movement strategy and Amazon Redshift will be developing integrations with leading ETL vendors to make this process even simpler for customers than it is today.

What are the options for where and how to do analysis (BI) against Redshift?

Customers can use standard PostgreSQL drivers over ODBC/JDBC connections to connect their existing SQL-based BI tools to Amazon Redshift. MicroStrategy and Jaspersoft have already certified Amazon Redshift.

Customers may choose to run their BI software in cloud or on premise based on their preferences. Performance is very dependent on the specifics of queries, rendering, data set, result set cache sharing, network traffic and concurrency, and likely to vary from one customer to another. While network traffic between the BI node and Amazon Redshift may sometimes be a factor arguing for collocation in the cloud, there is little data to suggest that this will dominate other considerations. For example, in our booth at re: Invent, MicroStrategy demonstrated integration from Amazon Redshift in the AWS cloud to MicroStrategy in their own private cloud to a tablet in our booth with very fast response times throughout.

D. Henschen
50%
50%
D. Henschen,
User Rank: Author
12/6/2012 | 3:26:53 PM
re: Amazon Redshift Leaves On-Premises Opening, Says ParAccel
Much as Amazon doesn't talk up Android as the foundation of Kindle Fire, it barely mentions ParAccel, let alone pointing out situations where on-premises deployments might make sense. For those who prefer on-premises, Redshift offers a way to to ParAccel-based POCs and pilot projects.
Doug Henschen
InformationWeek


State of the Cloud
State of the Cloud
Cloud has drastically changed how IT organizations consume and deploy services in the digital age. This research report will delve into public, private and hybrid cloud adoption trends, with a special focus on infrastructure as a service and its role in the enterprise. Find out the challenges organizations are experiencing, and the technologies and strategies they are using to manage and mitigate those challenges today.
Commentary
Why It's Nice to Know What Can Go Wrong with AI
James M. Connolly, Editorial Director, InformationWeek and Network Computing,  11/11/2019
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
White Papers
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Sponsored Video
Flash Poll