If the veterinarian's data is stored in a relational database instead of an Excel Spreadsheet, the feed can still be created. This lesson explains how to create the same Atom feed using a database query instead of the spreadsheet.
The instructions below assume that the veterinarian stores the data in an Apache Derby database called
clientdata in a table called
clientlist.
Important: The instructions below are hypothetical. They are included so you can see how to create a feed from a relational database query. The database table is not installed with MashupHub.
Estimated time to complete this lesson: 10 minutes
Instructions for creating the Derby database feed:
1. To create a feed select
New Feed under the
Create category, from the home tab of MashupHub.
2. Select
Relational Database Query (SQL) from the
enterprise section in the
Feed data source tab that appears. Click
Next.
3. From the
database connection window, the vet might enter these sample values:
- Select: New ...
This refers to the host and database name.
If the connection to this database has not been made previously, select New ....
Once a connection has been made, it is available in the drop down list by clicking the arrow to the right of the field.
- Type: Derby
The type of database server.
A value of Derby refers to a Derby Network Server environment. A value of Embedded Derby refers to a database being used by the embedded version of IBM WebSphere Application Server, V6.1, which is installed with Mashup Center.
- DB Name: clientdata
The database name where the client info is stored.
- Host: localhost
The host name where Derby is installed.
- Port: 1527
Enter the port the Derby network server listens on for connections. Derby uses port 1527 by default.
- Username: doctor
Enter the user name used to connect to Derby.
- Password: pa$$word
Enter the password of the above user name used to connect to Derby.
- Click Next.
4. From the
SQL query window select the following:
- Tables to query: Check the table DOCTOR.CLIENTLIST. The table name is pre-pended with the Schema name.
Once the table name has been selected, the right part of the window is populated with the columns to select in the query.
- Columns to include in the result set: Check the column DOCTOR.CLIENTLIST.*. This returns all of the columns and rows in the table.
- Scroll down and click Preview to see the results of the query.
- Click Next.
5. In the
Information window enter these values:
- Title: Veterinary Clients - SQL
- Description: Select from the DOCTOR.CLIENTLIST table
- Version: 1.1
- Tags: client list, derby, sql (optional)
- Permissions: Public
- Click Finish.
6. After the feed has been saved click
View feed to see the results.
If the database table contains the same information as the Excel worksheet used in Lesson 1, the output for the feed is the same.
Module 2: Summary
In Module 2 you learned how to create feeds from business data stored in an Excel worksheet or a Derby database. The feed created in this module is used in the next module as a source of data for the feed mashups.
Next Module:
Module 3: Creating Feed Mashups V1.0
MashupHub Tutorial - Table of Contents:
Welcome to MashupHub V1.0
Module 1: Introduction to MashupHub V1.0
Module 2: Creating Feeds V1.0
Module 3: Creating Feed Mashups V1.0
Module 4: Using MashupHub Objects in Lotus Mashups V1.0
Module 5: Additional Resources and Summary V1.0