[resolved] Connect multiple DB inputs to tmap component

[Anonymous]

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

[Anonymous]

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. 

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

Oh I see, thanks !

[Anonymous]

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

[Anonymous]

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

[manodwhb]

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