Type mapping

Talend ESB Studio User Guide

EnrichVersion
6.4
EnrichProdName
Talend ESB
task
Design and Development
EnrichPlatform
Talend Studio

You can set the parameters for type conversion in Talend Studio, from Java towards databases and vice versa.

Accessing mapping files

  1. On the toolbar of the Studio main window, click or click File > Edit Project Properties from the menu bar to open the [Project Settings] dialog box.

  2. In the tree view of the dialog box, expand General and select Metadata of Talend Type to open the relevant view.

    The Metadata Mapping File area lists the XML files that hold the conversion parameters for each database type used in Talend Studio.

    • You can import, export, or delete any of the conversion files by clicking Import, Export or Remove respectively.

    • You can modify any of the conversion files according to your needs by by selecting the file and clicking the Edit button to open the [Edit mapping file] dialog box and then modify the XML code directly in the open dialog box.

Frequently used attributes in dbType element

Using attributes in the conversion mappings, you can define the default values or behavior of the relevant schema columns. The table below describes the frequently used attributes in the dbType element.

Attribute

Description

ignoreLen

When set to true, the length that you set for newly added columns of the type in schema (by Edit schema) on components will be ignored.

ignorePre

When set true, the precision that you set for newly added columns of the type in schema (by Edit schema) on components will be ignored.

default

When set true, the type defined in this element will be the default type of newly added columns (by Edit schema) on components.

defaultLength

Sets the default length of newly added columns of the type (by Edit schema) on components.

defaultPrecision

Sets the default precision of newly added columns of the type (by Edit schema) on components.