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.

Friday, May 22, 2009

Software liability

EU wants software to be liable like any other product.
This seems a good thing to me.
Since software is something that influence widely our life I think that is right to expect some liability from software producers.
Is absurd that people have to accept (even if they usually do not read it) something like EULA where is clearly stated that the software could well not work.
I'm paying good money for, it had better work.
This could go in the direction of introducing a higher level of professionals in code writing, something not always true, not all people employed to write code have the right skills to do it.
Obviously this apply to things you pay for and so it does not apply to open source software since is free software, you receive much more rights with the software than in a tipical proprietary software, you cannot also ask for liability.
In case of open source managed by companies like Red Hat, well this is what their customers are already paying for, they are paying for liability, they could have the option of getting the software for free, but since they need liability they pay.
So dear proprietary vendors, time is coming for you to accept your responsability: all products can heve problems a washing machine, a TV set, all heve to guarantee the customer that it works or thet it will be fixed.
With software is even more easy to give the fix, but the patch has to be produced no more "is not a bug is a feature" option around.
Software has to grow up and accept responsability.

Monday, April 20, 2009

Vision tracking

It's time to create some virtual reality or augmented reality.
Not only new methods of user interactions are possible using vision besed tracking.
For 2D tracking the reacTIVision project is really interesting.
RPG application can be a virtual tabletop controlled by "fiducial token ID".
It could be a nice integration for applications like MapTools.
For now installed the application and tested successfully.
Will have to find something for 3D tracking and eye tracking.
By the way it's an open source project.

Monday, March 30, 2009

Alfresco 3

It was long time I've not messed up with Alfresco (about a couple of years).
I wanted to see how it evolved in these months of development.
So installed it.
Really smooth installation (a thing I like much) obviously for a standard with no MySQL DB (for now) but this is something that I consider a plus in a software product.
The product is, as I had the pleasure to see time ago, a really solid solution and is evolving in a complete solution.
Really like it.

Monday, March 23, 2009

Essential project installed

OK managed to install Essential Project for multi user configuration.
The documentation is well done.
There are just a couple of things missing so here are some notes on the installation should someone hit the same walls.

The installation environment is Ubuntu 8.10, Protege 3.4, Java 1.6, MySQL 5.0
All went correctly up to the metamodel editing.
Before doing anything and especially before converting it to a Database format make a backup copy of the metamodel files, since if something goes wrong you will not be able to recover a working protege_server.
First you need to create the annotations file for collaborative work.
These files do not come with the downloaded zip and you can generate them using protege:
Just open the essential_baseline_v1.pprj with protege and in the Collaboration menu choose "Show collaboration panel" leave the default option to create the annotation files anew and you will be proposed correct nemes for the annotation file (it will be created in the same folder unless you decide to change it).
Also you have to create also GroupOperation for Viewer and Architects so that they can DisplayInProjectList and give to the repository you create in the 8.2 step of the documentation also this role (otherwise you will not be able to see it and choose it once you connect to the server).
The annotation project the documentation ask to define will map to the files created before.
This annotation project should not be displayed in the project list so do not apply that rule on it.

Ok now is installed time to use it ...

Enterprise Architecture the open source way

OK. I knew I couldn't manage to keep myself away from enterprise architecture for long.
I must admit that is a topic that seems to me not so much connected to the real life in the IT.
In any case one of the big problems is that there are no nice tools to help you getting started and to do a good job, especially in the OSS world.
I found the Essential project and I'll give it a try, it has also good tutorials to manage to have a more real grip to something near the stuff one has to manage everyday.