topic Re: Show user define column in tMAP before saving data. in Talend Studio

Show user define column in tMAP before saving data.

Anonymous — Tue, 08 Aug 2017 07:09:55 GMT

I am working on a user case where customer wanted to view the user define field names with some metadata about those columns instead of actual database column while mapping data from source to target. Basically, its about how to add one level abstraction to real time DB columns.

Thanks in advance.

Abhishek Dabas

Re: Show user define column in tMAP before saving data.

vapukov — Tue, 08 Aug 2017 07:50:53 GMT

not very clean what You try to achieve, but if I understand correct:

it possible for Input components

define schema as You need (want)

- col1 INT
- col2 VARCHAR(25)

than use this schema in tDBInput use query like:

SELECT realcol1 as col1, CONCAT(realcol2,'_', realcol2) as col2 FROM realtable

but for output components, You still must use real schemas

Re: Show user define column in tMAP before saving data.

Anonymous — Tue, 08 Aug 2017 10:44:44 GMT

Hi Vapukov,

Thanks for the reply.

My problem is not in the input side. I Don't won't to show exact DB columns to end user on the output while mapping data in tMAP. Is it possible to show custom column to user in the tMAP and while running the job data will be saved to the exact columns.

Hope this will clear my use case a bit.

Regards

Abhishek

Re: Show user define column in tMAP before saving data.

vapukov — Tue, 08 Aug 2017 10:51:04 GMT

Think, You are looking in wrong direction

if You do not want to show real structure - look for ESB and SOAP or REST API services

in this case You provide API documentation and interface

other traditional way, use CRUD stored procedures - and call them after transformation, but this could kill performance

and the last - normally End User do not work with tMap, he just provide source data for Job and receive result, if it Your client - in 99,99% it could request open source code of any You hidden transformation