Issue 86891 - Allow integration between distinct databases as MS-Access do
Summary: Allow integration between distinct databases as MS-Access do
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-03-10 22:17 UTC by claudiokfuri
Modified: 2013-02-07 22:34 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description claudiokfuri 2008-03-10 22:17:06 UTC
Dear Sir,

I´m trying to create some database views in which I use some tables from a 
database located in SQL Server and other tables located in OpenOffice Base.

Unfortunetely, I could only save the SQL Server tables via ODBC connection in a 
separe odb file. Thus, it was impossible to view those tables together with the 
tables from the local database, in order to add them to the queries that would 
produce the desired views.

I´ve asked some specilists from BROffice site (the OpenOffice official site in 
Brazil) and they confirmed that this is a feature not implemented yet.

I argued that it is a very basic feature to not having being included 
yet...after all, almost every applications will need to relate tables from 
distinct databases, and without that, OpenOffice base will be like a toy that 
can be used to crete "pilots" or "prototypes".

So, I think you should assign a righ priority to this new feature immediately 
to the next release. 

For you t have an idea of the problems that this limitation cause, I´m thinking 
about using MS-Access to relate the tables and save the results in a shared mdb 
file, and use OpenOffice Base just as a "reader" for around 50 users. Using 
this approach, we will have to buy only one license of MS-Access to work 
as "middleware server", and install only OpenOffice Base in the 
users´computers, so that they can access the information they need.

I think that OpenOffice Base is a good product, and I´ve been a fan of it, but 
the first priority in its project should be eliminate the need to use MS-´s a question of honor for the OpenOffice community, don´t you 
think ?

Thank you in advance for your attention !

Best regards,

Cláudio Kfuri
Systems Analyst

PS : After I have concluded the project that will implement the approach using 
MS-Access, I can send it to you via email if you want, so that you can analyse 
the best way to do that using only OpenOffice base, ok ?
Comment 1 christoph.lukasiak 2008-05-05 15:29:27 UTC
acknowledge -> send further to the 'requirements' team

p.s. this feature is already on our list, but we have limited resources and this
is not the only one .. but we work hard to improve that and integrate such
features as fast as possible

thx for your report
Comment 2 christoph.lukasiak 2008-05-05 15:32:18 UTC
set to 'new'