topic Re: Adding UUID to the database table in Talend Studio

Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 08:13:29 GMT

I want to transform ms sql database table to postgres through a transformation.
In this transformation, I want to add a new column which contains uuid for the new row to be inserted.
As well as uuid should be generated from the table contents itself.
I can transform the table (without uuid) for now..but unable to generate uuid and map it to the postgres database table.
Can I map it through tMap??

Re: Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 08:50:29 GMT

Hi,

Due to there is no "uuid" in your target DB, you should add column of "uuid" first. ("Alter table tablename add Column name type varchar(100)") firstly.
Best regards
Sabrina

Re: Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 09:10:20 GMT

You can write a routine to generate your UUID and then just call it from tMap.
e.g.
...
import java.util.UUID;
...
public static String getUUID() {
return UUID.randomUUID().toString();
}
...

Re: Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 09:50:27 GMT

I added column for storing "uuid" in target table. And I have my own mechanism (breaking 1 column of same table into pieces and re arranging it) to generate through SELECT sql (using queries in repository).
What does that query returns as result set?? How to see that?
I am giving the output of the query to a tMap component. But the result of that query can not be read by tMap. How to resolve this issue?
tMap is forwardly connected to target DB (Postgres).

Re: Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 09:58:00 GMT

Hi,
Result set? Talend provide a component tParseRecordSet which parses a set of records from a database table or DB query and possibly returns single records.
Best regards
Sabrina

Re: Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 10:18:54 GMT

@sabrina : I wanted to know, how can I proccess that "uuid" which I have generated in select query. Because I can not see that column name in tMap component while mapping table fields

Re: Adding UUID to the database table

Anonymous — Tue, 16 Jul 2013 11:42:02 GMT

have you added it to the schema of your database input component? if you have, it should be available to tMap.

Re: Adding UUID to the database table

Anonymous — Thu, 18 Jul 2013 09:22:30 GMT

@talendByExample : yup. I did that. Still its not working. Do you have any other solution??