Web applications Archives - professional collaboration

Colibri Open-BI Appliance, v16

Colibri Open-BI Appliance v16 is released!

BI 4 Everyone is the motto of this project. Colibri Open-Bi Appliance provides an out of the (virtual) box solution for your easy start into the world of Business Intelligence.

Colibri is based open source versions of Jedox OLAP Server and Jedox ETL Server and provides a web-based ETL interface as well as a reworked plugin for Libre/Open Office for convenient interaction with these services.

Colibri v16 contains feature and performance enhancements as well as fixes for stability and security. It is optimized to run on Ubuntu MATE 16.04 LTS.

A rich set of sample data sets aims to leverage your learning curve and to enable you to rapidly build your own BI projects.

Colibri Open-BI Suite is intended as a good starting point to BI for a broad audiance with a focus on science and finance. It aims to succeed the last version of Palo-BI-Suite (OS), which has been discontinued by Jedox. Jedox-Olap-Server and Jedox-ETL-Server are trademarks of Jedox AG.

Download Colibri Open-Bi Appliance here.

License: GPL2

Slides Linuxwochen Vienna: Linuxwochen14

Contact: Christian Schwarzinger
Palo ETL-Server & Colibri
Customer: Jedox AG, Germany

“Be realistic, demand the impossible!” was the motto of the year 2006, when members of Proclos started to work on an web-based ETL tool geared towards transformation of all kinds of flat data sources into multidimensional data cubes for later OLAP-analysis.

Contacting Jedox AG, the manufacturer of Palo-OLAP-Server, was the starting point of a great success story, as our tool rapidly evolved into the product Palo-ETL-Server with many thousands installations world-wide and a large community of satisfied end-users in the BI departments of numerous companies.

While still being activly involved in Palo-ETL-Server developement for Jedox to make it the best ETL product on the market, some of our own projects eventually posed the need for an embedded ETL tool with needs transgressing the existing product-centric strategy towards a more tool-centric strategy. So we decided to give birth to project Colibri.

Colibri is based on the Palo-ETL-Server 3.2 release and is intended for developers to implement their own components and extensions preferably for embedded use within other J2EE applications. As starting point Colibri features the following extensions:
- Integration into hibernate domain models with the ability to extract, transform and load entire domain objects, which makes it ideal for domain model import, export and consolidation (e.g in opensmc).
- Integration of a syslog server, which accepts log data from all syslog compatible clients and loads them online into cubes, which makes it a cool solution for e.g. real time multidimensional network analyis.
- Support for reliable messaging protocols and enterprise integration patterns via integration of ActiveMQ, which allows for a distributed network of data sources such as encountered in cloud stack environments.
- Improvements on web service extracts, which allow usage as generic connector for all kinds of sophisticated web services such as the eBay-API.
Colibri sources are available here. All dependencies are fetched from the Proclos Nexus repository by Maven.

Palo-Olap-Server and Palo-ETL-Server are trademarks of Jedox AG.

Contact: Christian Schwarzinger
Content-Pool
Customer: City of Vienna, MA 53 – Press and Information Services

Mastering the challenge of developing an Open-Source solution for the public administration, members of Proclos sucessfully accomplished the Content-Pool project.
Internally nicknamed Fluxomat (in allegory to the Flux-Generator’s deus ex machina ability to enable the impossible), it features a web-based software for fetching, persisting, filtering, editing, syndicating and remixing RSS- and Atom-Feeds in various formats including Media RSS containing multimedia data.
The aim is to support a team of professional editors to benefit from distributed content production, while being able
- to use a standardized central metadata repository for content tagging
- to quarantine, overlay and re-style the content within a single application.
- to create own topic specific meta-feeds based on relevant content
- to (re-)present those meta-feeds in the context of related new articles
Content-Pool is built upon enterprise java technology, runs within apache tomcat and integrates into existing security infrastructure supporting Gondor / Portalverbund interfaces.

Contact: David Ayers
Proclos Team granted with T-Systems Innovations Award
Mastering the long and winding road in developing Open-Source software solutions for the social-medical healthcare sector was finally crowned with sweet success.
A Proclos team and its cooperation partner Verein Dialog, the leading ambulant addiction aid agency of Austria, were awarded with the T-Systems Innovation Award Vienna for the project openSMC.

The jury did espescially honor the fact that openSMC:
- enables a smooth and transparent information flow among specialized groups of cooperating professionals.
- reduces administrative overhead while complying to intensive documentation and evaluation needs.
- consequently directs more time towards effective client care and client support processes.
Beside common CRM-features adapted for medical needs, special features of openSMC include support for:
- multiprofessionial and multidimensional diagnostics.
- arbitrary information views, alerting and notificating.
- prescription of narcotics conforming to legal standards.
- changing data acquisition needs by an integrated survey engine.
- highly flexible data export / import by integration of Colibri
Special thanx to ZIT, who co-funded the project as part of the ZIT08 Plus innovation program. Source code is available here.

Contact: Martin Kulnigg
Steffi & Janus
Customer: OMB-Automation, Germany

Deploying Open-Source Software Solutions into the highly proprietary area of automation systems was the challenge of the projects Steffi and Janus.

In this process members of Proclos mastered the cross-platform integration of numerous heterogenios technologies from the network infrastructure to the business intelligence layer and finally successfully contributed:
- a Zope3 based web-application as monitoring front end for a solar crystal manufacturing chain, which evaluates and visualizes data from the automation process stored in a relational backend and provides both an ad hoc SQL-based analysis tool as well as an interface for exporting the data to a Palo-OLAP system for further multidimensional analysis.
- a Centos based virtualization environment for rapid deployment and rollout of the entire automation system providing a Postgresql cluster based on DRBD, Corosync and Pacemaker as relational backend. The setup is completed with a virtualized pfSense firewall providing IP-range independence for the cluster and full remote desktop access to all virtual machines using the rdp protocol.
Special thanx to Jeremias Keihsler (OMB) for being both an excellent co-developer and customer in this project.

Contact: Peter Füreder

Colibri Open-BI Appliance, v16

Palo ETL-Server & Colibri

Content-Pool

Proclos Team granted with T-Systems Innovations Award

Steffi & Janus

categories

cloud

links