Social Icons

twitterfacebookgoogle pluslinkedinrss feedemail

Pages

Tuesday, October 23, 2012

TEIID 8.1 tutorial - Part 5

We prepared a VDB in the previous part of the TEIID tutorial.

Now we want to test it on a TEIID server.

To do so we need a fresh and clean TEIID installation.

We download a JBoss AS version 7.1.1 and unzip it into a folder (I'm runniong the tutorial on windows, but you can do the same on linux).

I usually check that JBoss works out of the box before installing anything.

When you have checked the JBoss AS installation you are ready to install TEIID, that is pretty easy stuff to do as you have to download the TEIID distribution and just unpack it into the JBoss installation; there is the same folder structure so everything will go to its place.

For the demo we'll going to run JBoss in standalone mode, this means that we'll look at the files into the standalone folder.

Since there is a standalone-teiid.xml file I usually create a start script to set the config file to be that one, but is a habit of mine, you can rename it standalone.xml and work on that (just keep the original standalone somewhere should you need it).

Done that just start JBoss again and this time we'll see that also TEIID modules gets loaded and it is ready and running; obviously there is no DB right now.

Shut down everything and make some few configurations (all these stuffs can be done in different ways, as a tutorial I prefer to show what gets written into the XML file so that is known what web consolle does behind the scene).

Since we are going to connect to MySQL we need to prepare the module for MySQL with the driver so that JBoss and TEIID can make a connection to MySQL create a datasource to our DB with the correct jndi name we used in the VDB.

The TEIID installation comes with a usefull set of examples/templates for the modules so we just have to copy the MySQL one in the modules folder, copy the jdbc driver in the folder, configure the modules with the correct name of the lib and the driver is ready.

We than need to add the driver information within the standalone.xml file.

Done that we can add the driver information in the standalone.xml file and set all the parameters to be able to correctly connect to the DB.

When you have finished the configuration start JBoss and go to the web concolle and check the functioning of the datasource testing the connection with the DB.



Once we have finished this part we can deploy the VDB.

Thursday, October 18, 2012

Project ReteLIM - thanks to open source

I'm working on a very interesting project called ReteLIM.

Is a project to help hospitalized children to stay in contact with their class and to enable them to work together with their classmates.

I'm working side by side with teachers finding the best technical solution to apply to the task.

The project aims to define which hardware and software use and how to help teachers apply technology to the learning experience.

The model start with hospitalized children constraint, but can be applyed to any "remote" situation.

Our idea is to implement a "virtual classroom" using integration of open source tools to enable a complete learning experience helping a standardization of approach.

We decided to use a cloud hosting to serve the software.

In the cloud the teachers will find a Ubuntu desktop that they will be able to access from anywhere thanks to NX web access.

This desktop is loaded with all sort of program dedicated to education (it could be an Edubuntu distro, but for now we preferred to go with the standard one).

This desktop will also mount an NFS share from a server.

The server hosts an integrated environment composed by Joomla!! + Moodle + Mahara + OpenMeetings (single sign on thanks to Joomdle).

The nfs share will be seen by Moodle as a repository so all the content, produced and saved into a particular folder of the desktop, will be seen and available to Moodle without any trouble for the teacher.

Also OpenMeetings will be available as a Moodle activity so that it will be possible to use it to work with the hospitalized child and the support teacher (the teacher will be equipped with a tablet PC) and the class where a LIM (that is the italian acronymn for an interactive whiteboard) can be used: either the one done with the WII or commercial ones that public administration gave to the school.

The project is fantastic and the energy of the group is vibrant, this is why I choose IT as working life: it can really help making the difference for the lives of many, seeing the happyness in the eyes of the children that can feel to be still part of a normal routine is the greatest satisfaction.

I just feel that is important for me to thanks all the people that work in the open source ecosystem: without their work this project would not be possible and affordable.

Thanks guys.

Evolution of TEIID 8.1 tutorial

I've decided to expand this tutorial to add integration with other pieces of software I'm using in the Open-DAI project I'm working on.

Just to remember what I've already published in the tutorial right now:
1) Create a relational mapping
2) Create a XML document from an XSD schema
3) Map the relational DB to the XML document
4) Create the VDB

Planned coming next:
5) Install TEIID in JBoss AS
6) Deploy the VDB in TEIID server
7) Connect to the VDB with SquirrelSQL and get the XML document with a query
8) Create a web service that will publish the relational tables
9) Deploy the new VDB and the Web Service and test it with soapUI

The tutorial will follow these additional steps to demonstrate the integration of a data service generated with TEIID with other platforms:

10) Publish the TEIID web service with WSO2 API manager
11) test the published API with soapUI
12) publish the relational tables as REST service
13) Call the REST service using node.js
14) Call TEIID from node.js
15) How to update tables from a VDB

This will be the "coming next" for this tutorial, if you are interested in some more integrations or further explanation please leave a comment.

TEIID tutorial 8.1 - Part 4

