One of the great things about SAP HANA, express edition is that you can take advantage of HANA’s embedded predictive capabilities: the SAP HANA predictive analysis library (aka PAL) and the application function modeler (aka AFM) in Eclipse (or HANA Studio).
However on the SAP HANA, express edition (aka HXE) home page it mentions PAL requires additional configuration of the base HXE server.
So what additional configuration is needed for the VMWare images and how can you get started?
Whilst the PAL is pre-installed with HXE it requires use of the script server which isn’t enabled out-of-the-box. So it’s necessary to first create a MDC tenant database and then enable the script server in that database. It’s also necessary to create a developer user in the tenant database with appropriate authorizations to create and execute PAL procedures and to access the AFM tool in Eclipse.
I’ve published a script with the necessary syntax here in the SAP HANA Academy’s GitHub.
I’ve also published hands-on video tutorials in the SAP HANA Academy YouTube channel that cover the configuration process in detail as well as an example of using the PAL via SQL Script and alternatively via the AFM modeling tool in Eclipse (no coding necessary!):
If you’re interested in other useful tips and tricks for SAP HANA, express edition check out our playlist here. Video tutorials cover the basics of getting started with the VMWare images or the binary install – to how to administrate your HXE instance. Keep checking back as we’re adding new videos daily.
Have fun and learn loads with SAP HANA, express edition!