Vanilla is an Open Source Business Intelligence Platform sponsored by BPM-Conseil. Vanilla provides an integrated and secured workspace to delivere business intelligence documents to end users (documents that leverage the information stored in enterprise database)

Different kind of documents are available for users with Vanilla :

• reports (Ireport & BIRT engines)
• Web reports (Web interface for creation and data exploration)
• Olap views (FreeAnalysis engine)
• Dashboard (FreeDashboard engine)
• Key Performance Indicateors (FreeMetrics engine)
• Maps (Googlemap integration & Map engines)

All Business Intelligence documents are accessibles through a unique BI portal or through external calls (Web Services or URL links). Our BI Portal provides user oriented functions such as document history access, document subscribtion, document schedule, document workflow management.

Along with those user features, Vanilla platform provides packages for BI developers, BI architectes & BI administrators :

Vanilla for Developers:

• FreeMetadata : component to create an abstraction layer between database and business views, where developer can secure access to different resources using group security and create complex filter strategy on objects or join strategy between tables
• FreeAnalysis Schema Designer : Award winning Olap Schema Designer on top of Mondrian rolap driver, that provide developer with advanced functions such as dimension/hierarchies real-time analysis, aggregate table wizard, asymetric or recursive dimension management
• Report packages : PlugIn for Ireport & BIRT report packages, that allow proven report designer to use secured FreeMetadata data source
• FreeMetrics Designer : component to create and manage a geolocalised KPI application, using different level of data representation, along with numerous properties for each items such as limit, objective, tolerance, owner ...
• FreeDashboard Designer : component to create and manage dashboards, using Bi ressources such as report (Birt, Ireport), graph (FusionChart, OpenFlashChart), filter component (data entry, list box, radio box …) and any kind of additional ressources (images, labels)

Vanilla for Datawarehouse Architects

• BiGateWay : data & documents services component, with advanced ETL functions (SCD management, Global SQL input management) and Vanilla specific functions (support of freemetadata documents, integration with freemetrics Kpi database ...)
• BiDwhDesigner : component to study, design or create database schema, with specific Dwh functions such as schema comparison, aggregate wizard or dimension wizard.
• BIProfiler : component to define profiling,data quality criterias and data cleansing scenaries using data exposed in Metadata documents.

Vanilla for Administrators

• BI Process Manager : scheduler based on quartz to manage the production and delivery of various BI components and BI (ETL job, report or dashboard creation, data profiling execution, KPI database alimentation)
• FreeMetrics Alert Manager : KPI alert management system to create, deploy and manage an alert application using FreeMetrics KPI database and criterias such as users type
• BI Workflow : package to create and manage BI process, based on proven Bonita platform, that allow definition of process such as « data extraction /data validation/data distribution », involving automatic process & manual validation
• "Enterprise Services" : administration package that provides features such as deployment of packages between servers, impact analysis on different objects, security of various documents and direct access to documents (stored in XML).

Vanilla - 10 Key features

• Secured Metadata integration with Birt and Ireport (SQL optimisation)
• Balanced & Business ScoreCard Platform (Key Performance Indicators)
• SaaS mode enabled, allowing hosting of different projects on a single server
• Admin package to manage servers (package deployment, impact analysis, document management …)
• Java packages to design and deploy Bi documents (no XML manipulation)
• Full integration of Dashboard / Report / Cubes and ETL documents
• Portal with Bi functions, such as report annotation, workbook, report history
• Numerous bi features, such as dynamic column content, alternate data source, burst mode (to validate security policy)
• Integrated ETL with support for SQL, Olap, FreeMetrics & FreeMetadata datasources
• Platform is supported by the development team

	Latest News
No News Items Found