Data transfer fom HANA to the Predictive Analytics Server when using Predictive Factory.

[dbertsche]

My supervisor is concerned about the details of data transfer when using Predictive Factory with HANA and a Predictive Analytics Server. We plan to use models and data that are stored on HANA and schedule model application runs using Predictive Factory, the output will be stored back on HANA. Does the model and data transfer from HANA to the Predictive Analytics Server? If not, then why is the Predictive Analytics Server necessary? Thanks, David

[achab · Accepted solution]

Hello David, we have two modes. In the first mode the model processing (training) is delegated to SAP HANA. This requires APL installation on the HANA system and making sure to check the APL delegation checkbox in Factory. One also needs to verify our PAM document to make sure all versions are correctly aligned. The second mode is non-delegated. Then data (actually mostly metadata) is transferred from the SAP HANA server to the PA server for processing. Something important to note is that the PA server is not storing data, it's processing them on the fly when training the predictive models. I hope this clarifies. The reference to the PAM is here: https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/PAM_Predictive_Analytics.pdf. Thanks and kind regards Antoine

[achab]

Automated Analytics: https://help.sap.com/viewer/c36bc49d7cce4d35a2099aecdea81e2c/3.3/en-US/a9030f5b-ba34-4e4c-8f65-f1960...

Factory (see sub-topic in database application) https://help.sap.com/viewer/41d1a6d4e7574e32b815f1cc87c00f42/3.3/en-US/c8f707015916401ab87e4c51724c9...

[achab]

What kind of models are you planning to create? In the case of classification / regression models we have a so-called IDBA (in-database apply) feature that's super convenient. It means the data application process happens in-database with no data transfer. That's much more efficient compared to extracting to the data and scoring them one by one.

This also needs to be enabled by the administrator from Factory one, there is a specific help section that details the prerequisites.

Kind regards,

Antoine

[dbertsche]

We are planning to use regression models, the IDBA sounds great then, so I'll try to set that up. Thanks for the links, I had read the "Survival Guide" but not the PAM guide before. Best regards, David

[achab]

Me again... have you seen this end to end configuration guide: https://help.sap.com/viewer/c27db6dddfb04b2e8a4e44ad1a14ffa1/3.3/en-US/b8cf04dc266e4995a82090211d29f...?

[dbertsche]

Hi Antoine, Thanks for your fast reply -- what about when applying models? (after already training them). How much of the data is transferred from HANA to the PA Server in this case? Cheers, David