Best practices and lessons learned for modern cloud ETL to data warehouse.
Database vs Data Warehouse
4 min read • 17 May 2018
Learn the differences between databases and data warehouses and how each serves a different function within an organization.
2018 ETL Tools Comparison
9 min read • 1 May 2018
Trying to decide on the best ETL solution for your organization? Learn about the most popular incumbent batch and modern cloud-based ETL solutions and how they compare.
Open Source ETL Tools Comparison
7 min read • 26 Apr 2018
Open source data integration tools are a low cost alternative to commercial packaged solutions. Just like commercial solutions, they have their benefits and drawbacks. Learn about the advantages and disadvantages of the most widely known open source ETL tools.
ETL Unleashes Competitive Advantage for the Gaming Industry
6 min read • 24 Apr 2018
Dominating in the data-driven world of online gaming means surmounting numerous challenges, many of which can be effectively addressed with the help of a robust extract, transform, load (ETL) platform. Learn how Alooma can help game developers and publishers transform data into actionable insights.
MySQL to Google BigQuery Replication
15 min read • 15 Mar 2018
A major reason to replicate your MySQL data into Google BigQuery, is the ability to join multiple data sources for valuable analysis. However, there are three approaches each with their advantages and disadvantages. Here, we’ll focus on our preferred method - Binlog Replication and show you the steps to do it.
Daniel Ben Yosef
The Types of Modern Databases
10 min read • 7 Mar 2018
Choosing the best database management system for your organization can be a complex process. In this article, you'll learn about the two types of databases: NoSQL (non-relational) and Relational Database Management Systems (RDBMS) and key differentiators between them.
A Guide to Selecting the Right Cloud Data Warehouse
10 min read • 14 Feb 2018
Choosing a modern cloud data warehouse can be tricky since they are all so similar. In this article, we will provide a guide of the factors you should use to evaluate such as use case, speed, cost, scalability, security and reliability. We’ll look at the most popular options: AWS Redshift, Google BigQuery, Snowflake and MemSQL.
Migrate Oracle Data to the Cloud With Alooma
10 min read • 9 May 2018
Learn how Alooma can easily help migrate your Oracle database to any cloud data warehouse so you can avoid the pitfalls of doing it yourself.
Migrating Oracle Data to the Cloud With the Oracle LogMiner
7 min read • 9 May 2018
Migrating Oracle data to the cloud is a complex and lengthy process. In this post, we look at the process and dive into the method of using Oracle LogMiner, which provides a view into the database change log. This is what Alooma uses to continuously replicate all changes to your Oracle data.
Encrypt Private Health and Financial Data in Real-Time
8 min read • 14 Dec 2017
It’s critical for health and financial organizations to protect patient and client data. But with so much data coming in, how do you safeguard it at scale? We’ll show you how you can use the Alooma Code Engine to encrypt all your data in real-time in just two steps.
Daniel Ben Yosef & Jason Lim
Using Snowflake Snowpipe to Optimize Data Throughput
5 min read • 29 Mar 2018
Snowflake with Snowpipe: How Alooma uses Snowpipe to help you save money while transforming your business. Enable near real time data loading to ensure fresh data, but keep the lower cost of scheduled loading.
Eitan Rosenfeld & Garrett Alley
ETL Testing: The Future is Here
15 min read • 20 Mar 2018
The ETL testing process used to be arduous - learn how a modern ETL platform built for the cloud era can help test ETL at scale in only a few easy steps.
The Best Decisions Come From Real-Time Data
7 min read • 13 Nov 2017
The next evolution of data-driven decisions is real-time data driven decisions. This is how winning businesses of today and the future will compete. For real-time data analysis and decisions to work at scale, they need to be cloud-based, use real-time stream processing and utilize business intelligence tools.
Periscope Data Warehouse Now Supported
5 min read • 7 Nov 2017
Alooma supports the new Periscope Data Warehouse as an output.
Three Ways to Ingest Data Without a Native Connector
5 min read • 30 Oct 2017
Three ways to ingest data through Alooma into a cloud data warehouse without a native integration
Best Practices for Migrating from On-Prem to Cloud
14 min read • 7 Sep 2017
The advantages of migrating to the cloud are very clear and the industry is showing it. According to the IDC Worldwide Quarterly Cloud IT Infrastructure Tracker, deployment in cloud environments will increase by 18.2% in 2017 to $44.2 billion.
How Redash is Helping Alooma Sustain a Data Driven Culture
8 min read • 19 Jul 2017
Alooma and Redash share the same mission: to liberate data and unleash its full potential.
Alooma’s Roundup of Snowflake’s Cloud Analytics City Tour
5 min read • 11 Jul 2017
Alooma data pipeline service company recaps the 2017 Snowflake Cloud Analytics City Tour
Harness the power of Salesforce data with ETL
12 min read • 27 Apr 2018
Extract, transform and load (ETL) your Salesforce data to BigQuery, Redshift or Snowflake to get the most out of your data.
The easiest way to load a CSV into Google BigQuery
10 min read • 25 Jun 2017
BigQuery, Google’s data warehouse as a service, is growing in popularity as an alternative to Amazon Redshift. If you’re considering working with BigQuery, you’ll find that accessing the data is quite straightforward.
Solving the challenges of mapping your data
8 min read • 21 Jun 2017
When mapping is done correctly, the pipeline process works smoothly with fewer loading errors. That’s why we at Alooma allow you to automate the mapping process, so you won’t have to deal with the dirty work of deciding which column should be mapped to which data type.
Redshift Vacuum and Analyze Tool: Doing your Maintenance Work for you
9 min read • 12 Jun 2017
Explaining why VACUUM and ANALYZE are required. We’re providing you with a free tool to manage your maintenance tasks.
Redshift: How to alter column in 3 clicks
9 min read • 3 Jun 2017
There’s no simple, native way to alter a column’s name or data type in Redshift, BigQuery, or Snowflake. So, we built one which enables you to alter a column in 3 clicks within the Alooma Platform. Read on to learn about how we, as a product team, got there.
Infographic: Why Streaming Data Pipelines Matter
5 min read • 24 Apr 2017
Streaming data pipelines today are enabling organizations to transform and become data-driven.
Recruiting a Top Notch ETL Developer
5 min read • 29 Mar 2017
In order to build a great data team, you need great data engineers. Here's how to hire them.
Six pitfalls when connecting Elasticsearch to Redshift
5 min read • 14 Mar 2017
Redshift and Elasticsearch have a very different structure, as they are two very different solutions for data storage. While Elasticsearch is a full-text search engine based around schema-free JSON documents, Redshift is an SQL-based, columnar, schema’d data warehouse based on PostgreSQL.
Real-Time Anomaly Detection on the Stream
4 min read • 1 Feb 2017
How to monitor and detect anomalies in KPIs in real time using Alooma’s Code Engine.
Enriching Streaming Data With External Sources
4 min read • 25 Jan 2017
How to use Alooma’s Code Engine to enrich streaming events with data from external sources
Sessionization Using Python and Alooma’s Code Engine
9 min read • 19 Jan 2017
An introduction to stateful processing, and how we at Alooma, are using stateful processing internally to get the most out of our events data.
ETL Tools: A Modern List
4 min read • 17 May 2018
Extract, Transform and Load (ETL) tools enable organizations to make their data accessible, meaningful, and usable across disparate data systems. When it comes to choosing the right ETL tool, there are many options to choose from.
Harnessing real-time data to improve customer experience
7 min read • 20 Dec 2016
An example of how we at Alooma use real-time data collected from multiple sources to gain insight into our customer's actions, and to improve customer hapiness.
Amazon Athena - Initial Analysis
3 min read • 30 Nov 2016
Everything you need to know about Amazon's latest announcement: Amazon Athena - an interactive query service for Amazon S3.
Alooma Live - Kafka Real-Time Visualization
12 Sep 2016
Introducing Alooma Live - our new tool for real-time, big-data stream visualization
Itamar Weiss & Stav Mizrahi
Forbes names Alooma the rising star of data infrastructure
2 min read • 7 Sep 2016
Alooma is proud to be named the rising star of data infrastructure in the Forbes 2016 World’s Best Cloud Companies list.
4 Valuable Resources on Stream processing
3 min read • 4 Jul 2016
Beginner guide to stream processing. Statefull, Stateless and in between.
Use webhooks to integrate data sources with Alooma
6 min read • 6 Jun 2016
Use webhooks to integrate any SaaS product to your data warehouse
Making big data analysis accessible throughout your company
5 min read • 23 May 2016
How to make everyone at your company data driven, regardless of their SQL knowledge.
Welcoming BigQuery, MySQL and MemSQL
1 min read • 19 May 2016
Today we announce new data warehouse integrations to BigQuery, MySQL and MemSQL
5 Valuable Resource on Custom Analytics
2 min read • 6 Apr 2016
A mini-list of 5 brilliant blog posts on Custom Analytics
MySQL to Amazon Redshift replication
20 min read • 19 Jan 2016
How to replicate your MySQL to Amazon Redshift: A comparison of 3 common approaches with detailed real-world examples.
Amazon Redshift for Custom Analytics - Full Guide
25 min read • 4 Apr 2018
Learn how to build a custom analytics pipeline over Amazon Redshift with real-world examples of engagement, funnels, retention and customer value analyses.
Export Application Insights to Amazon Redshift with Alooma
14 min read • 16 Nov 2015
Learn how to export Application Insights data to Amazon Redshift with Alooma
Building a Professional Grade Data Pipeline
5 min read • 24 Aug 2015
Flexible, reliable data pipelines are hard to build. We do this for a living, and wanted to share our knowledge and experience in understanding the difficulties.
Building Dockers with Maven for Continuous Integration
12 min read • 3 Aug 2015
How we at Alooma are building dockers using docker-maven-plugin and Jenkins.
Exactly-Once Processing with Trident - The Fake Truth
10 min read • 10 Jun 2015
Dissecting the Trident Guarantee of Exactly-Once Semantics
TLV Data Plumbers First Meetup
5 min read • 31 May 2015
Data Plumbing Blues - The first data plumbers meetup with 3 Real-Life Examples