Datatypes

The technologies storing the formatted data allocate to each of them a type that defines their nature. For example: numerical, character, Date, etc

Some data server access drivers allow you to Reverse the datatypes automatically from the Technology window, using the Reverse button.

Definition

Property

Description

Code

Code used in Oracle Data Integrator to refer to this datatype. This code is unique for this technology. The code is stored in models and flows in order to refer to the datatype.

Name

Name of the datatype, as it appears in the graphic interface and the reports.

Reversed Code

Code returned by the driver and/or an SQL reverse query.

Create Table Syntax

The syntax used to create a column of this type. The tags %L (Length) and %P (Precision) can be used in this syntax.

Writable Datatype Syntax

This alternate syntax is used to create a column storing data for a non writable datatype. The tags %L (Length) and %P (Precision) can be used in this syntax.

If the type is writable then the Writable Datatype Syntax and Create Table Syntax should be the same.

Letter used for the icon

The letter used to represent the datatype (Graphic id code for this datatype).

Writable

Check this box if this datatype can be used in an INSERT or UPDATE command. This is not the case, for example, for datatypes which values are automatically set and cannot be modified such as IDENTITY columns.

Columns reversed with a datatype not writable are flagged read-only.

A datatype that is not writable should have an alternate Writable Datatype Syntax defined, to enable Oracle Data Integrator to create temporary tables storing data of this type.
 

Converted to

The Converted to tab allows you to specify for the other technologies, the datatype corresponding to the current type. This datatype will be used if Oracle Data Integrator needs to create a work table on another technology that is a reflection of a datastore in the current technology.

For example:

For the data flow of an Oracle instance towards an SQL Server instance, the language generation engine may require conversion in both directions (for example from Oracle to SQL Server and from SQL Server to Oracle).

Converted from

This tab shows, (read only), the other technologies' datatypes that correspond to the current datatype.