We have connected to the oracle database for extracting the source file directly using the JDBC connection node.
But we also want to have an alternate option of adding the source file manually using the excel node, in case the connection fails to the database due to some reason.
We tried using Switch node for alternating between the source files but it did not work out, since switch node always requires input from the 1st node.
We used transform node method using Run time properties in which user can select DB or manual source file option but it is still not giving the option of alternating.
Kindly check the attached file below and any help will be great.
Please sign in to leave a comment.