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.
Question
Unified connection string
+12- Supporter
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!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.