Manually Creating Shared Tables and Data Files

There are lots of ways to import Shared Tables from other tools and other kinds of metadata — but sometimes it’s helpful to just “do it yourself.” You may havehome-grown spreadsheets or documents that contain your column metadata, or simply don’t have immediate access to the COBOL FDs, XSDs, ERwin (or other popular modeling tools) models, or other standard forms of metadata that contain critical table and column information.

See this link for more information on Shared Tables and Data Files… What are Shared Table Definitions?

[Note: 9.1 Update — in 9.1 this utility is now formally part of istool. It is called istool workbench generate ]

A new utility (courtesy of our creative engineers) has been built that supports the manual creation of Shared Tables and Data Files within the repository. This provides new flexibility for dynamically, and programmatically creating these structures for data lineage and impact analysis purposes. The utilty takes advantage of the istool archive format and syntax. Attached to this posting are three files…the documentation, a .jar file to be copied to your istool directory structure, and a sample import .csv with a variety of Shared Tables and Data Files. It will work with istool in both the Server and Client side environments. Please see the documentation for further details…

Notes!

1) After download, remove the .jpg suffix for the .jar and .csv files !!!! (the suffix is there just to satisfy this blog’s restrictions)
2) I noticed that the .jar file had its dots (.) changed to dashes (-). Leave the underscore, but rename the file so that each dash becomes a dot. The actual jar file you copy into your subdirectory should be: com.ibm.istools.cli.generate_1.0.0.jar
3) USE/READ THE DOCUMENT. It illustrates the detailed syntax that you need.
4) I noticed on linux that a ‘/’ was appended to the .isx file. I renamed the file before doing the “import” step. It worked fine. It seems to work fine “as is” on Windows.

Documentation
jar file [remove “.jpg” after download]
Sample .csv file with detailed table metadata [remove “.jpg” after download]

Advertisements

7 Responses to “Manually Creating Shared Tables and Data Files”

  1. Peter Mah Says:

    Is there a way I can customise what information to import. For example, I would like to import more informtion into the long description field at the table attribute level.

    Cheers,

    Peter Mah

    • dsrealtime Says:

      Hi Peter. Thanks for the question. I’ve asked engineering to support additional properties….I’d like to manually load a variety of things in addition to the short and long descriptions.

      If it’s useful for you, I was told that a “Description” in the incoming file that is over 250 bytes will “spill” over to the Long Description. I haven’t tried it, but that may offer some creative possibilities.

      On a separate note, I’ve been seeing more and more scenarios where I leave the Short and Long Descriptions blank —- because the definitions they hold are better placed inside of Business Glossary, and then used to define “multiple” columns. In that case, I only want to maintain the definition in one place, but have multiple columns across tables be “assigned assets” to that one single Business Term. Perhaps I have ACCT_NO and ACCT_ID and ACCOUNT_ID in multiple tables, each identified by the Business Term “Account Identifier”. I leave the Description of each individual column blank unless I need something that is “instance” specific for one of them (perhaps ACCT_NO in the example above is “Legacy account number in the Oracle QLINE system used prior to the QRC acquisition.” )

      Ernie

  2. Ray Says:

    Is the “Documentation” link dead? All I get when I download it is a Word document containing “The content of this file is dangerous”. Was that you, or McAfee?

    • dsrealtime Says:

      Yeah. It appears to be. Not sure what happened there.

      In any case, since 9.1 this capability is production and you should be able to find the syntax for istool workbench generate in the regular doc.

  3. Ade Says:

    It appears I would like to get some info about sending JMS Messages to TibCO from DataStage. I recently read that there are script to download but I did not see any. I also wanted to register on DSXchange but have tried several times without any email of acceptance. Can somebody help out


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: