Data Warehousing and Slate
This article provides information on integrating Slate with an external data warehousing tool, as well as a cautionary message about expecting data warehousing capabilities from Slate.
Many partner institutions export data from Slate to external data warehouse solutions which typically also house data from other departments or units across campus. These data exports are created and managed with Query Builder, and can be delivered on a scheduled basis.
To integrate Slate data with a data warehouse, create a Slate query of the data to be exported. An overview of the data integration process may be found here, and a guide to Query Builder can be found here.
As with any type of data export, an export to a data warehouse may be set to return cumulative, updated records only, or incremental feeds. To determine what option is appropriate for the data warehouse needs, refer to the Edit Properties section of the Data Export documentation.
Last Updated on