Pentaho for ETL
August 13, 2018
Recently I was asked to install and run a bridge between a MSSQL database having SAP datasets to import into SugarCRM Ondemand (Cloud) instance. Thus, I created a development environment with the same data and connection. The steps for running Spoon (aka Kettle, which was bought) follow. Applicable to Pentaho Versions: 7 – 8.1 1 […]
MySQL databases
February 20, 2018
Most of open source solutions make use of MySQL-based engines such as MariaDB. When well configured, they are indeed reliable and trustful. Database administrators or support staff might need specific queries. I came across situations that made me select some handful queries and patterns. Query to verify size of the databases schemas in MySQL SELECT […]