Get MongoDB data with Pentaho Data Integration

kettlePentaho Data Integration (aka PDI or Kettle) is one of the most fully-featured tools for extracting data from a MongoDB environment. MongoDB stores information in documents instead of records, with data for a distinct subject instance stored in a single document where a traditional database might use multiple tables linked via primary and foreign keys and joins. This paradigm generally makes retrieval quicker since than with a comparable relational database system. If you are using PDI to connect to MongoDB, it will probably be the initial source or final destination for the data. For this article, I’ll cover how to use PDI to extract information from a MongoDB collection and save it to a text file. It could just as easily be passed onto another database, simple, or manipulated for other processing downstream.

I do make one assumption: You have a development MongoDB environment setup and running. Continue reading

Dell Inspiron 14 3451Dell Inspiron 3400 Linux laptop
– First Impressions

For years, many of us who wanted to run Linux on reasonably priced hardware had to buy systems with Windows already installed on it, and then wipe the system to put our chosen distro on it. While some manufacturers have offered systems with Linux, they tend to be higher end machines, with a matching higher end price tag. You also had the option to build your own system, but that was time consuming for a lot of us.

Earlier this year, Dell announced two laptop lines with a lower price tag, the Inspiron 14 inch 3400 Ubuntu Edition and Inspiron 15 inch 3500 Ubuntu Edition series. All of them come with a slightly modified Ubuntu 14.04 LTS operating system and with options for Intel Celeron or Pentium processors, 2 or 4 GB of RAM and a 500 GB hard drive. All of the systems are very affordable at $225-$350 dollars.

UPDATE: After some research, I found that the Pentium processor in the 14 inch model does support up to 8GB of RAM. I swapped out the 4GB stick with an 8GB one I had from a ZBOX machine, and I am happy to report that it functions fine with 8GB! 

With that information in hand, I ordered a 14 inch system with the Intel Pentium  N3540 processor and 4 GB of RAM and received it just before the Independence Day holiday. I’ve spent the last couple of weeks poking and prodding it, and putting it through its paces.

Continue reading

Run services (like MySQL) on demand with Ubuntu 15.04

stopstartThis is a followup to an article I wrote a couple of years ago where I covered how to start the MySQL server daemon on demand in Ubuntu. With version 15.04, the controller for services in Ubuntu has changed to systemd from upstart. Getting services to start when you want them is still fairly simple, though and I’ll illustrate the process by using MySQL as an example. Be careful when disabling services, because you could cause your system to become unstable if you disable the wrong one. For this tutoriaI I assume you have MySQL version 5.6 or higher installed and the server daemon starts up when you boot your system. Continue reading