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.
