Archive for February, 2009

Introducing SnapLogic for Data Integration

The JumpBox Open collection continues to grow. Today we add the JumpBox for the SnapLogic Data Integration.

SnapLogic allows you to access and transform data from disparate sources and create data "pipelines" that can be chained together to perform useful tasks. Splice data from a spreadsheet on your desktop with records stored in a networked MySQL database and mash it all up with supplementary info via a public webservice on the Internet. Snaplogic is the "digital duct tape" that helps you quickly tackle integration projects.

Similar to the "Yahoo Pipes" system, SnapLogic gives you a visual environment for knitting together data feeds and manipulating data without writing code. Because pipelines are composed of modular components, new data sources can easily be "snapped in" to leverage existing logic. JumpBox for SnapLogic is a part of our JumpBox Open program and is available for download to JumpBox Open subscribers or can be trialed online using our Rapid Trial feature. To learn more about the SnapLogic software and community please visit snaplogic.com.

SnapLogic Ramp Up Video

To make it even easier to get started with SnapLogic we’ve put together a screencast tutorial that demonstrates the process of solving a data integration problem using SnapLogic. We’ll start with a fresh instance and walk through all the steps necessary to deliver a working application. In the exercise we show off some useful development techniques unique to virtualized environments and JumpBoxes and in the process create a solution to a problem that companies pay thousands of dollars per year to address. The challenge involves fighting crime and frozen bank accounts. Curious what it is? Watch the video to find out.

Updated JumpBoxes

Note: To stay truly up to date you can find out about new releases as they happen by following us on Twitter.

  The Application What’s Changed
Wordpress 1.1.10
Wordpress is one of the worlds most popular blog publishing applications. Create a blog and communicate directly with your audience online. Publish commentary, receive comments, share video and more with this blog publishing system.
Wordpress has been updated to Wordpress version 2.7.1. Notable changes:
Filters refactored to avoid XSS attacks
Revisions now respect timezone offset
Comment feeds are now valid RSS
View release notes
Trac 1.1.8
Trac is an advanced tool for tracking software development projects. It provides a simple wiki, issue tracking system and tight integration with the Subversion revision control system.
Trac has been updated to the 0.11.3 release. Notable changes:
Highlighting of search results is more robust
Unicode related fixes
Fixed Trac link rendering in ReST
View release notes
Cacti 1.1.4
Cacti is a complete network graphing solution designed to harness the power of RRDTool’s data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices.
Cacti has been updated to Cacti
version 0.8.7d. Notable changes:
Enhancements to SNMP cli version information on tech support page
Various bug fixes including LDAP-related issues, cross site scripting checking and deletion of large numbers of graphs and data sources.
View release notes
Dokuwiki 1.1.3
DokuWiki is a simple, clean and easy to use a Wiki system that allows collaborative editing of a web site. It’s focused on creating documentation for developer teams, workgroups and small companies.
Dokuwiki has been updated to the 2009.2.14 release. Notable changes:
Added Flash multi-uploader
Improved XMLRPC interface
Performance optimizations
Better support for non-default auth backends
View release notes
Redmine 1.1.4
Redmine is a project management and issue tracking system for software developers. Redmine provides many of the features in Trac plus support for multiple projects, role based access control, time tracking functionality, Gantt charts, a calendar view and user self-registration support.
Redmine has been updated to the 0.8.1 release. Notable changes:
Fixes to the Trac Importer
Various minor bug fixes
Various minor feature enhancements
View release notes
Mediawiki 1.1.8
MediaWiki is a Wiki application that allows you to write, edit, manage, store, and organize knowledge collaboratively. Create and edit content collaboratively, search and retrieve information effortlessly. The JumpBox for MediaWiki provides you with the world’s most popular wiki platform.
Mediawiki has been updated to the 1.13.4 release. Notable changes:
Fixes for numerous XSS security vulnerabilities
View release notes
Moinmoin 1.1.8
MoinMoin is an advanced, easy to use and extensible Wiki Engine with a large community of users. It’s written in Python and has a clean easy to understand user interface.
MoinMoin has been updated to the 1.8.2 release. Notable changes:
Ability to turn off IP address logging for more privacy
Fixes for XSS security vulnerabilities
Updated the FCK editor
View release notes
Zenoss 1.1.1
Zenoss enables network administrators to manage the configuration, health, and performance of networks, servers and network applications. Monitor your network availability, inventory, configuration, performance, and more with the Jumpbox for Zenoss.
Zenoss has been updated to the 2.3.2 release. Notable changes:
Now includes most core ZenPacks by default
Improved JMX monitoring and error reporting for Java applications
Improved monitoring of Windows servers
View release notes
Orange HRM 1.1.1
OrangeHRM helps small and mid-sized organizations simplify Human Resource Management (HRM). This modular HRM system automates HR processes, and harnesses the power of regular staff and HR officials to enable your organization’s success. Each module features the ability to automatically notify appropriate organization officials, and electronically allow review and approval of HR issues.
OrangeHRM has been updated to the 2.4.1 release. Notable changes:
Significant number of bugfixes
Significant improvements to the updater
View release notes

