topic Re: [resolved] Connect multiple DB inputs to tmap component in Talend Studio

[resolved] Connect multiple DB inputs to tmap component

Anonymous — Thu, 21 May 2015 08:57:20 GMT

Hi,
I currently have two databases (one on oracle and one on a mssql server), and I want to connect two inputs (one table from each DB) to a tmap component, but for some reason I can only connect one... (I have already seen the tutorial for tmap, did I miss something ?)
Here is a screenshot of my job :

I want to connect both inputs to the tmap, is there a way to do so ?
Thanks in advance for your time !
Thomas

Re: [resolved] Connect multiple DB inputs to tmap component

Anonymous — Thu, 21 May 2015 09:06:57 GMT

A tMap has a concept of a "main" data input and "lookup" inputs. You need to decide which is your "main" input and disconnect the "lookup" from its "OnSubJobOK". Then connect the tMap to the "main" input first. Afterwards connect up the "lookup" input.

Re: [resolved] Connect multiple DB inputs to tmap component

Anonymous — Thu, 21 May 2015 09:11:25 GMT

I see.. It's working now, but only because I deleted both connection components, so I can't use an "existing connection" to my inputs now, I have to write manually the connection data..
I can indeed keep both connection components, but if it is not linked to something, I may have a nullpointerexception when I'd launch the executable generated from the job. But since I only have 2 inputs it's ok..
Anyway, thank you very much for the help, I'll set this topic as resolved.
Thomas

Re: [resolved] Connect multiple DB inputs to tmap component

Anonymous — Thu, 21 May 2015 09:25:44 GMT

You can use more than one connection component. It is to do with how you have them linked using the "OnSubJobOK" links. In your job, you should have your components connected as below ....
ConnectionSMI --OnSubJobOK--> ConnectionOracle --OnSubJobOK-->HISTOTOX--row-->tMap <--row---ALIZES

Re: [resolved] Connect multiple DB inputs to tmap component

Anonymous — Thu, 21 May 2015 10:01:43 GMT

Oh I see, thanks !

Re: [resolved] Connect multiple DB inputs to tmap component

Anonymous — Fri, 03 Mar 2017 00:36:52 GMT

Hi,
I have the same issue, but the difference is, I need a subjob ok to prevent the connection kicking before the context variables loads. As a result, the connection is trying to connect before the context variables load. Any help would be appreciated.
Thanks
David

Re: [resolved] Connect multiple DB inputs to tmap component

Anonymous — Mon, 13 Apr 2020 03:54:50 GMT

I am having the same problem you have. I have read the same direction but still have trouble connecting multiple DB inputs with the tmap component.
Connect with mobdroportugal

Re: [resolved] Connect multiple DB inputs to tmap component

manodwhb — Mon, 13 Apr 2020 04:07:08 GMT

Since orgin is one so which you cannot connect,since you need to use thashputput and thasinput component to over come this issue.