I have two(Product and ERP)databases that has some tables.
One is for ERP and one is for Product.
I am updating and saving data in both databases ERP and Product.
In a particular time, i am syncing those database to middleware same schema.
All goes well,But i want to show those ERP and Product In magento admin grid.
I created a particular module for that,but those tables in other databases and i have only one default instance in resource model which is defined in env.php
I want to show custom database tables in magento 2 admin grid.
Total I have three Database.
ERP.
Product.
Magento.
I tried to keep all tables in magento db but i am getting issue related to syncing.
So i want to keep that seprate.
My requirement is how to show admin grid collection of custom database in magento 2.