Ask Your Question

LO Base: Link to a View served by external Database? [closed]

asked 2014-04-30 22:17:41 +0200

Dycius gravatar image

Hi all,

There are two different databases in two different offices controlled by two different teams. I work in one office with a team that inputs certain parts of the data into a LO Base database and we use the reports feature to make great looking prints from the data. The other team uses MySQL and has a table that has some shared fields to what we have but not everything. Instead of duplicating work, I'd like remove those fields from our database (since we copy what the other team does anyways) and make a query that joins a view from the MySql database with the data from ours so when I run report all the updated infor nation is compiled.

Is this possible? If so, how do I set this up?

Many thanks, Jon

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 21:19:27.931354

1 Answer

Sort by » oldest newest most voted

answered 2014-05-05 12:32:39 +0200

frofa gravatar image

This discussion might contain some ideas on how to do it. I looks like tools other than Base might be needed.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-04-30 22:17:41 +0200

Seen: 139 times

Last updated: May 05 '14