topic Re: Change default type to double when guessing schema in Talend Studio

Change default type to double when guessing schema

Serphentelm — Fri, 15 Nov 2024 21:34:18 GMT

Hi,

is there a way to change the default automapping when guessing schema from SQLServer?

It automatically set numeric and decimal as BigDecimal, but I want to let talend setting them as double.

I've found that mappings are declared here "Talend\studio\configuration\org.eclipse.osgi\421\0\.cp\mappings",

and that every job has his own xml. I've tried to change the label numeric and decimal and setting id_Double as default type, but when I try guessing the schema, it still set the default type

as Bigdecimal.

Any suggestion?

Re: Change default type to double when guessing schema

Anonymous — Tue, 18 Jul 2023 09:18:44 GMT

Hi @matteo marchesi To change the default data type mapping, follow these steps (using a MySQL database as an example):

Click Project setting icon in the tools bar to open the Project setting window, then expand General > Metadata of TalendType. Open the mapping_Mysql.xml file.
Update the data type mapping and save the file.

Regards

Shong

Re: Change default type to double when guessing schema

Serphentelm — Wed, 19 Jul 2023 06:34:53 GMT

hi @Shicong Hong , when I try to open the article, it says that I don't have access to the page

Re: Change default type to double when guessing schema

Anonymous — Wed, 19 Jul 2023 06:43:14 GMT

@matteo marchesi sorry, I didn't notice that it is an internal article, I have edited my previous post, please follows the steps to change the default data type mapping.