Vanilla v4.2 – 13/16 – Continuous Integration

Dear Readers,

When it comes to Platform integration, there are differents approachs and results to achieve :

  • How the different components of the platform are connected or communicate between each other
  • How the Platform can be easilly integrated in an existing architecture :
  1. Vanilla component can be used as a service by the other
  2. Vanilla can integrate with standard resources, like Single Signon mechanism, Web Portal Integration, Scheduling or Workflow integration …
  • How the Platform can leverage existing services (externam engines) to make usage of it (as an exemple : Solr/Lucene integration with Vanilla)

Let’s focus on the first question : how components are making a global platform alltogether, a coherent and full feature Bi platform. Honest, I feel proud of what our dev team has done with Vanilla. Since early version, our Metadata has been the central piece for all that deal with secured business dataset manipulation, and we never stopped to think about what component can be integrated with any other component.

Integration is everywhere with Vanilla – from inside the development studio to the user interface but also with the different engines that manage the documents. Just let me give you some simple exemples, some are already available since Vanilla 3.0 or Vanilla 4.0, and we make it even more easy to use

  • (v4.2) Mdm/Etl integration for Developer : Any Mdm document is a datasource for Vanilla BiGateWay Etl. This makes the integration of external files much more easy to manage, and keep the database consistent. At user side, document registered in the Mdm (any new version of an existing document) can be upload from Vanilla Portal by authorized User … giving user the possibility to upload a file, and run the associated Etl from the portal … and we can even think they will run the report that display the uploaded data …
  • (V4.0) FaWeb/WebDashboard integration for User : when exploring a cube, its so easy with Vanilla FaWeb to save report snapshot of grids … then to turn all those olap grid into a single Dashboard with an associated filter page (when cube report have prompts). Just try it, you will find it so easy to manipulate, and so powerfull for later reuse or wide publication
  • (V3.0) Reporting/ Document Management & Document Indexation : when it comes to run a report, and decide to save it to Vanilla Document management repository (either user action through portal or inside a Workflow), just enjoy the automatic indexation of reports to find report using content search on keywords

There are so many other technical or functional cases inside Vanilla to show out of the box integration … just try it, you will be delighted ! I will focus in another post on the Kpi/Olap/Maps integration, it is worth a post in itself … stay connected !

Have Fun,



Vanilla v4.2 – 12/16 – Vanilla Mobile Report Designer

Dear Readers,

With Vanilla 4, we released Apps for Ios and Android (tablet and Smaprtphone), which stand as an application to connect to Vanilla portail (Apps version, not Web version) and run a document (Report, Cube, Dashboard or Etl/Workflow). I personally use almost every day the Android Apps on my Htc smartphone (Android 2.4) … then on my S3 (Android 4). It’s running pretty well, and do what it’s expected to do : provide access to report in convenient way. For cube, it was already more than a simple browser : you can manipulate the dimensions and the measures, and navigate in your cube … you can even run maps …

First version of Vanilla for Android with Vanilla 4


With the emergence of new Ios and Android version, we had more functions to move from a simple reader to a Report Designer, using the lastest technics and design conventions to facilitate acceptance from any users. The first version is available for Android 4, and it’s design to be used with Tablet rather (I mean, on a smartphone, screen is little to small)

Vanilla Mobile Report Designer is close from FreeWebReport (Wysiwyg) in terms or design and workspace layout : we are using a simple palette of widgets, providing access to Metadata as datasource and data resources (like filters and prompts), and user can either save their report on local or export/import their report on Vanilla repository, to run it later from our Web portal

Vanilla Mobile Report Designer – Palette and workspace


 Vanilla Mobile Report Designer – Report Design with Metadata Resources


Vanilla Mobile Report Designer – Report Preview


Vanilla Mobile Report Designer – Export – Import Process


In 2 weeks, you can enjoy a preview of Vanilla Mobile Report Designer … and it’s free of charges ! Just rethink how you access and consume your Bi documents, and how much you pay for simple access …

Have Fun !


Vanilla v4.2 – 11/16 – Numerous Update of Dev & Admin package

Dear Readers,

While designing version 4.2, we reviewed some interfaces to make it easier to start with. This is particularly visible with our Portal, that get many enhancement and is still more easy to use (we tried to removed as much as possible right-click button to offer fast access icons on workspace), but it’s also valid for designer and admin interfaces.

Let’s have a look at the 3 major admin interface with a simple example for each one :

Enterprise Services

Enterprise Services is the package to manage security, packages deployment, cross references, document properties …. just have a look at the simplified user session manager … very convenient to see who is connected, on which server, running which object … it’s real time information !


BiProcess Manager

BiProcessManager is the package to manage shceduling of task (report, etl, workflow). Just have a look at the simplified interface, where you can watch the task definition, the scheduled tasks, and the tasks that already executed (with status).



Norparena is the package to manage external objects like maps, forms and also documents. Norparena document manager has been simplified, with still same set of functions to manage report indexing, version of document, have a global view on documents, rebuild index …


Keeping interface easy to use is an everyday challenge, while providing more functions and informations. With version 4.2, we did a good balance between functions availability and clean interfaces … and we will review again if needed, to make it easier and easier

Have Fun !


Vanilla v4.2 – 10/16 – Vanilla Apps Update

Dear Readers,

Started in december 2009, Vanilla Apps is now 3 years old, and every year in december, we provide new products or packages to the community, like Christmas gifts.


