topic Re: automatic Mapping between tmysqlinput and tmysqloutput in Talend Studio

automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Tue, 25 Apr 2017 11:12:29 GMT

hello evrybody

i have a TmysqlInput which setting is fixed by context variables

and i have a tmysqloutput and tmp

i'm seeking for a way (if it's possible)to do the mapping between tmysqlinput and tmysqloutput without opning the tmap and doing the classic mapping

pelease help

Re: automatic Mapping between tmysqlinput and tmysqloutput

Sid3 — Tue, 25 Apr 2017 11:20:39 GMT

hi Hamaz,

are your both input and output tables schema are same?

If yes. you can directly map you don't need a Tmap here if the schema and database type is same.

you can verify the schema in target component schema. you find a edit schema there you can see your input and output schema gets displayed.

Thanks,
Sid
Please give a Kuto to the post if it is useful
Please put to resolved if it solves your issue.

Re: automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Tue, 25 Apr 2017 11:24:21 GMT

No the databese is the same but i want to store in different table

Re: automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Tue, 25 Apr 2017 11:27:13 GMT

also i want to specify which coloums to be mapped , in an automatic way

Re: automatic Mapping between tmysqlinput and tmysqloutput

Sid3 — Tue, 25 Apr 2017 11:32:24 GMT

If it is schema is different you have to use Tmap for mappings columns.

It cannot be done in automatic way, if you dont want to use tmap use tJavarow between source and target and you can reassign the fields as per your requirement.

But i suggest use tmap easy to manage your code.

Thanks,
Sid
Please give a Kudo to the post if it is useful
Please put to resolved if it solves your issue.

Re: automatic Mapping between tmysqlinput and tmysqloutput

TRF — Tue, 25 Apr 2017 11:39:17 GMT

But if you need a tMap automagically completed because of the number of fields, I'm afraid it's not possible to do what you expect.

Re: automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Tue, 25 Apr 2017 11:46:49 GMT

if there is way without tmap then it will be fine too

Re: automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Tue, 25 Apr 2017 11:49:06 GMT

how can i do the mapping with javacode using tjavarow

Re: automatic Mapping between tmysqlinput and tmysqloutput

Sid3 — Tue, 25 Apr 2017 13:11:36 GMT

You can connect tmysqlinput--->tjavarow--->tmysqloutput

In tjavaRow, Get source schema from input component and target schema from output component. Then click on "Generate Code" property in tJavaRow component, once it generates the default code with output fields gets assigned to input fields. you can change the field assignment as per your field mapping.

Note: Don't click on "Sync Columns" property in tJavarow. get schema from source and targets as per the above statement.

Thanks,
Sid
Please give a Kudo to the post if it is useful
Please put to resolved if it solves your issue.

Re: automatic Mapping between tmysqlinput and tmysqloutput

TRF — Tue, 25 Apr 2017 13:16:38 GMT

@Hamzahaj can you explain why you don't want to open the tMap configurator?

Re: automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Tue, 25 Apr 2017 14:06:59 GMT

Hello Sid4U

i tried that

and it work only when i precise the shema both on the input and the output

the probleme is i want to find a way to generate shema and field manually by javacode because i want to make my job as an api that

can be connected to any external database with an unkonwn structure and then i store the date in my own database

Re: automatic Mapping between tmysqlinput and tmysqloutput

TRF — Tue, 25 Apr 2017 14:13:28 GMT

Dynamic schema is a functionality provided by subscription version

Re: automatic Mapping between tmysqlinput and tmysqloutput

Anonymous — Wed, 26 Apr 2017 09:12:29 GMT

Hello TRF

i have just downloaded the subscription version of talend Data Integration and I have a free licence for 30 day

would you mind giving me a way to generate the schema dynamically please

thank you very much