Friday, 4 September 2015 15:30
20 minutes
Advanced
English
As OLTP systems operate it often turns out that there is a need for some reporting features that were not initially planned or that the existing ones cannot work efficiently due to OLTP design implications. Enterprises sometime require the availability of large amount of data to report on but on other occasions it is sufficient to provide efficient reporting option against a few-quarters-old data. Such databases can be easily created on the fly with CPAN's ETL::Yerl tool and SAP HANA, an in-memory column-orientatated database.
This talk will demonstrate how simplistic OLAP database can be conjured through ODBC tunnel based on OLTP data in no time. We will highlight the OLAP-specific HANA SQL extensions and talk about the limitations imposed by lack of MDX-query implemntation in Perl.