DBMetadata
Posted by: Michael Wall
A Java utility that lets you create XML Metadata of all your database tables as Informatica PowerCenter Source or Target.
Overview
Do you have hundreds of database tables that you need to import as Source or Target in Informatica PowerCenter? Do you find that process time consuming? Well, DBMetadata might be the solution you were looking for. DBMetadata is a Java utility that reads the metadata from table(s) in a specified database and creates the Informatica XML to import into the repository. This utility was created during migration to a new platform and there was a need for a quick way to create flat file / relational sources and targets that matched the DDL of the table. There was also a requirement to use shortcuts. If you use the import table list with DBMetadata, it will create one XML file with all of the tables and shortcuts (if a shortcut folder is specified) for the requested output type and database/file type.
Features
Bulk creation of Informatica sources and targets using import file.Ability to create shortcuts at creation. Platform independent.Import from JDBC databases and ODBC.- Java Version: JRE 1.6
- Informatica Version: PowerCenter 9.x
Resources
- User Guide
