We have setup CRM Analytics against Zoho CRM and also imported data from an onsite DB to a DB in Zoho Reports.

From what I understand you cannot link DB's in a query so we will need to move data from one DB to another so we can link them. Could some one please confirm this is correct.

Is there a way to automate this, either moving data from ZCRM DB to the Imported DB or vice versa?

This link between DB's is a big limitation especially if you cannot automate moving data between DB's, I can see its on a todo list but is there a timescale.

Thanks

Gordon