Demo scenario - a salesman is planning to visit a number of customers. Using IBM Mashup Center, he built a sample application that
- Pull the customer info from his enterprise data source
- Pull the contact info from his personal data
- Merge and transform these data source
- And present the result in an interactive application
1.0. Create feeds
1.1. Relational feed
This URL (
https://greenhouse.lotus.com/home/content/mashupsfeedinstructions.jsp) provides the instructions to create a DB2 feed. Greenhouse hosted sample relational data sources (DB2 and IDS) to make possible for its users to create relational feeds.
The customer info used in this demo scenario is located in the "custinfo" table. For the demo purpose, select this table and the subset of columns (custno, custname, zip, ticker, website). You can play around of selecting additional info if you want to extend this demo scenario (address, email, ...).
Click on Preview to preview the selected data. This is an useful feature when one discovers the data source for the first time.
1.2. CSV feed
Below is the content of the CSV feed used in this demo scenario.
Custno,Contact,Email,phone
1000,Kent E. Price,kent@aig.com,212-123-456
1010,Miguel M. Garvin,miguel@metlif.com,212-567-8910
1020,Edward A. Bottoms,edward@capitalone.com,770-345-6789
1030,William M. Aston,william@ford.com,502-789-1234
1040,Janis H. Morehouse,janis@dell.com,767-456-7890
1050,Sharon E. Kohler,sharon@cisco.com,408-098-7654
You can copy this content into a text file and create a CSV feed. You need to specify the header row and the default delimiter is already the character coma.
2.0. Create data mashup
The data mashup is composed with 4 operators: 2 source, a merge and a transform operators.
- The 2 source operators are to pull the data from the created feeds.
- The merge operator is to merge them together using the common value "custno".
- The transform operator is to "cleanup" the output feed and to be able to publish it as ATOM feed.
3.0. Presentation mashup
3.1. Display the feed
The created feed mashup can be displayed using the Data Viewer widget. From the feed catalog, one can "Add to Lotus Mashups" in the category "Demo".
3.2. Sample application
To create the sample application, we start with an empty page named "Traveling Salesman". Then we populate it with 3 widgets:
- The Traveling Salesman Demo widget from the Demo category.
- The AccuWeather widget also from the Demo category.
- The Web Site Displayer from the Tools category.
We then wire
- The Traveling Salesman Demo widget to the AccuWeather widget to send the ZipCode and to display the weather at this given location.
- The Traveling Salesman Demo widget to the Web Site Displayer widget to send the website URL and to display the given web page.
This wiring process creates the interactive application and completes the demo scenario. You can click on "Save" icon to save the page. When the salesman selects by clicking on a given customer, both Accu Weather and Web Site Displayer widgets will displayed the info associated with this customer: the weather and the Home page.
