Need help in iterating the db connection from a excel and load each in the tdbinput component
Hello
I had a excel file which has Db details like hostname, dbname, port, schema, username. This file will have around 200 account details. There will be another file which has commands for getting the password for each account.
Here we need to read each row from db details file and load the details of db in tdbinput component. The password will be getting from tssh component where we need to fetch the command from the command file and load the fetched password in the db component and test the connection.
We need to iterate this process for all the accounts. There will also be type of db in the input db details file. If it greenplum db it should connect to respective db component, if it is oracle then it should connect to oracle db component and test the connection. If any account fails then that dbname, username details should be saved in excel and send that excel through email in the last after testing all the accounts.
