Download Latest Version dbmetadata.jar (142.5 kB)
Email in envelope

Get an email when there's a new version of Informatica DBMetadata

Home / Current Release
Name Modified Size InfoDownloads / Week
Parent folder
v1.1.2 2016-01-15
1 1 weekly downloads
V1.1.1 2015-05-19
0
v1.1 2014-09-18
0
v1 2013-02-01
0
README.txt 2016-01-15 2.3 kB
0
Totals: 5 Items   2.3 kB 1 
Description:
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. 
I created this utility when we were migrating to a new platform and needed a quick way to create flatfile and relational sources and targets that matched the DDL of the table. 
I also needed to use shortcuts. If you use the import table list, 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 creat shortcuts at creation
	- Platform independent.
	- Import from JDBC databases and ODBC

V1.1.2
	Enhancements:		
Added new entries in the DBmetadataOptions.ini file
			- Ability to overrride a prefix for shortcut. (It was a hard coded "Shortcut_to_") 
				1. SHORTCUT_PREFIX = Shortcut_to_
				
V1.1.1
	Bug Fixes:
		- Error during import if folder name has spaces.
V1.1
	Bug Fixes:
		- The "-d" parameter was not being displayed in help.
		- Added a -debug parameter.
		- Oracle NUMBER datatype that is not defined with a precision or scale in Oracle was interpreted as number(0,-127). Fixed to default to number(15,0) in Informatica.
		- A relational source table was not using the schema name for the group name in Informatica. Program now defaults to schema name unlese using Teradata/Netezza which it will 
		  the database name since there are no schema's.
		- Oracle connection string was not working correctly with service name databases. New option (-sid) to use either a SID connection or the default service connection for Oracle.
		- Oracle database class changed from a deprecated call to oracle.jdbc.OracleDriver
	
	Enhancements:		
		- Added new entries in the DBmetadataOptions.ini file
			- Ability to add a prefix and/or suffix to a source or target flat file. (example of entry for target suffix).
				1. Source File prefix name =
				2. Source File suffix name =
				3. Target File prefix name = ff_
				4. Target File suffix name =
			- Added option to include Target flatfile "FileName" port (YES/NO) 
				1. Add FileName Port = NO
V1.0
	Initial Release
Source: README.txt, updated 2016-01-15