In this 40 min Webcast you will get a quick primer on Reporting Using Microsoft Excel and Rational Asset Manager. Learn to:

1. How to create reports using Rational Asset Manager reporting URLs and a reporting tool like ( Crystal Reports, BIRT or in our case Microsoft Excel.)

2. How do I create the RAM report URLs.

3. Using Microsoft Excel as a way to import data using RAM web URLs and Web Queries in Excel.

4. Doing more sophisticated queries by joining RAM URL reports with other parameters like an asset activity downloads

5. Learn other ways to get data into Microsoft Excel, using data file import

6. Creating the report format in Microsoft Excel using pivot table to see who has done download activity on a set of assets.

7. Other things to consider.

To watch the tutorial you must first download and install the Raindance viewer to view the demonstration.

Then Download and open the Tutorial Webcast

Sample URLs used in the Tutorial

I have been getting lots of questions regarding what product integrations RAM v7.1 supports. Here is a screen shot that shows the integrations. We also have other services assets that provide integrations with Microsoft Excel and Lotus Notes to do batch asset loading of assets into RAM. The Subversion integration for versioning asset artifacts is provided by Clearvision. LDAP integrations include Microsoft Active Directory and Tivoli Directory Server. We include an embedded WebSphere application server with RAM, but also support Tomcat and clustered WebSphere Application servers.

Integrations in V7.1

Integrations in V7.1

Here is a list of the integrations:
Tivoli CCMDB
ClearCase base
ClearCase UCM
Subversion ( via Clearvision)
Rational Team Concert
WebSphere Business Modeler
WebSphere Integration Developer
WebSphere Business Monitor
Rational Software Architect
Rational Asset Analyzer
Ant integrations are possible to BuildForge
Microsoft Active Directory
WebSphere Application Server
Search Engine Plug-ins for Firefox and Microsoft Explorer

We are targeting having a maintenance release v7.1.0.1 for Rational Asset Manager v7.1 by the end of this month. The release primarily targets defect fixes and improvements to performance. Check the support and downloads site for it. Let us know what you like or don’t like about RAM v7.1 and what you would like to see more of.

We packed so much capability into the RAM v7.1 which is the latest release of the product that I wasn’t able to squeeze all of it into the 1 hour demo that you can download in today’s post.   This demonstration shows how you can create, manage and use both business intellectual assets and technical assets like SOA assets.

To watch the demo
you must first download and install the Raindance viewer to view the demonstration.

Then download the demo file takes about 10 mins to download and double click on it to launch the demo in the Randance viewer.

The demonstration is broken into several parts you can fast forward to the parts that you are more interested in.

Time Description
1min Search for Assets using the web client
6 min Assess Assets using the web client
13 min 50 sec Visual browse assets and users using the web client
17 min 56 sec Submit assets using the web client
22 min 20 sec That was cool but how do you setup this asset governance at the repository level? Learn how to setup asset types, reviews, policies and connections to other federated repositories.
35 min  38 sec How to use communities to collaborate on assets. Using the web client
40 min Learn how developers find and submit SOA assets like WSDLS and Service Implementations using our Eclipse Plugin Rich Client
50 min See how your SOA assets can be checked to see if they meet your WS-I policy.
54 min See how you publish service interfaces and policies to WSRR. And control who can see these service interfaces while they are in development.

Email me at carlos.ferreira at with suggestions about what assets you would like to manage with Rational Asset Manager and what future demos you would like to see.

What makes a good asset?

September 3, 2008

When people hear the word asset they often think physical assets. I surprisingly often get asked if RAM is primarily used to manage physical assets. While you could use RAM to do that, it isn’t RAM’s primary purpose. RAM’s primary purpose is to manage intellectual property assets related to the process of developing software. These assets are usually the work products from the software development process that you may need to reference or use again for a recurring business or technical need. So an asset could be as course grained as an application or the representation of the application server it is being deployed on. Or as fine grained as components, services, business processes, business rules, Eclipse Plugins, Open Source Jar files or any asset that you want to govern, search, reference or use.

