Wouldn’t it be nice to be able to query multiple datasources within one query? This way we would have a Total Analysis tool for viewing all databases. Maybe merging from two or more predefined query’s (querying views form different datasources)
Maybe just an export directly into a (new) table of a “reporting” database, being able to automate this task, and then from the reporting database query and automate any report.
Maybe even an automated syncronisation process querying one database
updating and inserting the other database.
with these options Data Analysis would be a verry interesting tool, I would but it immediatly.
In the ER diagrammer relationships over multiple datasources would help to understand and create metadata of all the data in the data analists scope.
Also, this way whe have a nice interfacetool at hand.
So, when will it be ready? Ill buy it.
Marcel Message was edited by: firstname.lastname@example.org
Message was edited by: email@example.com