MongoDB Web Clients

mongobrowsersA little background  - I have several ways available to access my development server (tablet, phone, laptop), so I prefer to use Web based tools for monitoring and interacting with the apps I have installed. This provides greater flexibility in that I don’t need to install separate client tools on each platform, and learn the myriad ways they have for configuring access to the server. For example, WebMin is a great tool for managing Linux boxes, and phpMyAdmin works well with MySQL. Since I have been working more on MongoDB lately, I decided to look into what is available to manage and interact with that application.

Here is a roundup of what I’ve tested, using the MongoDB website as a starting point, and restricting my testing to open source tools.

Continue reading

Pentaho Kettle and DB2 – Truncate (updated)

truncatediskUpdated to cover error on truncating empty table

Recently while working on a data transformation to move records on a regular basis from a PostgreSQL database system to a DB2 mainframe system, I ran across an interesting problem.  The scope of the project called for a complete refresh of each of the tables rather than just updating old records and inserting new ones, so I would need to clear each table out prior to writing the refreshed records. Normally I would use the Truncate Table option in the Table Output step to handle this, but  I found that it caused an error in the workflow. Apparently this problem is due to DB2 not supporting the Truncate SQL command.

Continue reading

Install MongoDB as a Service in CentOS 6.x

servicebellMongoDB provides a package for people to download and install on their system to try out the software, but you may want to install the software using their dedicated repository instead. Using the repository has a few advantages: MongoDB is configured as a service, so you can enable it to run when your system starts up if you like, and when newer versions of the software are released, you can update your installation via the YUM update functionality. Continue reading

Pentaho Kettle Time and Date Manipulations – Part 2

TransformWhen using an ETL tool, one requirement that you will likely run into over and over again will be dealing with dates. In part 1 of this series, I looked at using the GET SYSTEM INFO function in Pentaho which pulled various date and time values based on your current system values. The other step you can add to your Kettle transformations to work with Date and Time values is the Calculator step.

Calculator

To add the Calculator function to your ETL process, open the Transform folder in the Design tab, and drag the Calculator function onto the calculator. Double click to open it. This window is a little more complex than the Get System Info step, but not significantly, but that belies the depth of functionality it provides. Continue reading