Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

Properties File

Properties File

The user-defined data type properties file contains the list of user-defined data types and the parameters required to convert the data types to a format that the PowerCenter Integration Service can process.
The name of the properties file must use the following format:
DatabaseType
_UDT_Native_Conversions.properties
You can use a properties file to define conversion parameters for the following database types:
  • Oracle. The properties file must be named Oracle_UDT_Native_Conversions.properties.
  • Microsoft SQL Server. The properties file must be named Microsoft_SQL_Server_UDT_Native_Conversions.properties.
  • IBM DB2. The properties file must be named DB2_UDT_Native_Conversions.properties.
  • Sybase. The properties file must be named Sybase_UDT_Native_Conversions.properties.
The PowerCenter Integration Service looks for the properties files in the following folder:
<TDMInstallationDirectory>/utilities/mapgen/config
UDT functions for Oracle are available in TDM. To handle user-defined data types on other databases, you must write the functions.