Retrieving data from backup DB when origional connection fails.
Hi all,
Below is requirement.
I am loading data from oracle db.but requirement is when connection string for DB 1 fails qikview can retrieve same table from DB2 with another connection string.
In general I think you need to check this within a if-loop if any error occured (you need to enable the ErrorMode) and then switch to the other db. Helpful could be not to execute the real sql-load at first and use any small and fast dummy-statement for an check. Problematic is when nothing happens - no response and no error - because then qlikview will wait and wait (maybe this could be adjust with some timeout-settings).
