know.bi blog

What's new in Pentaho 8.1

Jun 5, 2018 10:00:00 AM / by Hans Van Akelyen posted in pentaho, Big Data, cloud, data integration, hitachivantara

0 Comments

On May, 16th 2018, Hitachi Vantara released Pentaho 8.1 Although this is a minor follow-up release to 8.0 as far as version numbers go, but nevertheless a lot of new exciting features and improvements have been added.

Read More

Easily load data to Neo4J with Pentaho Data Integration

Jan 25, 2018 10:00:00 AM / by Bart Maertens posted in data integration, pentaho, pdi, neo4j

0 Comments

Load data to Neo4J

Read More

Scalable PDI architecture using Docker

Jan 16, 2018 10:00:00 AM / by Yannick Mols posted in pentaho, docker

0 Comments

Shipping PDI in a Docker container

Read More

5 reasons to move your bi to the cloud

Jan 9, 2018 9:30:00 AM / by Hans Van Akelyen posted in pentaho, amazon, cloud

0 Comments

Cloud computing is the way to the future, and the way to bring your company to the next level. With the abillity to have enterprise grade services and technologies at a significantly lower price, your company can focus on creating more value while your IT department has to spend less time on maintaining infrastructure. 

These are our top five reasons to move your BI infrastructure to the cloud:

Read More

Business Intelligence, simplified.

Dec 18, 2017 9:30:00 AM / by Shila Casteels posted in pentaho, business intelligence, analytics, data integration

0 Comments

My views on BI after one year in the trenches

After having worked for about a year as a Business Intelligence consultant, I’d like to explain my views on the subject. At know.bi, we mainly work with the commercial open source BI platform Pentaho, so I’ll use that as a reference, but this post should apply to BI in general and is not meant to be limited to any given platform.

Read More

Multi-sheet Excel reports in Pentaho Report Designer

Dec 11, 2017 8:30:00 AM / by Yannick Mols posted in pentaho, prd, excel, pentaho report designer

0 Comments

Pentaho Report Designer - Multi-sheet Excel Reports

When you’re designing a report with Pentaho Report Designer (PRD) you may want it to contain sheets like Excel does. For instance we want interactive sheets and the ability to correctly export to Excel. Sadly this isn’t the easiest task, but here’s one of the ways you can get it to work.

Read More

5 new features to look at in Pentaho 8.0

Dec 4, 2017 8:30:00 AM / by Lokke Bruyndonckx posted in pentaho, pdi, pcm17, pentaho world, pentaho data integration, Big Data

0 Comments

A look at what's new in Pentaho 8.0

Read More

3 Reasons to take a look at WebSpoon for web or cloud ETL

Nov 29, 2017 8:30:00 AM / by Bart Maertens posted in pentaho, webspoon, pentaho data integration, cloud, cloud etl, web etl

3 Comments

3 reasons to move your ETL to the web, cloud

ETL development heavily relies on the desktop with files, database and network connections that require the developer to be the resources that are located in the company network.
Apart from these access restrictions, most of the established ETL platforms have a history of over a decade and were originally developed in an era where web based applications were basic at best.
Times have changed, however, and web applications have come a long way. We'll look at a number of reasons to move your ETL to the web and/or cloud. 

1. Data can't leave the organization

There are plenty of cases where data is considered to be too sensitive to leave the organization's premises or (virtual) private cloud. 
With a centralized ETL infrastructure, ETL developers and data engineers can work from anywhere in the world. All of the data is managed over secure connections without the need for a single byte of data to leave the organization's systems. 

2. Data is too big to copy or changes frequently

ETL developers and data engineers often need to work in geographically separate locations, while the data remains in one location. 
Developing ETL or working with frequently changing data over VPN connections and remote deskop protocols is painful, if possible at all.
Life can be a lot easier if the ETL and data management work can be done over a standard HTTP(S) protocol from anywhere in the world. 

3. Simplified installation, configuration and project management

Last but not least, ETL configuration management and overall DevOps for a large number of desktop installations can be a burden. 
Instead of maintining an installation on every ETL developer's or data engineer's machine, a centralized approach can significantly simplify the process. 

With a centralized installation, developers are guaranteed to work on the same standardized software version, configuration and set of plugins. 
Additionally, ETL working practices and conventions are a lot easier to enforce from a centralized environment. 

 

 

Try it out for yourself

If you're using or considering Pentaho (now part of Hitachi Vantara), all of this is within grasp: with the WebSpoon project, your existing ETL can simply be moved to the web and cloud. No changes to your existing code base are required, and you can gradually (or partially) make the switch to web or cloud based ETL. 

We've set up a demo environment for WebSpoon, feel free to give it a try.  

WebSpoon is available as open source and is not (yet) part of the Pentaho Enterprise Edition. Let us know if you'd like to find out how we can help you bridge the gap. 

  Talk to an expert!

Disclaimer: the use cases and images in this post were taken from WebSpoon author Hiromu Hota's presentation

 

 

 

Read More

Globchain recap

Nov 27, 2017 8:30:00 AM / by Lokke Bruyndonckx posted in GlobChain, BlockChain, pentaho, erp, cloud, co-creation, logistics

0 Comments

Read More

PCM17 - Business Use Cases Room

Nov 18, 2017 10:24:11 AM / by Bart Maertens posted in community, pentaho, pcm, pcm17, ctools, pdi

0 Comments

PCM17 - Business Use Cases Room

Read our overview of the Keynotes 

Read our overview of the talks in the Technical room

Using a BI tool to improve the management of health data in Mozambique - Devan Manharlal

Devan kicked off the talks in the business room by sharing his experiences in building a health data in Mozambique.
Part of the scope of the project was the geographical allocation of e.g. nurses over Mozambique, which poses some specific challenges in a developing country like Mozambique.
The reasons Pentaho was chosen are mainly because the need for 

Read More

Subscribe to Email Updates

Recent Posts