How DI is pushing data in SAC? What is the Hana object created?

[MIH6]

We have a customer which is getting data using data intelligence in a dataset in SAC.

Most of the effort lies in getting the data from the data sources and there is also a machine learning model working behind the scenes to make a prediction on the sensordata.

I then prepare 3 different datasets that are pushed separately to SAC:

• Sensordata dataset – contains the sensordata used to create the R visualization (in SAC the dataset is called sapdi_sensordata)
• Metadata dataset – contains metadata corresponding to the sensordata (in SAC the dataset is called sapdi_metadata)
• Prediction dataset – contains the prediction of the ML model based on the sensordata (in SAC the dataset is called sapdi_prediction)

The function then used to push the data to the SAC is the following:

The data set in SAC seems to be slow and I am looking to see how data is pushed (what is hana object generated in Hana). Is any way to push data in a SAC model and not a dataset?

Thanks,

MIhaela

[lochner_louw]

Hey Mihaela,

Is there a reason why you are writing to SAC directly and not a HANA DB directly and use HANA live connection instead? That would be more efficient and opens up more flexibility when working with data.

(The SAC Formatter Operator only supports Datasets)

Thanks,

Lochner

[MIH6]

Hi Lochner,

This is a customer implementation, I don't think they have a Hana box. I am agree with you that this will be a best solution. However I will double check with them.

Thanks,

Mihaela

[lochner_louw]

Hi Mihaela,

Just to clarify - is the data set slow in SAC when you try and use it or slow when you push the data from DI to SAC?

It may be worth looking at note 2511489 to troubleshoot performance issues in SAC.

Thanks,

Lochner