I try to understand how can I create a module where I need access data came from another.
Suppose to have a CRM module and E-Comm module. In CRM I create / admin customer on E-Com need to access to that data.
My question is realated to:
- if module CRM work with MSSQL and E-Com with MongoDb is it possibile?
- in terms of performance I need to use a SQL Statement if have more module on same DB arch I can exceute that query but if not on same DB, exist a way to sync data from different module?
- in case of use MongoDb can I use dynamic object to map object db?