Supported and Unsupported Mappings between Data Types

Data Exchange supports mapping of a few and not all the data types of the Enterprise Database Server, RDMS, SQL Server, and Oracle database. When you map two data types it will result either in a successful mapping, an error, or a mapping with a few exceptions. The result of a mapping is indicated by the color of the connection arrows. This section gives you a list of the data types that:

Are supported and map successfully.
Might result in an error.
Map but with exceptions.

Note: For the mappings that are incompatible, Data Exchange provides you the option to either use the built-in functions (System Functions), or write your own functions (User-Defined Functions) to make a mapping supported. This option is available for all transformation types. For example, if you try to define a mapping from a source Enterprise Database Server Numeric data type to a target SQL Server Datetime data type, an error is displayed. To define such a mapping, you can use an existing system function or write your own user-defined function that can return a type of Datetime data type that is compatible with the target Datetime data type. In this case, you can use the ConvertToDateTime system function.

The following links provide more information about