What can you do with data collected on Heroku PostgreSQL? How will you analyze it and integrate it? With Xplenty, of course! Xplenty lets you connect to a PostgreSQL database...

You’ve spent hours tinkering and preparing the perfect dataflow to batch process zillions of web logs. Feeling satisfied, you run the job on one of the clusters and leave your...

In our previous post, we discussed Mad Men and how to design a data warehouse in the space age of Big Data. This post will take another step forward, or...

In “The Monolith”, the fourth episode in Mad Men’s final season, a huge computer is installed in the center of the floor. The computer was brought in because a competing...

Xplenty now provides the capability to directly access source data from relational databases. You can use the new Database Source component to read data directly from Postgres, MySQL and Amazon...

A regular expression, AKA regex, is a powerful yet really confusing tool. Although regular expressions are the technology behind text replacement and natural language processing, they are hard to read,...

Unstructured data is big - according to IDC, about 90 percent of the storage in the world is used for unstructured data. It comes as no surprise considering the amount...

Xplenty loves MongoDB. We’ve already guided you how to integrate with MongoLab, and now we’ll show you how to do data integration on the cloud with Xplenty and MongoHQ.

Did you know that choosing the right join type for your data could improve your data integration performance? Given certain data sets, Pig provides several join algorithms that process them...