| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
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
...
Matt Girard has access via a direct permissions on the queries themselves.
...
Updating the queries:
As data shifts and new and different fields are required, the queries in Slate just need to be updated, and the Denodo manager(s) informed, so they can update their processes.