Hi
Using LibreOffice Base 7.0.2 on Ubuntu x64. I have some data held in an SQLite database in a local file; I also have some data held in a remote MySQL server. I’m using LO Base to design a simple tool that will draw these two datasources together to run custom reports and queries etc. Can connect to both datasources separately. How do I have both datasources in a single .ODB file so that I can do queries/reports that draw in data from both? I can’t see an obvious way to do this. I can’t simply copy the data into a local, single, database as both of these external datasources are updated by third parties and used in other systems (I need read-only access)
Hello,
The only method I know of to do this is for Base to make one connection and then in a macro create a connection to the other database. The macro connection could create a temporary table and then go from there.
There are methods to access multiple databases on a form (each on its’ own internal form) but without macros cannot combine in queries or reports.
Ah, that’s a good idea for a work around, thanks
Hi,
H2 can also be used as an alternative to HSQL. The documentation states :
The question however remains if the base parser would accept this, but one can always try !
My impression is that means multiple H2 databases (and as you state if Base could handle it). OP is asking about connecting to existing MySQL and SQLite DB’s - two very different connections.
So it seems as if the full feature to connect to more than one database (which Microsoft Access can definitely do) doesn’t exist in LO… is it a good idea to file a feature request on bugzilla?
Seems this was requested already but can’t find.
If you wish to request this, try a search first.
I did a search and also couldn’t find this as an enhancement request on BugZilla so filed a new one: https://bugs.documentfoundation.org/show_bug.cgi?id=137893