Currently ArcGIS Insights does not support cross-database joins and querying. So if you store your spatial data and non-spatial data in different DBMS then you could not establish a relationship between them and do analytics unless you move them to the supported way of format or storage type.