Query Oracle Fusion from DuckDB through BI Publisher, with SSO, an ATTACH-able catalog and cached metadata
Maintainer(s):
krokozyab
Installing and Loading
INSTALL fusion_scanner FROM community;
LOAD fusion_scanner;
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| fusion_scanner_cache_invalidate | table | NULL | NULL | |
| fusion_scanner_cache_status | table | NULL | NULL | |
| fusion_scanner_cache_warm | table | NULL | NULL | |
| fusion_scanner_sso_login | table | NULL | NULL | |
| fusion_scanner_sso_logout | table | NULL | NULL | |
| fusion_scanner_sso_status | table | NULL | NULL | |
| fusion_scanner_version | scalar | NULL | NULL | |
| oracle_fusion_columns | table | NULL | NULL | |
| oracle_fusion_query | table | NULL | NULL | |
| oracle_fusion_tables | table | NULL | NULL | |
| oracle_fusion_wsdl_query | table | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| fusion_scanner_filter_pushdown | Send WHERE predicates on an attached Oracle Fusion table to Fusion. Off by default: DuckDB removes a pushed filter from the plan, so a predicate that cannot be translated exactly must fail the query rather than be approximated. | BOOLEAN | GLOBAL | [] |
| fusion_scanner_metadata_page_size | Rows per page when listing Oracle Fusion's dictionary. Lower it if a listing keeps stopping short of the instance's own table count. | UBIGINT | GLOBAL | [] |
| fusion_scanner_stable_paging | Give a paged statement an order, so that its pages partition the result instead of sampling it: an attached table by its primary key (or ROWID), a query by every column it returns. On by default; turn it off only if Oracle refuses the ordering, and expect pages to repeat and skip rows when you do. | BOOLEAN | GLOBAL | [] |