Social Icons

twitterfacebookgoogle pluslinkedinrss feedemail

Pages

Wednesday, June 10, 2009

TEIID + SQuirreL SQL tutorial

As I wrote before is quite simple, but it took me little time to produce this one so here it is.
Last version of SQuirrel (3.0.1) with last version of TEIID.

Tuesday, June 09, 2009

TEIID and SQuirreL SQL

Continuing in the integration path: since I'm confortable in using SQuirreL SQL for accessing DBs I've tryed also to access the VDB from TEIID and I can say that after iReport the road is much more easy (once you learn the trick, magic comes easy).
So ... if I manage I'll produce another tutorial, for now warnings are:
* use JDK 1.6.
* include the teiid-6.1 snapshot client in the driver lib of SQuirreL SQL and create a new driver (I named mine TEIID with a great creativity effort); than create a new alias using that Driver (use the same data from the iReport example); test the connection and all should run smoothly.
Access the DB browse the tables and the data.
Will investigate on more complex usage tomorrow.

TEIID tutorial

Managed to finish integrating TEIID with iReport.
Since it has been a bit of a trouble and there is little documentation around I've made a tutorial to help my memory and maybe helping others around.
Here is the link.
I've created a VDB merging an Oracle DB and a MySQL one (that contain data from excel ... long way to integrate data ...)
The version used are TEIID 6.1 snapshot and iReport 3.5.2 (Java is 1.6), the PC is a windows box, but the stuff works also in linux (had to use that one this time).
Warnings are:
* mind the classpath it has been a pain to check it right.
* look for connector troubles at the firts sign of malfunction (there are some threads in the TEIID forum about it); it should be OK with this version, but in case of trouble is the first thing I'll look upon.

I'm really happy since now that all is tested and working can create a more useful VDB and get a bunch of data integrated and have a new view on information.
A great thanks to TEIID people for the product and the help in solving problems, hopes the tutorial can give something back.