https://bugs.documentfoundation.org/show_bug.cgi?id=152429
Bug ID: 152429 Summary: Enhancement: Allow BASE to access multiple external data sources Product: LibreOffice Version: 7.3.6.2 release Hardware: All OS: Linux (All) Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: bra...@branchco.com Description: I'm looking into building a stock portfolio management application. I want the account data to be in a local database, but there are several tables that need to be updated daily with new data. For example the price_master table looks like the following: SYMBOL PRICE DIVIDEND YIELD PAY_DATE PE_RATIO FCX 39.525 0.15 1.56% 11/01/2022 14.60 ADM 92.435 0.40 1.72% 12/07/2022 12.86 This data is available from a CSV download file and it only takes a half minute to copy/past the appropriate columns into a CALC workbook that I've setup for this. Although the data in these tables change, there is never any reason for the application to make the changes. A read only table is all that is needed. Data that is managed by the application should be in the embedded HSQLDB database. The security_master table is a good example of this: SYMBOL DESCRIPTION FCX Freeport-McMoran Inc Class B ADM Archer Daniels Midland Co Common My use case is in finance, but I can readily think of many use cases in other fields where this capability would be very useful. This enhancement would allow BASE to function as a reporting engine bringing together multiple data sources. Steps to Reproduce: 1. N/A Enhancement request 2. 3. Actual Results: N/A Enhancement request Expected Results: N/A Enhancement request Reproducible: Always User Profile Reset: No Additional Info: N/A Enhancement request -- You are receiving this mail because: You are the assignee for the bug.