This is a copy of the request in IZ: https://issues.apache.org/ooo/show_bug.cgi?id=42464 One feature that is lacking in DB support is to access data in more than one external database. A user might want to access both an Sqlite and MySQL database at the same time and consolidate their data for evaluation in Base. Please kindly consider this RFE to make Base even more of a professional product.
How should this work: Two databases of different engines in one view? How do you think a query could be created? How should Base create queries with any function? Example: When you concatenate three fields you could get this with hsqld with the following code: 1)"field1"||"field2"||"field3" 2)"field1"+"field2"+"field3" 3)CONCAT(CONCAT("field1","field2"),"field3") ... and now try with MySQL. Concat in MySQL works with more than 2 fields. Another function, called CONCAT_WS, adds delimiter. ... You could open two databases. You could copy data from one to the other. Then queries could work right. If you wish an enhancement, please set the Importance to enhancement. I set this bug to new, because it isn't realised yet. Could be a long discussion, if it could be realised at all.
Robert, thank you for your comments here and in my other tickets. Yes, it's an enhancement (see the word RFE in the title). I have no real idea how this plays along with current LO internals. Conceptually, there should be no problem, Access already does this apparently (see OOo ticket 42464)
Adding self to CC if not already on