In the previous steps we created a relational model from a MySQL DB, we imported an XSD and created an XML model document based on that XSD and mapped the relational tables to the XML document.

Now we need to create the VDB so that all this work can be used in applications.

The Virtual DB will be treated as a normal DB and we'll connect to it with SquirrelSQL and issue a query to get back the XML document.

The process require to create in our project a new element that is the VDB database, give a name in the form and do not choose the models in the form, we'll to it later.

Now we find in the VDB view and we need to choose which are the models we want to publish: we need to remember that in a VDB we need to include all the models an which the model we'll query depend on.

If we choose the model we want to use TEIID Designer will automatically import all dependent models.

Also have to remember that if we make modifications in the models after we included them in the VDB we have to come back in this view and mark the checkbox that will be unmarked by default (this is a reason of many troubles).

After having included the models we have to save the VDB and we are ready to deploy it in a TEIID server.

Since TEIID is a module of JBoss AS weìll need to install TEIID into a clean JBoss installation.

We'll explain how to prepare TEIID to be able to deploy our VDB.


Thursday, October 11, 2012

TEIID 8.1 tutorial - Part 3

In this part the target is to create the view model from the XSD to generate an XML document based on one of the XSD elements.

I choose bookListing.

You create a new Model and choose "XML" instead of "Relational"; obviously it asks you the XSD to use and you choose the correct one from the project.

Now you got a new "orange" model (a view model) with an object of type XML document.

The problem is how to fill the XML with relationa data.

The mapping tool comes to help, but you have to know well your DB and the XML you want to generate.

In this easy example you have to fill the book element and the author one: this means two mapping and the second depends on the first since the author depends on the book (in this XML).

So there goes the mapping, not too complicated (you could also write down the query by hand, but the tool is usefull).

I'm just not able to force it to choose "object" conversion instead of "string", but in any case is possible to fix it by hand.

Remember to save before invoking the tools otherwise an annoying popup will remind you that you have not saved.

In the end you have mapped a relational DB to an XML document with ease ... and now what?

Well you can query it with SquirrelSQL or publish it as a web service ... but before you have to do the most important thing create the Virtual DB.

But this is stuff for the next part of this TEIID tutorial.


TEIID 8.1 tutorial - Part 2

Here the second part: very fast, just importing the XSD that we'll be using to create the view model.

Just remember to place the XSD in the schema folder; sometimes it gets quirky and do conflicts with the preview files it generate in the root during the import.




Go to the third part of the TEIID tutorial.

TEIID 8.1 tutorial - Part 1

This is the first of a series of tutorial on the use of TEIID.

TEIID is a piece of software from JBoss that allows you to do very sophisticated EII creating a new virtual DB getting data from many different sources, transforming them and publishing in different ways.

In these tutorials I'll explain how to get a relational DB (from MySQL), and exposing its content as an XML document conforming to a given schema through either a JDBC connection or a SOAP service.

The video is without audio since I do not like to talk too much during registration and I'm too lazy to record it later.

Also the installation is in italian, but hope that is clear enough for all to understand in any case leave a message is something is not clear.

This new tutorial uses TEIID version 8.1 on application server JBoss 7.1.1 and TEIID designer 7.8

I'm starting from a mostly clean and fresh installation of Designer (did not record the creation fo the MySQL driver, but should not be a problem).

This first part explain how to get the physical model from the DB, very quick and easy.

For sake of easyness I'm using the book DB you find around in the examples from JBoss so you'll find youself at home.



Go to the next part of the TEIID tutorial.

Yii framework and CloudStack and Flex and ...

For the Open-DAI project I need to create a quick and dirty consolle (I hope it will become something more sophisticated, but for now I need something functional).

The target is to manage to pilot CloudStack to create VMs. I cannot use the CloudStack interface since it does not allow for adding "user data" so I need to use API calls to di the job

The problem is that I need to do this job cross CloudStack domains.

So have to get the list of API key and secret key and other CloudStack related data and write down a small program to issue the calls.

Obviously since you need to manage creation you need to be able to see what is going on in time so a small DB will be needed and also since the architecture of Open-DAI require to create management VMs in a precise order There will be the need to manage a simple workflow.

I also like to present the user with a view of the architectural deploy model describing the state of the deployed VMs.

Since I want to do things in a fast way without having to install too many things I decided to use PHP, a SQLite DB, Flex for the "toppings".

Since I believe that reinventing the wheel is not advisable I looked over to some of the PHP frameworks around ... at firts looked at Zend 2.0 ... really nice but ... damn complicated, you surely manage to do a lot but have to overcome a steep learning curve, so after few hours of hacking I looked somewhere else and ... landed on Yii.

Well I can say I'm surprised. It took more or less three hours (following the tutorial) to have a first scratch of application, integrated with the CloudStack library and ready to receive some of the code I already prepared in the last days (tomorrow will be a day of cut and paste and fix).

I can advice to look at it.