I need to use a unified database connection string which contains primary and secondary/DR database. Secondary /DR database is an exact replica of primary database. When the primary database is down , it should automatically connect to secondary database. All my existing workspaces are configured considering a single database connection . With the change to include primary and secondary db connection, can you please suggest how I configure this FME with least number of changes since it has an impact on all the existing workspaces.
Page 1 / 1
Hi @kishorecakumar. I would suggest using feature readers. The first should hit the primary database. The second should hit the secondary database and be connected to the rejected port of the first. This way, if the first database connection succeeds, processing continues as normal. If it doesn't, the secondary database read will be triggered and continue to process as normal.
Hopefully this will meet your needs. If i've provided an answer that you're happy with, please mark it as 'Best Answer'. If I didn't, please let me know if I can help further. Thanks and take care!