Hello Arnaud,
I was able to resolve the issue after much refactoring and trial and error. It seems that I was partially following this document Plug multiple NoSQL databases - Documentation which is very outdated and misleading causing me more confusion. The forest admin community post here ISSUE: Plug multiple NoSQL databases was much more helpful in helping me resolve the issue. I request you to update or remove the article.
Thanks!
Tanish