Vanilla Apps are application that don’t belong to the Core Vanilla platform, but can be installed or plug in addition. Except Hypervision (a Vanilla monitoring package), most Vanilla Apps are package build on a market application, where we provide Metadata, Reports, Dashboard and Cubes.

History baseline of Vanilla Apps will give you an overview of its content :

  • December 2009 : First version of Vanilla Apps, with 6 initials packages
  • December 2010 : First version of Hypervision, our package to setup and monitor a farm of Vanilla Servers
  • December 2011 : Our dev team delivered VanillaPlace, a Java & Web Application available from Enterprise Services to access and deploy Vanilla Apps packages (just go to this post to get details on Vanilla Place)
  • December 2012 : major update for Vanilla Apps, with 20 apps available and a global update in Vanilla 4.2 format

Vanilla Apps packages cover different business area, from e-commerce application to Pos application, through Crm, Held Desk, … This classification below can be discussed, as sometimes, Vanilla Apps package cover only a simple group of tables of a complete application (Vanilla Apps documentation can be found on our company WebSite)

  • CRM : VTiger, SugarCrm, OpenCrx
  • E-Commerce / Billing : Neobill, PrestaShop, Magento
  • Development Management : DotProject
  • Support and inventory : Glpi, RedMine, Mantis, Sit
  • University /High school : Cocktail,
  • Training Management : Moodle
  • HRM : OrangeHrm
  • Network Management : Nagios
  • ERP : OpenBravo, Dolibarr
  • Survey Management : LimeSurvey
  • ECM : Typo3
  • Site Stats : GoogleAnalytics

If you have a Vanilla instance, getting access and deploying Vanilla Apps is fast and easy … don’t hesitate to download and deploy it, and contribute by reversing your own development, like Dashboard and reports. If you have a need for a specific application to be available as a Vanilla Apps, don’t hesitate to drop me a mail, as we have now a dedicate team on Vanilla Apps, to speed up its adoption and provide support & development on it.

Have Fun,


Vanilla v4.2 – Beta Version available

Dear Readers,

Just on time !  As today it was supposed to be the end of the world … or the end of a cycle at least ? Anyway, today is the start of a new era for Vanilla, as we make version 4.2 available in Beta in download. I’m little annoy, because I was so busy those past days, and i’m late closing the “New Features” document (should be done on time for January 13th) … but those who read my previous posts know already about 4.2 new features.

Vanilla 4.2 Beta Download Website

All the packages (development, Admin) and Server are available for download.The VirtualBox is also available, with an updated documentation for those who are new with VirtualBox. For any Feedback or Questions, dont hesitate to drop a mail to … our support team will take care of your questions. For any technicals questions, please use our forum

We are 3 weeks before official launch of Vanilla 4.2 … just stay connected, and review your Bi strategy …

Have Fun !


Vanilla v4.2 – 9/16 – Web Designers update

Dear Readers,

Vanilla 4.2 provides Web interfaces with new functions that “makes the difference” when decision makers are using Web Interface to manipulate data. Let’s take 2 simple examples in this post, with FreeAnalysis and FreeWebReport


Web interface comes now with a Simulation/Forecast Feature, that allow user to develop “What If” Scenario or view cube data evolution based on time linear forecast.

Another crazy feature of FreeAnalysisWeb is the possibility to drill through to another document, like a Report or another cube, passing the current filter or member value as parameters. To drill between cubes, we are using dimension names association. To drill to reports, user just need to validate the parameter’s values. So simple !



More features in FreeWebReport, like crosstab (yes, in Web … just imagine other platform don’t even provide this feature with their report development studio !), Maps support (yes, to add Map in your Web Report and associate a dataset of value on the map !)


This post could have been longer, if I wrote about enhanced FreeDashboardWeb and WebKpi, our Web Dashboard and KPI interfaces … just wait the final documentation, or better : download soon the 4.2 platform and start enjoying our clean Web interfaces

Have Fun,


Vanilla v4.2 – 8/16 – Solr/Lucene Integration

Dear Readers,

Sometimes, when you chose some piece of software, you are lucky … or not. When we started our Web development, we took Struts/Shale (2006) … then we moved to Dojo (short experience in beginning 2007) … and in july 2007, we were lucky to turn to GWT. 5 years of GWT experience makes the difference, and result in version 4.2 is there : when I demo Vanilla v4.2, it’s always a pleasure to get customer recognition of our choice, in terms of interface and design.

Same thing happen with Lucene ! In late 2009, when we designed the architecture and components for version 3, we decided to embed an indexation engine. There was different software and Api available, and we chose Lucene. Some already know the story : in september 2010, we released Vanilla version 3 with an embeded Lucene to index our reports and a Search interface “Chrome alike”. Lucene was a lucky choice, because – with the ermegence of Apache Solr/Lucene – we are able to make Vanilla compliant with an existing Solr/Lucene infrastructure. I used to demo this at LuceneRevolution in may 2012 in Boston (finally a platform that makes usage of Solr/Lucene at worldwide level)


What is the advantage of Solr/Lucene with Vanilla ? We can empowered an existing infrastructure : supposed your Document Management platform is Solr/Lucene compliant … we can share the same Solr/Lucene server ! Solr/Lucene is the de facto standard for indexation, it’s like a “take it … or leave it, leave the indexation area”. Enterprises have more and more documents, and there is a need for simple document management platforms, powered by Solr/Lucene, that complies with standard JSR. Vanilla Document Management module – powered by Solr/Lucene – is a ready-to-deploy platform to manage Bi services and document management … just review post 5 of this serie for additional information.


Have Fun !