Chapter 15 MetaXML Scripting Interface - Teradata Meta Data Services

Teradata Meta Data Services Programmer Guide

Teradata Meta Data Services
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

This chapter describes the MetaXML scripting interface. The scripting interface provides a non-programmatic means for importing and updating meta data in the MDS repository.

The scripting interface uses the Extensible Markup Language (XML) as the method for putting structured data in a text file. The World Wide Web Consortium (W3C) considers XML to be the universal format for structured documents and data on the Web. The Meta Data Coalition has defined XML as the standard format for the interchange of meta data for the Meta Data Coalition Open Information Model.

This chapter contains the following information:

  • XML Overview
  • XML Example Files
  • Since release 13.00, this MetaXML utility supports the export of metamodels or meta data objects out of the repository.

    To export repository objects (using -ocoll or -mcoll parameters), a supported version of the Java JRE must be installed and have it’s JVM DLL path added to the user's PATH environment variable through the Control Panel.

    Supported Java Runtime Environments (JREs) are from Oracle: 1.5.0 update 6 or later and 1.6.0 update 3 or later, and from IBM (WebSphere/Eclipse): 1.5.0.

    The Oracle JVM DLL is located in JRE_HOME\bin\client and the IBM JVM DLL is in JRE_HOME\bin\j9vm. Any one of these three JREs can be used but the JVM DLL should come from the selected JRE_HOME of whichever one is being used.

    The export results in an XML file that is valid against the schema and DTD that the “import” uses. See “Scripting Interface Steps” on page 421 for more information.

    This utility uses the MSXML 4.0 SP2 or 6.0 parser. These parsers support Unicode and all the accompanying encodings. If you do not have this installed on your system, you will get an error trying to run metaxml. Download the MSXML 4.0 or 6.0 parser from the Microsoft download web site. It is not necessary to also install the SDK that comes with the download.