Pentaho 9.3, using cTools to build applications, and Kettle in Azure

• Pentaho 9.3 update and demo
• When Apps meet dashboards. Building a web application using C-tools (and friends)

Abstract:

At Ubiquis we’ve been building a dashboard/application for a customer of ours, One True Version, which helps importers and exporters make sense of their customs data and ensure compliance with all the rules and regulations around movement of goods as well as insights into how to best take advantage of the labyrinth of trade deals.

With CDE at its core, it makes heavy use of embedded dashboards, MDX queries, a Dynamic schema processor for multi-tenancy and row based security, SSO, on-the-fly datasource switching, some PDI transformations for database writebacks and a couple jQuery plugins to add functionality CDE is lacking by default. Data is maintained by a PDI ETL with scheduled tasks, ad-hoc runs, database versioning and multi-environment support. And it even sends emails with TLSv1.2 support (thanks to Sergio Ramazzina).

Nutritional information:
Contains large amounts of Javascript, MDX and bad CSS. Also contains traces of Java and SQL

• Using Kettle in Azure (From XpandIT)

As we all aim to get our BI Solutions more elastic in order to achieve our business goals of having them ready to use; scalable and sustainable we came across the use of Azure Cloud Container Instances to build Elastic BI Solutions.
Our talk on implementing Elastic Data Process with containers in the cloud will provide you with all the capabilities to tackle this challenge leveraging Pentaho Containers and Azure Cloud together to achieve more Elastic BI Solutions.

• Pizza
• Beer