Blogspot - open-bi.blogspot.com - Open BI
General Information:
Latest News:
Connecting to Mysql within Amazon VPC 26 Jul 2013 | 06:34 pm
Hi all, It’s been a long time since my last post. Though days indeed : lot of work and annoying health issues (cause and consequence, in that order). I’m back, with a lot of things to share about da...
Amazon SDB bulk extractor 29 Nov 2012 | 07:06 pm
Hi all, I said it, I did it. After coding a SDB bulk loader a few days ago, based on the batch insert feature from the AWS SDK, I coded a bulk extractor. You said bulk, or Hulk ? What’s the theory ...
Amazon SDB bulk loader 28 Nov 2012 | 01:52 am
Hi all, I’ve spent a long time working with AWS and especially SDB. Loading mass data into SDB is not very frequent, but when needed it often comes to an end : there is no utility to do that and it’s...
Call RESTful web services from MySQL 17 Nov 2012 | 04:03 am
Hi, I’m back after a long time without any post. Sorry for that, I was busy but I promise I will take time to write new posts and share precious things with you. Recently, I went through a feature req...
Postgresql – quickly check your data demographics 11 Feb 2012 | 01:01 am
Hi all, A few days ago, when starting go work on a new postgresql datawarehouse, I was scared by poor performance and poor exec plans while data volume was not so big… Here is a quick way to check h...
Query Twitter with Talend to see what people think about … 27 Jul 2011 | 02:09 am
Hi all, Almost on holidays after a very hard working year. I have some beach time. This morning, I tried to query Twitter and to process the data. My purpose is to quickly build a data set showing w...
Interfacing Talend with Amazon SDB (AWS SDB) – quick way 20 Jul 2011 | 03:59 am
Hi all, I had the following challenge : read some ftp account informations (ftp server, username, password, target directory) stored in Amazon SDB and use it in a Talend transformation, published as ...
… about AWS cloud, Talend, Jaspersoft, Postgresql and typical EC2 internal addressing issues … 22 Jun 2011 | 04:00 am
Hi all, I’m terribly late with this article, initially scheduled for January 2011 … sorry. Maybe it is a bit outdated now, anyway, I publish it … Let’s talk about EC2 cloud computing, Talend, Postgre...
Wordle, wordmap, word clouds … what’s in a name ? 29 Mar 2011 | 09:51 am
Hi all, Wordmaps, wordles, word clouds … are pretty famous these days. But they are still “difficult” to generate : no api, often proprietary code, often only web based tools, difficulty to render go...
New Data cleansing / mining using Google Refine in the cloud with AWS 24 Mar 2011 | 10:56 pm
Hi all, As promised, an article about a really nice piece of software that will allow you to run data cleansing and data mining jobs with fun. Let’s implement Google Refine in Amazon Web Services (a...
