I started a little time ago working with talend and im still getting used to so im sorry if this is a dumb question.
The problem is simple i think, i have a bunch of different MSSql databases with different ips but, with the same schema and tables.
I need to connect to each one of them, execute one select sentence (i already have it and works fine) and then retrieve the info it gets to an excel file.
I tried at first with more than 50 tMSSql inputs, and connections, was the easy way, and it stopped working with memory problems due to the high amount of components.
Then i changed it all to the actual model that is quite simple and efficient.
On the first excel input i have a list of all ips, passwords, and all the config parameters the component MSSqlinput use
Then the iterate component do his job and collect all the data and throws to the MSSql connection component
And here is the problem, i want it to ejecute the select if it can connect to the IP (wich is actually doing) or, if it cant connect, just throw the error and go to the next ip on the list.
Now when i execute it and one ip is not working it just stop the execution and leaves all the following ips without proccesing.
Anyone knows a workaround for this? i have been trying A LOT of other aproaches to this problem for more than a week and all ended up the same, when one ip is not working everything stops.
BTW, the java error when one ip is not working is the next, in case it is too usefull.
Exception in component tMSSqlConnection_1
java.sql.SQLException: Network error IOException: Connection refused: connect
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema