The challenge here is to blend S3 formatted data from the Amazon Cloud with Blob Storage formatted data from the MS Azure Cloud. As a secondary challenge we want to blend the cloud data with Excel data. Will they blend? Data is the new CENSUS data downloadable from: xxx. We report the average travel time to work vs. the English proficiency and we discover that, if you are a woman, the less you speak English the closer to home your work place is. If we then analyze the size of the statstical sample, we also discover that the average is based on only 31 not English speaker females.
In this example, proprietary files can either be loaded directly into Amazon S3 or alternatively first converted to an open format then uploaded to Amazon S3. The proprietary software is not required.
This workflow demonstrates how to use the S3 Connection. It demonstrates bucket creation, folder creation, file upload, file download, file listing and file deletion. It also demonstrates how to use the S3 File Picker, that allows to read files directly without downloading them first.
This workflow accesses a zipped file from a local URL (knime://knime.workflow/data\2008.csv.bz2) and a zipped file from a remote URL (http://stat-computing.org/dataexpo/2009/2007.csv.bz2) via HTTP connection on the web. The two data sets contain data about US flights for 2007 (remote) and 2008 (local). Both files are zipped and need unzipping. ... and yes! They blend.
This workflow demonstrates how to use the Azure Blob Store Connection. It demonstrates container creation, folder creation, file upload, file download, file listing and file deletion. It also demonstrates how to use the Azure Blob Store File Picker that allows to read files directly without downloading them first.