big data integration Scalability of Amazon Redshift Data Loading and Query Speeds A lot of people are concerned about the time it took to load all of our data onto Redshift, specifically about the "17 hours for 1.2TB". Donal Tobin Read More
big data integration Is Amazon Redshift a Game-Changer for Big Data Analysis? This article is for explaining what exactly is Amazon Redshift and what is not. Hope it helps those who are curious about Amazon Redshift. Mark Smallcombe Read More
Cloud Integration With Amazon Redshift SSD, querying a TB of data took less than 10 seconds The AWS team announced the release of an SSD version of Amazon Redshift on January 24, 2014. Abe Dearmer Read More
Cloud Integration How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 1) We recently discovered an issue running queries from EC2-Classic instances onto a Redshift cluster in EC2-VPC. We ran through a number of troubleshooting steps including: Mark Smallcombe Read More
Cloud Integration How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 2) We set out to edit all our Chef recipes to deploy our new DHCP client configuration files so we can quickly deploy them to all our instances. Mark Smallcombe Read More
Cloud Integration How to improve performance of "UPSERT"s when running "COPY commands UPSERT is the operation to merge new records with existing records using primary keys on a table. While some RDBMSs support a single UPSERT statement. Abe Dearmer Read More
Cloud Integration Treetop's Confusing Behavior This article will walk you through some of those gotchas hoping that you can save precious time and energy Mark Smallcombe Read More
ETL 46 min Top 25 ETL Tools (Updated Nov 2025) Integrate.io lists the 14 best ETL software tools for 2025 based on features, user review scores, and more. Which ETL tool should you choose? Abe Dearmer Read More
ETL 15 min SFTP to Salesforce – Guide to a Secure Integration Integrating data from your systems into Salesforce is a critical process. Here is a guide featuring the SFTP to Salesforce process. Donal Tobin Read More
Data Integration 10 min What Is Operational ETL? Delving into Operational ETL: Learn how it transforms business data handling for enhanced productivity. Donal Tobin Read More
