ST-50 - Getting issue details... STATUS
University Marketing and Communications have set up dashboards to track various metrics around admissions marketing for GSAS & Grad Engineering.
Sananda Ghatak was trying to do the same thing for Nutrition, now that UCM is providing support for them, but DW no longer uses the process for moving data that NUTR set up:
Going forward we will not be bringing file exports into the oracle data warehouse, so the process will be different. We will be using our data virtualization platform in order to provide users access to scheduled exports.
Rachel Kell’s suggestion to Sananda was to use Box; testing proves we can drop Slate files into Box, but the hitch was that I needed an account (and a password!) to drop things into Box, and that wasn’t something we could set up.
This percolated for a while, and then DW came back with “It might just be easiest at this point to use one of the ones the DWBI group has already set up for other purposes. I can set up a sub folder specifically for Slate Reports and then we can publish them as a Tableau data source through Denodo.”
Matt Girard set up the connection between Slate and Denodo in September, 2023; he even wrote a guide: https://tufts.box.com/s/pyt4crtp6xq2d0gyrqedr6i7yxntqfxq
I ran through the first portion of Creating Web Services for Queries within Slate and then shared the URL with him:
With that URL he created the views; caching is an option, but all rows were taking less than 2 seconds.
Sananda has access to the Denodo views within Tableau for her dashboards.
Two files exist in the GradHlthSci instance of Slate that have this regular export to Denodo:
NUTR Prospect CJ Feed for Dashboard
NUTR Apps CJ Feed for Dashboard
Matt Girard has access via a direct permissions on the queries themselves.
Add Comment