Software Dev.

Software development articles by Daniel Pradilla on programming, Python, AWS, AI, and practical engineering work.

Pentaho is slow for servers with too many home directories

Over the course of two years, browsing solutions on our Pentaho 5.4 server became progressively slow. It came to a point in which you had to wait 2-3 minutes to see the list of solutions in the Pentaho User Console. The catalina log didn’t say much and we didn’t have too many solutions (around 200),… Continue reading Pentaho is slow for servers with too many home directories

Linear Optimization with or-tools — building a web front-end with falcon and gunicorn

In a previous post, I put together a script for solving a linear optimisation problem using Google’s OR-tools. This python script is callable from the command line and you kinda need to know what you are doing and how to organize the parameters. So, in order to address this difficulty, I wanted to build a… Continue reading Linear Optimization with or-tools — building a web front-end with falcon and gunicorn

Linear Optimization with or-tools

  Getting started Over the last couple of months I’ve been getting my feet wet with linear programming and mathematical optimisation. I got a sense of how it all worked from this Discrete Optimisation course in Coursera and googling around I discovered that there are a ton of tools out there to help you solve… Continue reading Linear Optimization with or-tools

How to Connect Pentaho Data Integration to SAP HANA

Recently I had to connect Pentaho Data Integration to SAP HANA and I made some notes along the way: The first step is to get the SAP HANA JDBC driver, a file called ngdbc.jar. The quickest way is to download and install the SAP HANA client from the SAP Software Download Center, and then extract the… Continue reading How to Connect Pentaho Data Integration to SAP HANA