Ramp Up Video #3: Fighting Crime with SnapLogic

This title is only half-joking. Today’s Ramp Up video delves into how to use the Open Source SnapLogic data integration application to build a system that lets you screen the contacts from your CRM system against the SDN List for assistance with achieving OFAC compliance. In this video we’ll build a pipeline that:

  1. Consumes an XML feed of the data from the Federal SDN suspected criminal list
  2. Grabs contacts out of a SugarCRM instance running remotely on Amazon EC2
  3. Compares the contacts from the CRM system against the names on the list
  4. Presents the records that are potential matches
  5. Can have another system like Salesforce or Quickbooks easily “snapped in”

This tutorial is intended to give you the motivation and instruction you need to get started quickly with SnapLogic. This application is a powerful tool that can be used to mash up data from databases, spreadsheets, webservices, applications and many other different sources. In the next forty minutes we’ll use the JumpBox for SnapLogic and the JumpBox for SugarCRM to demonstrate the creation of this system from start to finish. You’ll learn the fundamentals of SnapLogic and pick up some development tips that are also applicable in other situations.

Below is the video, a time-coded table of contents, the widget to launch your own private instance and a zip file with all the assets used in the tutorial. Leave a comment below if you have questions about the tutorial or the JumpBox aspects. And for in-depth SnapLogic questions consider joining their extremely responsive mailing list found here.

