Apache OpenOffice (AOO) Bugzilla – Issue 86891
Allow integration between distinct databases as MS-Access do
Last modified: 2013-02-07 22:34:03 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- Access...it´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 Brazil. 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 ?
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
set to 'new'