[Libreoffice-bugs] [Bug 137893] Enhancement request: allow connection to multiple databases of different datasources to perform queries/reports on many tables

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137893

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Enhancement request: allow  |Enhancement request: allow
                   |connection to multiple      |connection to multiple
                   |databases to perform        |databases of different
                   |queries/reports on many     |datasources to perform
                   |tables                      |queries/reports on many
                   |                            |tables

--- Comment #4 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to LibreOffice fan user from comment #3)
> But what if we had say a remote MySQL server with a database and
> some data, and another (remote or local) completely different data source eg
> HSQL or ODBC database that had other data we wanted to query; at present, I
> cannot see that it's possible to connect to two *completely* separate data
> sources within the same .odb file.

The first problem would be: The *.odb-file could only connect to one source.
You could connect to a different source through Basic macro:

DIM oDatabaseContext AS OBJECT
DIM oDatasource AS OBJECT
DIM oConnection AS OBJECT
oDatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
oDatasource = oDatabaseContext.getByName("Name of database on LO" or
"file:///database.odb")
oConnection = oDatasource.GetConnection("","")

... but every source needs an *.odb-file to create the connection. You couldn't
connect with the same driver to MariaDB and PostgreSQL, for example. You have
to choose different drivers and this is what the *.odb-file does.

Queries over more than one database engine will only work in SQL-standard. So
if you connect through macro you have to know much more about the different
databases to get the right result.

I don't know if there is any GUI which allows to connect to different database
engines in one surface.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201115/2b7dafaf/attachment-0001.htm>