Mapping file (.xml) in connection properties - parameters and content

gorotman — Thu, 05 May 2016 11:38:09 GMT

Hi all,
there is a guide or some information about parameters/structure for db mapping file?
I refer to xml files used to translate dbtype <-> talend type (see in "metadata -> Connection" and create generic jdbc connection, or in "Preferences -> Talend -> Specific settings -> Metadata for talend").
After jdbc-odbc bridge was depreacated, I'm migrating Lotus notes ODBC to JDBC (domsql).
This strange jdbc is based on sqllite, but all columns retrieved are varchar 2000000000 long.
It's possible to set a fixed value like defaultLength?
I trie to use mapping_MSSQL.xml but column length remain 2000000000.
thanks
bye

Re: Mapping file (.xml) in connection properties - parameters and content

Anonymous — Thu, 12 May 2016 08:53:56 GMT

Hi
The mapping file is for specific database, it will not take effect if you create a general JDBC connection. You need to modify manually the data type and length after the schema is retrieved
Regards
Shong

topic Re: Mapping file (.xml) in connection properties - parameters and content in Talend Studio

Mapping file (.xml) in connection properties - parameters and content

Re: Mapping file (.xml) in connection properties - parameters and content