Vanilla v3 (post 9 on 10) – Compliance to Open Standard

Dear Readers,

Important subject in Open Source area is to be ‘standard compliant’. Bellow is a remember of notions and features we have introduced with Vanilla v2 and enhanced with upcoming Vanilla v3 :jdbc driver, oda drivers and remote call to bi document

Jdbc driver for FreeMetadata, to open FreeMetadata document to any report designer or etl engine that support jdbc databasource.

Note : for Birt report designer, no need to use jdbc driver, but instead, you can use the FreeMetadata plugin. Same situation for BiGateWay Etl : there is a native interface available in BiGateway to manipulate FreeMetadata document (but this support can be usefull for other Etl to access to a FreeMetadata “database alike” structure)

FreeMetadata Jdbc definition in Enterprise Services

Jdbc definition in designer (bellow, our BiGateway Etl)

FreeMetadata – through jdbc request definition – Data visualisation

Oda drivers integration to facilitate data access and hide the complexity of internal storage architecture, and also provide an Eclipse way (like jdbc) to access to many Vanilla resources using oda. We provide different kind of drivers, to access FreeMetadata document, Googole document (spreadsheet or table), inline table or FreeMetrics Kpi database. Bellow is an exemple with a FreeMetrics Kpi Oda driver

Oda drivers list

Kpi data visualisation using FreeDashboard

Oda driver and different kpi views

Result in Vanilla portal

Note : Posting wrong information is a shame – in reference to what I recently saw about a new oda driver to access another Open Source Metadata. All is hard coded in the interface, and they are not abble to publish to the portal … so, what is the use ? What is the credibility of those kind of posts and the credibility of the blog writer ? Using Vanilla, all is smoothly integrated !

External remote call to Vanilla object and Web Services

You can easilly publish any Report or Dashboard document as “public”, using a specific profile (group) for data access. Once publish using Enterprise Services, you can manipulate a Url and embed this Url in any portal. If you have java skills, you can do the same calling our document using a set of Web Services

Url and profile (group) definition using Enteprise Services

Result for copy/paste of Url in a browser

Just have a look at what those features can provide :

– an easy way to use FreeMetadata as a secured central – multi type – database (like RedHat Teiid … but with more designer & security features available)

– easy access to any Vanilla structure using oda drivers, in addition to providing access to others database (Google)

– easy way to embed any Vanilla Bi document in already deployed Web interface (such as Portal, Cms, …)

Have Fun !


Vanilla v3 (post 8 on 10) – Bi document Integration using FreeDashboard

Dear Readers,

It’s always funny to see how some “said platforms” have integrated modules. In commercial software, and even more with some Open source platforms,you may have to deal with 2 or more authentification database, variables database, scheduler or workflow engine. And you need to be happy if the interfaces have same Look & Feel (which is so important when you work all day with the different packages)

Using Vanilla is a guaranty developer & admin will safe time by managing a unique database of reference, and having all the component available when designing a Bi document. For example, BiWorkflow and BiGateway leverage all the others Vanilla documents : reports, dashboard, cubes & kpi database. And all Vanilla Development packages have the same Look & Feel (Birt alike), and are using the same set of components (for example : Oda drivers)

Vanilla Oda Drivers available in Designers

For visual document integration, we provide FreeDashboard with a new set of features that allow Bi developer to easily and visualy integrate Report, Reports on Cube, standard reports, Kpi and Maps, all documents beeing manage by FreeDashBoard filters. In the example bellow (Performance Dashboard), we apply a filter on country, I provide you with pairs of screenshot : what you see when using FreeDashboard and what you get in the Vanilla portal. No lines of codes, visual package to manage deployment between servers … we make it so easy !

Olap & Kpi using FreeDashboard

Olap & Kpi in Vanilla portal

Maps using FreeDashboard

Maps in Vanilla portal

Report using FreeDashboard

Report in Vanilla portal

As you can see : no javascript framework to develop Dashboard … we are now in 2010, it’s time for visual development (!!!) and out-of-the-box Bpi Platform

Again & again, all those documents are developped using FreeMetadata secured documents, that ensure every user will have access to his own set of filtered datas, using a central Metadata document to set security rules …

Have Fun !


Vanilla v3 (post 7 on 10) – FreeWebReport

Dear Readers,

With Vanilla v3, we provide power users with an enhanced version of FreeWebReport, that support – in short – muti datasource (Metadata document), multi data set (dataset beeing link or not, based on context),  a new set of layout (that is close from what is available in FreeDashboard) and additional graph & calculation formula.

With those new features, FreeWebReport leverage the Birt engine & Birt Xml definition used to produce the report (Birt is also based on a multi datasource/dataset, and FwReport set of functions is Birt alike). In addition, every report created by FreeWebReport can be open by a Birt java studio (for additional layout arrangement, such as pixel perfect column definition)

My personal opinion is that the last thing missing to FreeWebReport is a real Wysiwyg Web interface that could be provided in parallel to the easy-to-use Wizard, along with support of additional type of graphs … that’s why we will continue to provide new release of the module …

New layout management : basic report definition

Multimetadata support for datasources

Join Dataset Definition in FreeWebReport

Graph Definition

Calculated column : Formula Definition

Result in Vanilla portal

Your comments are welcome !

Have Fun !


Vanilla v3 (post 6 on 10) – Vanilla Disconnected

Dear Readers,

For those who need to browse cube, report and dashboard offline, Vanilla Apps will provide you with this key feature, with a new package called Vanilla Disconnected (aka “disco”), compliant with Vanilla v3

“Disco” is a pure java client to browse Vanilla document, assuming your admin first design & build the disconnected packages.

Bellow, 4 simple screenshots to tell you more about “Disco”

Package Creation using Enterprise Services

Cube / Report  or Dashboard Selection using Enterprise Services

Disconnected Document Settings using Enterprise Services

Finally, Vanilla Disctonnected to view the package

… well, no secret, there is a replication process before, either by connecting against the server and running a live replication, or installating a disconnected package that user download from any interneal ftp server

Have Fun !