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.
Welcome to Xplenty's Blog
All things data
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.
Screencast on how to connect Amazon S3 with 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.
We’ve uploaded a brand new screencast which shows how to process web server logs with Xplenty.
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.
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.
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!
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.
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.