Connect to a db with dynamic port

[FloBD]

Hello,

I want to create a connection to my DWH (sql server) the problem is that my TCP/IP adresses are on a "dynamic mode".

So one day, if i reload my SQL Server, talend could not be able to connect to my DWH anymore because il entered one specific port and this port is not the one used anymore.

Is there a solution where i could set a list of ports in the connexion/contextes ?

[Anonymous]

Hello,

If we understand your requirement very well, you can achieve this goal via tcontextload component.

Please refer to this online documentation about: TalendHelpCenter: Reading data from different MySQL databases using dynamically loaded connection pa...

Let us know if it is what you are you looking for.

Best regards

Sabrina