I'm creating a talend job for my company. This job will execute oracle sql scripts and generate custom outputs.
It will be called from command line, the name of the database will be an arguement in this command line.
There's a big number of databases in my company and this number and db definitions can change...
The solution that we considered is that the name of the database will be the same of tnsnames.ora file..
The problem is that I cannot find a way to connect to database in talend using tnsnames in runtime.. I can do it in design time (use TNS file...).
Could you please tell me if there's a workaround or a custom component that will do it?
Thanks willm for your answer.
Yes, I know I could read the file and parse it for the details, I was just hoping there is some easier solution to this. tOracleConnection component obviously can parse tns files (at design time), so I thought it would be somehow possible to use it for parsing tns files at runtime. Probably not. I will end up with parsing it by my own.