You can export an SAP HANA model as a stored procedure to SAP HANA database. Any SAP HANA user can consume those models for analysis.
You can export models that contain SAP Automated Predictive Library (APL) or custom Predictive Analysis Library (PAL) components.
This functionality exports the single model that you have selected as a stored procedure, as opposed to the entire analysis chain. The exported stored procedure and associated objects (tables, types) appear under the selected schema in the SAP HANA database. You can consume a stored procedure for use outside of Expert Analytics.
CREATE TABLE InputData like PAS00AMYWGCT0Y_ZE4LISJ2MWSCOREPROCEDURE_INPUT_TYPE; --- Insert the data that you would like to score on into the InputData table: CREATE TABLE ResultTable like PAS00AMYWGCT0Y_ZE4LISJ2MWSCOREPROCEDURE_OUTPUT_TYPE; call "ANALYTICS"."ScoreProcedure"(InputData,ResultTable) WITH OVERVIEW; select * from ResultTable;
PAS00AMYWGCT0Y_ZE4LISJ2MWSCOREPROCEDURE_INPUT_TYPE: The table type that defines the input columns of the exported stored procedure. It contains all feature columns that you used to train your model.
PAS00AMYWGCT0Y_ZE4LISJ2MWSCOREPROCEDURE_OUTPUT_TYPE: The table type that defines the output columns of the exported stored procedure. It contains all feature columns that you used to train your model, plus the columns that your stored procedure generates.