Site Description | ||
Mark Heid
| Mashing up Cognos DataNicole Carrier December 8 2009 12:23:31 PMThe Cognos team has put together a powerful demo showing how to mashup business intelligence information from Cognos with CRM data and other information coming from external sources. I liked the demo so much that I decided to post it to my channel on youtube! You can also see the video below:
Mash on
--nicole
Mashing up Google Spreadsheets with IBM Mashup CenterNicole Carrier December 4 2009 09:39:42 AMRecently, I have had several inquiries as to how one could 'mashup' information that is sitting in the cloud in a Google spreadsheet. Thanks to a little help from a colleague (thanks, Bill Y!) I was able quickly turn a Google spreadsheet into an RSS or ATOM feed, CVS file, embeddable HTML, etc. From there, making a mashup was a piece of cake!For those of you interested in how to do this, I created a very short video and posted it to youtube. You can also watch the video embedded below. Every so often, folks tell me that the embedded video doesn't work. If it doesn't work for you, just go directly to Youtube
One thing I mention in the video, but don't go into detail about, is the format of the Google Atom Feed. What I expected to see what an element name for each column in the spreadsheet. Instead, what google produces for each row in the spreadsheet are only two elements that contain the data. The first is an element called title, which contains the data in the first column. The second element is called content, and it contains the rest of the information in the remaining columns. To give an example, my spreadsheet has columns in it called Customer Name, Address, Zip, Ticker, URL. The first row of data in my spreadsheet has data in it like follows: IBM, New Orchard Rd Armonk New York, 10504, IBM, http://www.ibm.com. When the ATOM feed is generated from Google for this spreadsheet, the data comes out in the following manner: Title = IBM, Content = address: New Orchard Rd Armonk, New York, zip: 10504, ticker: IBM, url: http://www.ibm.com. If we wanted to use this ATOM feed in a real mashup, we would need to figure out (through a data mashup + Reg Expressions likely), how to parse out the data from the element names. Not so easy for a non-programmer. As shown in the video, the answer is to use the CSV option instead. Google lets you check off an option that if the data changes, it will be automatically republished. This is cool in that the data in the spreadsheet can change, and it can ripple through to your mashup - without any manual intervention. Mash on
--nicole
@ The Web 2.0. ExpoNicole Carrier November 18 2009 11:23:32 AMI just presented at the Web 2.0 Expo about mashups - what they are, why you should care, what customers are doing with mashups today, and, of course, an intro to IBM Mashup Center. For those of you that missed it, here are my slides. I also used the cool slideshare feature to embed the gov't mashup demos from youtube I recorded the other day.
Mashup Center preso @ Web 2.0 Expo
View more presentations from ncarrier. Mash on
--nicole
What’s New in Mashup Center v2Nicole Carrier November 13 2009 07:24:47 AMMark posted a few weeks back that we have announced Mashup Center v2 at IOD. We are going to be shipping the final code here in about one week. Yea! For those of you interested in more specifics on what is new in the product, I've posted my 'what's new' pitch to slideshare:
I am pretty excited about this release. We've made huge strides in usability and simplifying and speeding the process of creating applications from disparate data sources. We've also continued to expand the breadth and depth of sources we can consume with additional out-of-the-box connectors. Finally, we have enhanced our security and governance capabilities by adding in capabilities like secure mashups (e.g., sandboxing of untrusted widgets), malicious content filtering, dependency tracking, and better usage and policy reports. Mash on
--nicole Government Mashups!Nicole Carrier November 11 2009 02:41:03 PMOver the past year or so, we have seen a growing interest in Mashup Center from federal, state, and local governments – especially in the US and Europe. While I can pontificate for quite awhile on the various benefits of enterprise mashups for government, I will control myself :-) and focus on one specific use case only.The use case is one that I initially captured in a blog a few months back about one of our customers – Kent County Council- and their Pic and Mix project. Essentially, the scenario is that those within the government sector are making more and more public records available to constituents and other interested parties, with the driving force being to foster a more transparent and more responsive government. To that end, I created a demo (in three parts) all about government and citizen mashups. I posted these on youtube (in HD!) In the first part of this demo, I start by walking few a couple of examples of mashups that would be interesting to citizens. Next, I show how both governments and citizens could take advantage of Mashup tooling like IBM Mashup Center to create and catalog information feeds for use by citizens or by other government agencies. In part two of this demo, I show how these feeds can then be assembled into useful new mashups by leveraging IBM Mashup Center’s easy-to-use code-free Mashup Builder tool. I also show how the new mashup page can be embedded into any website- like a blog, and how the feeds can be consumed by other clients, like Lotus Notes. In part 3 of this demo, I show how to create a custom widget using our Portlet Factory / Widget Factory tooling. The widget will take in a zip code and return the legislators for that area. The widget is built using a rest service provided by the Sunlight Foundation. Here is a screenshot of one of the pages from the demo- showing info about a selected legislator. The feeds are coming from twitter, sunlight foundation, and opensecrets.org. In part 3 of the demo, I will create (using Widget Factory) the widget on the top row, next to the zip code search. The other widget created with Widget Factory is the one showing Top Contributors for the selected rep. The other widgets on the page come out-of-the-box with Mashup Center version 2. Enablement Webcast for IBM Business Partners - Nov 13th @ 10:00am PDTMark Heid November 6 2009 09:45:19 AMFor almost a year, now, we've been embedding Mashup Center in our FileNet P8 platform - an IBM offering in the Enterprise Content Management market. We believe strongly that this is a key point of "synergy" and our success with customers over the past three quarters has supported that expectation. A number of key partners have engaged already and with the following webcast we're looking to expand our partnership "portfolio". We hope you can join! ____________________________________________________________________________ Enablement webcast for IBM Business Partners Use Structured /Unstructured data & Agile ECM To deliver advanced case management solutions This is your last chance, this year, to get trained on how to leverage ERP, Cloud and Applications data in your Agile ECM and other applications by using the new Data Mashup Builder capabilities in IBM FileNet P8 4.5.1. Learn how to deliver case management applications in record time and how existing capabilities can be easily extended by easily unlocking and bringing in rest of your Enterprise Information as well as external data. A customer case study will be presented. The IBM Information Management CTO's team who built the capabilities will deliver the enablement. Date and Time: Nov 13th, 10:00 AM PST For enrollment, please send an email to: Tom Deutsch, IBM CTO Office tdeutsch@us.ibm.com _______________________________________________________________________________________ Comments Disabled Introducing IBM Mashup Center v2.0!Mark Heid October 28 2009 12:12:12 AMWe're very excited to announce that on October 27th we launched version 2 of IBM Mashup Center! We're at the Information on Demand Global Conference in Las Vegas and the reception has been very positive. We gave a pre-brief to a number of bloggers and saw some great posts from - Fred Sobotka, Todd "Turbo" Watson, Alex Williams and Adam Gartenberg, among others.Our press release highlighted the top new capabilities (below), along with customer references from Kent County (UK), Wells Fargo and AMEC Paragon. We focused, in part, on synergy with analytics capabilities provided by the new IBM Cognos 8 Mashup Service. This web services-based reporting capability adds a whole new dimension to IBM Mashup Center's value-add. This new release is a significant step forward on several fronts:
You can find out more at our website. Comments Disabled Lotus Knows MashupsNicole Carrier September 28 2009 09:04:27 AMLast week we launched the Lotus Knows campaign. For those of you unfamiliar with this campaign, it is essentially a marketing effort focused on getting the word out about Lotus, and what we excel at. Many people that I've run into still associated Lotus with email (Notes/Domino) or with spreadsheets (e.g., Lotus 1-2-3, which was at its prime back in the '80s). This is a shame. We have great products, many of which are on the cutting edge like Lotus Connections and Mashup Center (of course :).If you have a few minutes, and you want to put a smile on your face, go to http://www-01.ibm.com/software/lotus/lotusknows/, click on Mashup Apps on the bottom of the page, and watch the video submitted by Dov Zmood that describes how Lotus Knows Mashups. I think it's pretty funny, and I think you will too! Lotus Knows how to make you smile. Comments Disabled OpenAjax Hub v2.0 is releasedNicole Carrier August 31 2009 02:16:39 PMJust a quick note to say that the OpenAjax Hub v2.0 was is now officially approved and available. What is new in Hub 2.0? The biggest capability is the support for secure mashups. With OpenAjax Hub, administrators or users can place untrusted widgets in a secure sandbox. In a sandbox, a rogue widget can't do dangerous things- like steal important internal company data or even bring down a server. It's pretty important technology. So much so, that we are rolling it into our Mashup Center 2.0 release, which is coming in just a few short months from now.Here are some links to the press release and related writeup from Paul Krill (InfoWorld)- Press release = http://www.reuters.com/article/pressRelease/idUS116147+31-Aug-2009+PRN20090831 Infoworld = http://www.networkworld.com/news/2009/083109-ajax-widget-security.html Comments Disabled IBM Mashup Center - You can now pay by the hourNicole Carrier August 12 2009 07:27:26 AMBack in April, I blogged about how we have Mashup Center v1.1 available on the Amazon cloud - free for development purposes. Well today we have passed another milestone, and I am pleased to announce that we now have "production ready" Amazon Machine Instances (AMIs) of Mashup Center available for purchase by the hour. Click here to learn more about Mashup Center on the Amazon cloud and the production-ready AMIs.I think (and hopefully you will agree with me) that the pricing is very reasonable. Starting at $1.98 per hour, you can use all the rich functions available in Mashup Center today. If you are interested in learning more about Mashup Center on Amazon, or about Mashup Center in general, please join me for a webinar on Tuesday, September 1st from 8am - 9 am PDT (11 am to 12pm EST). The abstract for this webinar is as follows: Learn how mashups can decrease your development time and reduce your application development backlog. This webinar will walk you through the process of creating your first mashup using IBM Mashup Center on AWS, including creating a new feed, transforming and remixing feeds, discovering widgets, wiring widgets together, and sharing mashups. Hope you can attend! Comments Disabled | |