Some good rules of thumb for choosing an asset

1. Is it something you think needs to be governed before others in the organization begin using it or having a dependency on it. Meaning you need role based access controls to the asset, review and approval and perhaps some reporting. Other examples of this include managing the definition and development of an asset across a supply chain. RAM can be used to broker assets between consumers and producers.

2. An asset is something that has some value and has a high likelyhood of being referenced or used for a recurring business or technical problem. Examples include a recent customer who has events that they monitor in their operations environment. They had application down event where their product application was unavailable for 3 days while they figured out how to get the application back up. To ensure that the problem didn’t happen again they wrote an best practice asset that described the process to get the application back up and running. Turns out the event happened again 2 years later but the person who wrote the document had retired. It took the company 1 day to get the system back up because they couldn’t find the asset. With RAM they could have found the asset immediately by searching on an asset with the event description and see all the related solution assets for it.

Some rules of thumb for level of granularity of an asset:

1. When parts of an asset change at different rates of change than the primary asset that the functionality resides in. For example. You may have a business application that doesn’t change that often by has a service which does change often. You would want the service to be it’s own asset with it’s own notification process.

2. Ownership. When parts of an asset are owned by more than one person and their needs to be clear lines of responsibility for funding business support and technical support.

3. Levels of review required. For example if there is a component that requires legal review you may want to separate it out from within the larger application. This simplifies the legal review process by making the asset reviewed 1 time by the lawyers and used many times by the product teams without requiring more review. Usually this implies different levels of review on different types of assets which RAM supports.

Example Assets We have built some very cool capabilities into RAM to allow you to govern all the types of assets I referenced above. I want to leave you with a couple of cool tips on how you can leverage some of the unique capabilities in RAM to manage both technical and business assets.

Eclipse Plugins

Did you know that you can manage your Eclipse Plugins with RAM? Here are the set of assets you would create and the URL you could use to update your Eclipse using a RAM asset. Thanks to Kevin Bauer on the team who documented this.

These steps show you how to create an asset which is the Eclipse Plugin Update site from an asset in RAM. This then allows you to govern Eclipse plugins, their dependencies and provision them right from with RAM.

1. Create plugin project asset, feature project asset and finally an eclipse update site project .

2. The URL to the Eclipse Update Site Project would likely look something like this. http://yourRAMServer:8080/{AB5D6836-3216-B7FE-9E1A-E96378B3A55C}&v=7.1.0

3. So through the web client the eclipse update site URL would look like… http://yourRAMServer/{AB5D6836-3216-B7FE-9E1A-E96378B3A55C}/7.1.0/ but this URL will not get past the RAM authentication. The update feature in eclipse only understands BASIC authentication. RAM’s web application use FORM based authentication, but our Web Service application uses BASIC authentication.

4. You need to get the web service context (you can find this URL on the extensions page of a RAM your RAM server) http://yourRAMServer:8080/ with a RAMSecure URL mapping for our secured access.

5. Create the correct URL for update site URL for this feature: http://yourRAMServer:8080/{AB5D6836-3216-B7FE-9E1A-E96378B3A55C}/7.1.0/ and eclipse will prompt you for the RAM userid and password when you try to use the update manager.

Training Videos, Podcasts and Webcasts Did you know you can manage your Knowledge assets with RAM. The Rich text description in RAM supports embedding video including Flash Content right within the Asset Description. You simply copy and paste the video by highlighting it on a web page and then pasting it into the asset description. Or for YouTube videos you copy and paste the object code that is on the YouTube video usually immediately to the right of the video. Here is a screen shot of our internal on boarding RAM v7 server that shows an example asset. Notice how it has been customized with the intranet themes and skins.

Embedding training videos, podcasts and webcasts in RAM Assets

Embedding training videos, podcasts and webcasts in RAM Assets