Alooma blog

Best practices and lessons learned for modern cloud ETL to data warehouse.

Data Pipeline

Build vs. Buy — Solving Your Data Pipeline Problem

Learn about the challenges associated with building a data pipeline in-house and how an automated solution can deliver the flexibility, scale, and cost effectiveness that businesses demand when it comes to modernizing their data intelligence operations.

Read blog postRead case study

Data Pipeline

What is a Data Pipeline?

A data pipeline allows you to consolidate data from multiple sources and makes it available for analysis and visualization.

Read blog postRead case study

Data Integration

Data Integration Tools

Learn about the various types of data integration tools, including on-premise, open source, and cloud-based.

Read blog postRead case study

Data Warehouse

What is Data Warehousing?

A data warehouse is a large-capacity repository that sits on top of multiple databases and is designed to handle a variety of data sources, such as sales data, data from marketing automation, real-time transactions, SaaS applications, SDKs, APIs, and more.

Read blog postRead case study

ETL

What is ETL?

Extract, transform, load (ETL) platforms — software that extracts information from databases, re-formats/transforms it, and loads it into a data warehouse — have been a critical component of enterprise infrastructure for decades.

Read blog postRead case study

Data Warehouse

Database vs Data Warehouse

Learn the differences between databases and data warehouses and how each serves a different function within an organization.

Read blog postRead case study

ETL

2018 ETL Tools Comparison

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.

Read blog postRead case study

ETL

Open Source ETL Tools Comparison

Open source ETL 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.

Read blog postRead case study

ETL

ETL Unleashes Competitive Advantage for the Gaming Industry

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.

Read blog postRead case study

Data Integration

MySQL to Google BigQuery Replication

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.

Read blog postRead case study

Data Warehouse

The Types of Modern Databases

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.

Read blog postRead case study

Data Warehouse

How to Choose a Cloud Data Warehouse Solution

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.

Read blog postRead case study

Data Warehouse

Migrate Oracle Data to the Cloud With Alooma

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.

Read blog postRead case study

Data Warehouse

Migrating Oracle Data to the Cloud With the Oracle LogMiner

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.

Read blog postRead case study

Product

Encrypt Private Health and Financial Data in Real-Time

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.

Read blog postRead case study

Product

Using Snowflake Snowpipe to Optimize Data Throughput

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.

Read blog postRead case study

ETL

ETL Testing: The Future is Here

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.

Read blog postRead case study

Data Analysis

The Best Decisions Come From Real-Time Data

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.

Read blog postRead case study

Product

Periscope Data Warehouse Now Supported

Alooma supports the new Periscope Data Warehouse as an output.

Read blog postRead case study

Product

Three Ways to Ingest Data Without a Native Connector

Three ways to ingest data through Alooma into a cloud data warehouse without a native integration

Read blog postRead case study

Data Warehouse

Best Practices for Migrating from On-Prem to Cloud

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.

Read blog postRead case study

Data Analysis

How Redash is Helping Alooma Sustain a Data Driven Culture

Alooma and Redash share the same mission: to liberate data and unleash its full potential.

Read blog postRead case study

Product

Alooma’s Roundup of Snowflake’s Cloud Analytics City Tour

Alooma data pipeline service company recaps the 2017 Snowflake Cloud Analytics City Tour

Read blog postRead case study

ETL

Harness the power of Salesforce data with ETL

Extract, transform and load (ETL) your Salesforce data to BigQuery, Redshift or Snowflake to get the most out of your data.

Read blog postRead case study

Data Integration

The easiest way to load a CSV into Google BigQuery

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.

Read blog postRead case study

Product

Solving the challenges of mapping your data

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.

Read blog postRead case study

Product

Redshift Vacuum and Analyze Tool: Doing your Maintenance Work for you

Explaining why VACUUM and ANALYZE are required. We’re providing you with a free tool to manage your maintenance tasks.

Read blog postRead case study

Product

Redshift: How to alter column in 3 clicks

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.

Read blog postRead case study

Data Pipeline

Infographic: Why Streaming Data Pipelines Matter

Streaming data pipelines today are enabling organizations to transform and become data-driven.

Read blog postRead case study

ETL

Recruiting a Top Notch ETL Developer

In order to build a great data team, you need great data engineers. Here's how to hire them.

Read blog postRead case study

Data Integration

Six pitfalls when connecting Elasticsearch to Redshift

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.

Read blog postRead case study

Product

Real-Time Anomaly Detection on the Stream

How to monitor and detect anomalies in KPIs in real time using Alooma’s Code Engine.

Read blog postRead case study

Product

Enriching Streaming Data With External Sources

How to use Alooma’s Code Engine to enrich streaming events with data from external sources

Read blog postRead case study

ETL

ETL Tools: A Modern List

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.

Read blog postRead case study

Data Analysis

Harnessing real-time data to improve customer experience

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.

Read blog postRead case study

Data Analysis

Amazon Athena - Initial Analysis

Everything you need to know about Amazon's latest announcement: Amazon Athena - an interactive query service for Amazon S3.

Read blog postRead case study

Product

Alooma Live - Kafka Real-Time Visualization

Introducing Alooma Live - our new tool for real-time, big-data stream visualization

Read blog postRead case study

Product

Forbes names Alooma the rising star of data infrastructure

Alooma is proud to be named the rising star of data infrastructure in the Forbes 2016 World’s Best Cloud Companies list.

Read blog postRead case study

Technology

4 Valuable Resources on Stream processing

Beginner guide to stream processing. Statefull, Stateless and in between.

Read blog postRead case study

Data Integration

Use webhooks to integrate data sources with Alooma

Use webhooks to integrate any SaaS product to your data warehouse

Read blog postRead case study

Data Analysis

Making big data analysis accessible throughout your company

How to make everyone at your company data driven, regardless of their SQL knowledge.

Read blog postRead case study

Product

Welcoming BigQuery, MySQL and MemSQL

Today we announce new data warehouse integrations to BigQuery, MySQL and MemSQL

Read blog postRead case study

Data Analysis

5 Valuable Resource on Custom Analytics

A mini-list of 5 brilliant blog posts on Custom Analytics

Read blog postRead case study

Data Integration

MySQL to Amazon Redshift replication

How to replicate your MySQL to Amazon Redshift: A comparison of 3 common approaches with detailed real-world examples.

Read blog postRead case study

Data Analysis

Amazon Redshift for Custom Analytics - Full Guide

Learn how to build a custom analytics pipeline over Amazon Redshift with real-world examples of engagement, funnels, retention and customer value analyses.

Read blog postRead case study

Data Integration

Export Application Insights to Amazon Redshift with Alooma

Learn how to export Application Insights data to Amazon Redshift with Alooma

Read blog postRead case study

Data Pipeline

Building a Professional Grade Data Pipeline

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.

Read blog postRead case study

Technology

Building Dockers with Maven for Continuous Integration

How we at Alooma are building dockers using docker-maven-plugin and Jenkins.

Read blog postRead case study

Technology

Exactly-Once Processing with Trident - The Fake Truth

Dissecting the Trident Guarantee of Exactly-Once Semantics

Read blog postRead case study

Product

TLV Data Plumbers First Meetup

Data Plumbing Blues - The first data plumbers meetup with 3 Real-Life Examples

Read blog postRead case study

Technology

Apache storm dependency injection

Using dependency injection within the apache storm framework.

Read blog postRead case study