View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001072 | CaseTalk Modeler | Generation (SQL, XML, etc) | public | 2016-09-26 09:01 | 2022-01-10 20:40 |
Reporter | BCP Software | Assigned To | BCP Software | ||
Priority | normal | Severity | feature | Reproducibility | N/A |
Status | closed | Resolution | fixed | ||
Target Version | Future | Fixed in Version | 8.14 | ||
Summary | 0001072: Support Denodo Data Virtualization scripts | ||||
Description | Denodo is a data virtualization environment. It is entirely scriptable, supports various levels of (abstract or interface) views to map source data to, and to extract business views from. It would be a great asset to have support by CaseTalk to generate a proper layer of views in this tool and data virtualization architecture. | ||||
Additional Information | http://www.denodo.com/ | ||||
Tags | No tags attached. | ||||
CaseTalk Edition | |||||
In Denodo, an interface is a special type of view that consist only of a definition of fields and its data types. The most common usage is in a top-down design where you first define the fields and later associate the implementation(data) of the interface. https://community.denodo.com/tutorials/browse/dataservices/0interfaces |
|
Added population examples through implementation views. The interface views will refer to these for implementation. That way the interface views are populated immediately without hooking up the source databases. # IMPLEMENTATION VIEWS CREATE OR REPLACE VIEW c_Allocation ( FOLDER '/CaseTalk/Student-Project-El_GLR/Implementation' DESCRIPTION = '"Student <first name> <surname> was allocated project <project code>."' PRIMARY KEY(first_name, surname) AS SELECT 'Peter' AS first_name, 'Johnson' AS surname, 'P101' AS Project FROM DUAL() UNION SELECT 'John' AS first_name, 'Hartman' AS surname, 'P203' AS Project FROM DUAL(); |
|
Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-09-26 09:01 | BCP Software | New Issue | |
2016-09-26 09:01 | BCP Software | Status | new => assigned |
2016-09-26 09:01 | BCP Software | Assigned To | => BCP Software |
2016-09-26 09:03 | BCP Software | Additional Information Updated | |
2016-09-28 14:15 | BCP Software | Note Added: 0000647 | |
2016-09-28 15:44 | BCP Software | Status | assigned => resolved |
2016-09-28 15:44 | BCP Software | Resolution | open => fixed |
2016-09-28 15:44 | BCP Software | Fixed in Version | => 8.14 |
2016-10-04 10:52 | BCP Software | Note Added: 0000659 | |
2022-01-10 20:40 | BCP Software | Note Added: 0003031 | |
2022-01-10 20:40 | BCP Software | Status | resolved => closed |