Real-Time Data Integration

  • about ernie ostic
  • NHL hockey…I still don’t like the shootout!
  • Table of Contents (for reasonably useful Postings!)
  • What’s this Blog about?

    ...thoughts and techniques concerning all things "real time" that revolve around Data Integration, with a focus on IBM Information Server, especially its features for Metadata Management, Web Services, Message Queues, XML, and related technologies.
  • Categories

  • other Pages

    • about ernie ostic
    • NHL hockey…I still don’t like the shootout!
      • Case in point — it’s not “that” painful.
    • Table of Contents (for reasonably useful Postings!)
  • Add to Technorati Favorites

Using DataStage to load new Terms into Business Glossary

November 30, 2008 — dsrealtime

There are a variety of ways to import new Terms into the InfoSphere Busines Glossary.  One of these, for initial loads, is to use an XML import.   The XML format is fairly easy to produce (a sample is provided with the Business Glossary and can be found at your Information Server Web Console)

The attached DataStage Server Job illustrates how to load new Terms and Attributes from some external structure.   In this example I use a simple sequential file, but if you look at the Job you will see that it can easily be adapted to any source, or simply write another Job to go from your source to a target that reflects the sample terms I’ve provided below. 

This was tested in 8.0, although has since been modified for use with 8.1.  I’m not sure how well it will import into 8.0.  The terms and attributes are very simplistic and use a hockey theme, just to keep things simple and allow for discussion.     The code is an example for instructional purposes only.   Please let me know if you have any questions or run into problems.

(I hope you can make use of these. Seems the blog has changed and won’t allow me to upload .txt files. I’ve tried putting all the content in “notes pages” of .ppt. You’ll need to download and then open the .ppt [one of only a few file types allowed here] and then see if you can cut and paste the sample .txt file, sample xml, and .dsx.).

Ernie

sample-terms-attributes

Posted in Business Glossary, bg, datastage, meta data, metadata. 1 Comment »
Blog at WordPress.com. • Theme: Garland by Steven Wittens and Stefan Nagtegaal.
  • please note

    ...the postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.
  • bloggers I look up to

    • Naquada
    • The Innovation Capitalist
    • Tooling around on the IBM Information Server
  • Data Integration

    • dsXchange
    • IBM DataStage Forum
    • Redbook on ISD/RTI/WISD
  • internet safety

    • KidSafeOnline
  • Recent posts

    • Business “vocabularies”
    • Cool new Widget for Business Glossary!
    • DataStage and DB2 pureXML
    • Data Lineage and Web Services
    • ETL vs EAI for Real Time …revisiting an old subject…
    • Facebook puts a new spin on “real-time”
    • Anyone else “fried” by Nulls?
    • Bowling has become “too” real-time
    • …another way to load Terms into InfoSphere Business Glossary
    • Using DataStage to load new Terms into Business Glossary
    • RSS for your Data Transformations!
    • Using Shortcuts with Information Services Director
    • DataStage and TIBCO….anyone done it?
    • Handling Nulls in XML Sources
    • Dealing with “primitive” XML
  • Top Posts

    • MQSeries...Ensuring Message Delivery from Queue to Target
    • DataStage and TIBCO....anyone done it?
    • ETL vs EAI for Real Time ...revisiting an old subject...
    • Using DataStage to load new Terms into Business Glossary
    • Data Quality and Transformation as a Service
    • Tips for Using Web Services Pack with DataStage: Part II - Invoking your first Service
    • Tips for using Web Services Pack with DataStage Part I: Getting Started
    • What is Real Time ETL anyway?
    • Incorporating Java classes into your DataStage Jobs
  • Archives

    • November 2009
    • September 2009
    • August 2009
    • June 2009
    • May 2009
    • April 2009
    • March 2009
    • February 2009
    • November 2008
    • September 2008
    • August 2008
    • June 2008
    • May 2008
    • April 2008
    • March 2008
    • December 2007
    • November 2007