Site Description

New Excel Plug-In for Importing Feeds from IBM Mashup Center

Mark Heid  May 21 2009 12:53:25 PM
We just finished a plug-in for Microsoft Excel that let's you import your feeds from the Mashup Center catalog into any spreadsheet.  Once the data is in your spreadsheet, you can refresh it whenever you want.  Go here to get the new plug-in:  http://www.alphaworks.ibm.com/tech/imh4excel

This enables a "round trip" work-flow from spreadsheets to Mashup Center to spreadsheets.  

For example, a finance department could do quarterly roll-ups programmatically:
        1)  Analysts feed their spreadsheet-based work into Mashup Center's catalog.  
        2)  The Data Mashup Builder "crunches" the inputs into a svelte, "only what's needed" Quarterly Report Feed
         3)  The Quarterly Report Feed is used for real-time presentation from within the Mashup Builder environment.
        4)  The Quarterly Report Feed is exported to a master Quarterly Report spreadsheet for dissemination.

This model ensures fewer human errors from spreadsheet cut/paste errors, shorter cycle-time getting Quarterly Reporting completed, more insightful consumption of Quarterly Data.

Let us know if you have any questions!    

Mark


Special thanks to our jStart Emerging Technologies team for this new addition to IBM's Enterprise Mashup portfolio:  
         - John Feller is a Senior Software Engineering Manager with the IBM jStart Emerging Technologies development team in Research Triangle Park, NC, USA.
        - Vladimir Stemkovski is an IT Architect with the IBM Emerging Internet Technologies, Customer Innovation Team in Research Triangle Park, NC, USA.
        - Dzmitry Kazakevich, Software Developer for IBM in Minsk, Belarus.
Comments Disabled