Loading Data into Amazon Redshift from Amazon S3

By |2018-04-10T16:52:42-06:00December 10th, 2013|Insight Post|

Amazon offers loading data to Redshift either from flat files that are stored in an Amazon S3 bucket or from Amazon DynamoDB table. In this article, I will show you how to load data from your local machine to Amazon Redshift using the Amazon S3 service. Also, for inserting data to Amazon Redshift, I will show you how to use COPY command.

Big Data and Cloud Data Warehousing Knowledge: Do You Have the Technical Skills You Need?

By |2018-05-01T14:12:15-06:00September 6th, 2013|Insight Post|

BI Professionals are used to working with a wide range of products and platforms and typically have a pretty substantial tool belt to be able to work across a multitude of different technologies. Over the past couple of months I took the opportunity to experiment with technologies that are entering the data warehousing ecosystem. These technologies included the Cloudera Sandbox, Hortonworks Sandbox, IBM Big Insights Sandbox, and Amazon’s Red Shift.

iOLAP Becomes Consulting Partner for AWS Redshift Data Warehouse Platform

By |2018-04-10T17:31:58-06:00August 8th, 2013|Press Release|

iOLAP Inc., has signed a Consulting Partner agreement with web infrastructure provider Amazon Web Services, Inc. (AWS), for their new Redshift platform, a petabyte-scale data warehouse service in the cloud.

Is Amazon’s Redshift a Game Changer?

By |2018-04-10T17:29:31-06:00July 5th, 2013|Insight Post|

Now and then new technologies, ideas, and even buzzwords come along that fundamentally change the way people look at the IT game. When Amazon first released Amazon Web Services (AWS) it changed the game of cloud-based data centers by introducing pay-as-you-go pricing for servers and storage. By replacing large up-front capital infrastructure expenditures with much lower costs that people could scale as their businesses grew, Amazon grew their own business by fostering many more entrants into the e-commerce space that in many cases also turned to Amazon logistics and fulfillment services. That was a game changing moment that was definitely a win-win for all parties.