Hi team, sorry, i might be posting in wrong thread as I just joined.
In CI4, I just want to know the possible way of connecting multiple databases and joining them dynamically.
Some possible structure as follow
db_main to join with
db_of_companyA
db_main to join with db_of_companyB
The idea is to have separated db set for each company to connect to
db_main as main dataset.
The DB credentials of each company are in a table in db_main
Thanks in advance.