XML Ingest and Transform
A sports and entertainment company was receiving data via XML files, and their data scientists couldn’t query this data for the information they needed. The data scientists were unsure what the final format would be for the tables, but they needed access to this final data from their existing business intelligence tools such as Tableau and R. So they needed to be able to adjust quickly.
With Cask Hydrator, the company was able to ingest and transform the XML data into multiple tables without writing any MapReduce jobs, and they could copy and adjust pipelines, allowing them to quickly make changes as needed. Finally, CDAP’s ODBC and JDBC drivers allowed the team to access data using the BI tools with which they were most comfortable.