The simplest way to replace variables in a string in Pentaho Spoon
Spoon: variable substitution in string A in the Calculator step
Why we keep picking Pentaho as our solution for our Managed Service
We have a firmly held belief that when you increase the number of staff members that participate in analytics – you significantly improve the value of your data assets. When your organisation has high value data assets your business is more efficient, more agile, and...
What your Data Life Cycle probably looks like
From Analyst, to Scientist, to Engineer A common problem we see is that different roles are using different methods of preparing and reporting data. What occurs is that there is very little collaboration between key data driven roles within the organisations that we...
Spoon: What ETLs are using this connection?
The question was: When I’m using a shared database connection, what other ETLs are using it too?
Your competitors are doing this. Why aren’t you?
Unlock your business – your team has the answers We have recently been reviewing the impact that data quality has on workforce productivity. In the analyses that we have seen, there is an impact of 10—32% of workforce time being wasted due to poor data productivity....
Pentaho Debuts on Gartner Magic Quadrant for Data Integration Tools
Pentaho prides itself on being data challenge agnostic when it comes to the technologies and data sources customers can leverage to achieve analytic business outcomes. Doing this means customers are freed from the hindrances of data and continue to increase analytics...
The Road to Reliable Predictive Analytics and The Top 10 Requirements That Bridge IT and The Business
In her latest contribution to Computer Business Review, Pentaho CMO Rosanne Saccone reflects on the book, “Do Lunch or Be Lunch,” by Harvard Business School faculty member Howard H. Stevenson. As she points out, while Stevenson’s book itself may be a bit dated, the...
5 Keys to Creating a Killer Data Lake
It’s been several years since the term “Data Lake” was coined by my friend and Pentaho co-founder James Dixon. The idea continues to be a hot topic and a challenge to execute properly. The problem is that too many people think all they need to do is dump data into...
Filling the Data Lake with Hadoop and Pentaho
The blueprint for filling the data lake refers to a modern data onboarding process for ingesting big data into Hadoop data lakes that is flexible, scalable, and repeatable. It streamlines data ingestion from a wide variety of source data and business users, reduces...
Introducing the Adaptive Execution Layer and Spark Architecture
Recently Pentaho announced the release of Pentaho 7.1. Don’t let the point release numbering make you think this is a small release. This is one of the most significant releases of Pentaho Data Integration! With the introduction of the Adaptive Execution Layer (AEL)...
Westfield Case Study
Westfield Group has one of the world’s largest shopping centre portfolios with locations on four continents. Last year more than one billion customer visits generated over $40 billion in retail sales from the world’s leading retailers. Wanting to improve the customer...
De Bortoli Wines Case Study
De Bortoli Wines is a third generation family wine company established by Vittorio and Giuseppina De Bortoli in 1928. The couple immigrated to Australia from Northern Italy, and created a winery with a foundation rooted in hard work, generosity of spirit and sharing...
3 Challenges to Unleashing Your Data Preparation Potential
There is a growing trend wherein business analysts have more control than ever to prepare and analyze a variety of valuable data, often circumventing IT processes and policies. What are IT leaders to do? Can they liberate data to be used by analysts, yet provide...
3 Steps to Easy Data Preparation
Data preparation is the foundation of any analytics project, but it has become more complex than ever as organizations struggle to handle new, messy data types and growing data volumes. Teams that want to build competitive advantage through analytic insight must...
Data Preparation with Limited IT Resources
May 3rd, 2017 - By Zachary Zeus I speak to a lot of customers that are all facing the same issue – they have a limited IT staff, they have a shrinking budget, they are using legacy tools to manage their growing data needs and they just don’t have enough time to...
Top 5 Ways Your IT Team can Enable Analysts to Work on Data Preparation – On YOUR terms
April 27th, 2017 - by Zachary Zeus If you are in an IT role responding to data prep needs from the business, you have likely seen some variation of an analyst emerge at your company. Viewed as the most plausible answer to a shortage of Ph.D. data scientists, analysts...
Family Owned Analytics
BizCubed has had the good fortune to work with the some iconic family owned and driven organisations. From Teys Brothers to DeBortoli Wines to Boost Juice. I was sitting down with the team from another family owned company and the work that we had done with other,...
Retail Zoo Case Study – Making Better Decisions Each Day
“Our services partnership with BizCubed and software from Pentaho has helped us give our franchisees the ability to ask more questions about their own businesses, and has provided them with tools to make real time and better retail business decisions for their...
SFTP Algorithm Negotiation Fail with JSch and Pentaho Spoon/Kettle
As encryption strength ramps up in response to increased security concerns, this can lead to the SFTP step trying to connect to a server that refuses to accept a 128bit key. The following error will appear in the logs:
Changing the Spoon shortcut keys
Ever hit ctrl+D in Spoon by mistake and lost your work? Learn how to change the short-cut keys.