Hi
While appreciating the value of the views for a structured view of the data, we would be very keen to be able to extract raw data from the underlying tables (read only) to external tools like Excel/PowerBI for simple reporting (e.g. creating a Service Catalogue view of applications by extracting the raw data and links from the Application Provider class). Is there a way this can be done from the cloud version - access the raw class data or extracting as a CSV etc?
Thanks
Rob
Querying raw data in the underlying metamodel database
Just for completeness - you can write custom views that produce CSV output for manual import to Excel. Not as elegant as the API route, and you still need to know the structure to retrieve the slots in the custom view. There is one product view that does this for a couple of slots, as an example - 'Application List Extract - CSV' under the Support tab of View Library.
T
T
Interesting, it seems no longer to show out-of-the-box. My mistake, sorry.
To make it appear, you need to associate the report with the support tab. Using the capture UI, navigate to the Report class ( under EA Support, then Essential Viewer), and select the report instance Core: Integration Application Provider CSV Ext. Scroll down to the slot Element Classified By and add the existing term Report Classification::Support Views. Then publish and reload the viewer View Library.
Regards, T
To make it appear, you need to associate the report with the support tab. Using the capture UI, navigate to the Report class ( under EA Support, then Essential Viewer), and select the report instance Core: Integration Application Provider CSV Ext. Scroll down to the slot Element Classified By and add the existing term Report Classification::Support Views. Then publish and reload the viewer View Library.
Regards, T