Time Topic
02:50 Boot the Snaplogic JumpBox
04:44 Get snippet of SDN list and store locally
08:00 Make the XML reader resource for the local SDN list
12:49 Make the filter resource that returns the “Bad Guy” list of individuals
14:49 Make the pipeline that feeds SDN list data into filter
18:00 Boot SugarCRM JumpBox (use EC2 since RAM-constrained locally)
14:15 Using templates for adding similar items
20:45 Add sample contacts to Sugar
22:37 Demo snapshotting technique for dev before invasive maneuvers
23:08 Install the Sugar Connector and browse Contacts from within SL
29:41 Create the join resource between SDN feed and Sugar feed
34:44 Make the master pipeline that stitches it all together
37:32 Add a bad guy to Sugar and test system
38:41 Change XML input to point to SDN list, add more bad guys to Sugar and run it against the real list
Download a zip file of the following files used in the video here:

  • State of the SnapLogic JumpBox at the end of the tutorial
  • Sample contacts to be imported into SugarCRM
  • Snippet of SDN list for development
  • Command line syntax for installing the SugarCRM extension in SnapLogic
  • *Tip: To view video at full-resolution in hi-def, make sure the button is on and click the button to expand the screen.

    Introducing Unlimited Development

    Last week we introduced JumpBox Open Starter, a new, lower priced tier of JumpBox Open Subscription that starts at $149 per year. This plan is geared toward the individual and as you might expect, at the equivalent of less than $13 per month, it’s been quite popular. However, as we’ve looked at initial feedback it occurred to us we could make it even better.
    In fact we realized we could make all JumpBox Open plans better, so today we’re introducing unlimited development instances for all plans. Now you can deploy any number, of any combination, of any JumpBox for development and other non-production uses. This includes all current and future JumpBox releases.

    Our goal is simple, expose you to the best Open Source software around in a simple, ready to deploy format that becomes a no-brainer to use for production as well. Along with the development instances, each plan also includes an allocation of instances for production deployment and our goal is that you’ll want to use more and more JumpBoxes for production deployment and as your production needs increase, you’ll upgrade your subscription to allow additional production deployments.

    These new production deployment instances also introduce another much asked for capability, the ability to run more than one of the same JumpBox. So now if your plan allows five production instances you’re free to pick and choose what you want to run as those instances. Want to run 3 JumpBoxes for Wordpress, a JumpBox for MediaWiki and a JumpBox for Trac go right ahead, or maybe you just need 5 Drupal’s that’s OK too. Run five of the same, or all five different or any combination. It’s entirely up to you. Need more than five, just upgrade to the next level of subscription. Simple.

    You can also switch out those production instances at any time. So if you decide you want to switch from using Drupal to using Silverstripe for your web site. No problem, you pick what you want to run and can switch at any time.

    Every time you use a JumpBox you should be saving at least a couple hours of your time. Time that can be put to more productive work doing things that are hopefully more enjoyable than installing and managing Open Source software. That’s what we’re here for. If we can save you just five hours in the next year, JumpBox Open will have paid for itself.

    You can learn more about the new plans here.

    Ramp Up screencast

    How to run a JumpBox on VirtualBoxRamp Up

    Our series of screencasts to help you get started quickly with JumpBox applications continues. This episode of Ramp Up features VirtualBox, the popular Open Source virtualization product from Sun Microsystems. VirtualBox supports many host operating systems including Windows, Mac OS X, Linux, Solaris, and OpenSolaris. Though we don’t officially support it yet, VirtualBox can also manage a JumpBox. In less than six minutes, we’ll show you how it’s done.

    Updated Applications

    JumpBox for Wordpress
    Wordpress
    Wordpress is one of the worlds most popular blog publishing applications. You can easily publish online, receive comments, share video, and more with this blog publishing system.

    The JumpBox version for Wordpress has been updated from version 1.1.8 to version 1.1.9, the included application has not changed. This JumpBox update fixes a bug related to setting a static IP address.

    JumpBox for Redmine
    Redmine
    Redmine is an open source, web-based project management and bug-tracking tool. Redmine supports multiple projects and includes calendar and gantt charts to aid visual representation of projects and their deadlines.

    The JumpBox version for Redmine has been updated. This JumpBox update fixes a problem that prevented “svn cp” from working and adds some improvements as well. The JumpBox version number and the included application have not changed.

    JumpBox for OTRS
    OTRS
    OTRS is an issue tracking, or trouble ticket system that helps your Support, Sales, Help Desk, or other departments to track and assign tickets to incoming queries.

    The OTRS community has updated OTRS from version 2.33 to version 2.3.4. (OTRS release notes) This release includes new features including a Support Assessment module which allows you to check relevant installation and configuration settings and optimize your OTRS application. JumpBox version 1.1.6 (updated from 1.1.5) includes this OTRS update.

    JumpBox for Moodle
    Moodle
    Moodle is a course management system that allows educators to create engaging online learning communities.

    The Moodle community has updated Moodle from version 1.9.3 to version 1.9.4. (Moodle’s release notes) This release includes a number of new features such as options that allow Moodle to be configured to comply with European and US privacy regulations, an essay question randomizer, and the ability to allow students to see their previously completed coursework. The release also fixes bugs related to creating and editing course categories. JumpBox version 1.1.6 (updated from 1.1.5) includes this Moodle update.

    JumpBox for GLPI
    GLPI
    GLPI is an IT and Asset Management System that allows IT administrators to manage the maintenance, tracking, and servicing of IT inventory.

    The GLPI community has updated GLPI from version 0.71.3 to version 0.71.5. (GLPI’s release notes) This release includes a security update, and users are urged to upgrade. JumpBox version 1.1.1 (updated from 1.1.0) includes this GLPI update.