Feed on
Posts
Comments

Archive for the ‘xLite’ Category

Spending time on Excel-SQLite, C, VBA Callbacks & Twitter

Posted in BI, ETL, Palo, SQLite, VBA, Web2.0, excel, xLite, tagged , on November 20, 2008 | No Comments »

Haven’t posted here in a while as my spare time has been soaked up programing, well actually refactoring would be more exact.  My xLite “SQLite empowered Excel” codebase has grown over the years and required a serious makeover to get rid of stuff I no longer use and to generally make it more robust.  I [...]

Read Full Post »

xlAWS - 100,000 downloads?

Posted in AmazonAWS, Proto, S3, SQLite, SimpleDB, VBA, programming, xLite, xlAWS, tagged , on April 2, 2008 | 2 Comments »

Not sure, but this morning I received my monthly AWS bill, and it was double its usual amount! When I investigated the extra cost it was due to 133GBs of downloads from my www2.gobansaor.com bucket. This is the S3 bucket in which I store the xlAWS zip file, xlAWS being a “library-of-sorts” of [...]

Read Full Post »

Proto - desktop BI tool.

Posted in ETL, Proto, RSSBus, VBA, news, xLite on September 9, 2007 | 1 Comment »

I see that Proto have repositioned their excellent VBA scripted mash-up product as a “desktop business intelligence system”. This is to be welcomed as the first time I used it I described it as a “mash-up tool for adults” and although it has the ability to play hard ball with the other Web2.0 mash-up [...]

Read Full Post »

In Memory OLAP

Posted in BI, ETL, Palo, SQLite, VBA, data, excel, olap, xLite on September 5, 2007 | 4 Comments »

The consolidation within the BI market continues, this time with the purchase of Applix by Cognos. As Timo Elliott points out, the interesting bit is the Applix TM1 memory-centric OLAP product. For the vast majority of OLAP users (i.e. the millions of Excel Pivot table jockeys) in-memory OLAP is nothing new, but traditionally [...]

Read Full Post »

SQLite Star Query Part II

Posted in BI, ETL, Palo, SQLite, VBA, excel, olap, xLite on August 31, 2007 | No Comments »

In my previous post I looked at simulating a bitmap-join in SQLite using a sub-query and the INTERSECT command. The problem is of course, this is a simulation, SQLite lacks bitmap indices and although the sub-query will read only the fact table’s index B-trees (avoiding accessing the fact table proper) and should be [...]

Read Full Post »

Talend vs. Kettle (Pentaho PDI)

Posted in BI, ETL, Java, JavaFX, JavaScript, Palo, Ruby, SQLite, Talend, kettle, xLite, tagged on May 27, 2007 | 5 Comments »

Over the last few weeks I’ve received a lot of traffic from Goggle searches comparing Talend and Kettle and also from Vincent McBurney’s ITtoolbox article comparing the two products, so where do I stand?
As ETL tools they take different approaches, Kettle is a meta data driven framework (which is in turn tightly integrated into an [...]

Read Full Post »

I’ve got talend and I’m going to use it…

Posted in BI, ETL, Java, Palo, SQLite, Talend, data, excel, kettle, olap, xLite on April 30, 2007 | 1 Comment »

For the last few months I’ve being looking for my ideal ETL platform. That ideal would be open source, platform independent (well at least Windows and Linux), flexible, and easily deployable. It had looked like a combination of Kettle and my micro-ETL combinations of Ruby/SSQLite and Excel/SQLite would be the eventual “winners”. [...]

Read Full Post »

Proto

Posted in ETL, Proto, SQLite, excel, xLite, tagged on April 13, 2007 | 5 Comments »

In the two months since I first came across Proto I’ve worked my way through most of the tutorials and sample applications and I’ve come away with a very positive impression of the product. I hadn’t however managed to the find the time to create a VBA based component; that is until last [...]

Read Full Post »

Habemus Proto

Posted in ETL, Proto, SQLite, excel, xLite on April 10, 2007 | 1 Comment »

I’ve just uploaded my first Proto module; a rewrite of a VBA module I’ve been using for many years to provide me with a bridge between the ease of use of desktop user-focused tools and the power of a SQL enabled database. In the past that database was Oracle (and occasionally MS Access) and [...]

Read Full Post »