Welcome to Xplenty's Blog

All things data

How To Offload Data Processing from Google BigQuery

How To Offload Data Processing from Google BigQuery

Google BigQuery is a great Big Data warehouse on the cloud for the SQL-savvy. But it’s not right for everything. Google itself recommends using Hadoop’s MapReduce rather than BigQuery for certain cases.

Become a Twitter Data Analyst with Xplenty

Become a Twitter Data Analyst with Xplenty

Let’s say that you’re doing some marketing for a Big Data startup. As part of your campaign, you want to find the most influential tweeters who talk about Hadoop and determine where they come from. So you collect tweets, with DataSift for example. But now you have a ton of JSON objects filled with data from Twitter and no clue what to do with them.

How to connect Xplenty to Amazon S3

How to connect Xplenty to Amazon S3

Screencast on how to connect Amazon S3 with Xplenty.

Offload Redshift ETL to Xplenty

Offload Redshift ETL to Xplenty

Xplenty can read data from SQL Server, MongoDB, SAP HANA, and many more data stores. One of the many DBs Xplenty integrates with is Redshift.

How to Count Page Views and Visitors in Web Server Logs

How to Count Page Views and Visitors in Web Server Logs

We’ve uploaded a brand new screencast which shows how to process web server logs with Xplenty.

Processing JSON Data on the Cloud

Processing JSON Data on the Cloud

We’ve processed plenty of JSON data in our blog - from Tweets to GitHub commits - but we’ve never really discussed how to process JSON with Xplenty’s data integration on the cloud. Let's do so right now.

Enter The GitHub Data Challenge without Coding

Enter The GitHub Data Challenge without Coding

What if you have a killer idea for GitHub’s Data Challenge but no money, servers, or coders at your disposal? We have the solution for you. You can sign up to Xplenty for free, process the data via our visual editor, and run it on a cluster, all without any installations or code. Let’s look at an example project to show you how it’s done.

How to Integrate MongoDB with Relational Databases

How to Integrate MongoDB with Relational Databases

Integrating data from MongoDB and a relational database sounds like a major headache. On one hand you have a schemaless NoSQL database containing JSON objects, and on the other, an SQL database with a fully defined schema. How can you easily integrate them? With Xplenty’s data integration on the cloud, of course!

How to get Website Visitor Geolocations from IPs

How to get Website Visitor Geolocations from IPs

Although the Internet made the world flat, geography still matters. Knowing which countries your users live in could provide business opportunities to localize your services and increase profits. The only question, is how in the world to do it.

Data Integration on the Cloud with Heroku PostgreSQL and Xplenty

Data Integration on the Cloud with Heroku PostgreSQL and Xplenty

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 on Heroku, design a dataflow via an intuitive user interface, aggregate the data, and even save it back to PostgreSQL on Heroku or other databases and cloud storage services.