Read and write data back to SAC externally from JAVA

[kennedydb]

Hi SAC/BTP colleagues, we have been developing solutions using SAC for a while, and we are now trying to integrate a Simulation & Optimization tool that runs on-premise, to read and write back data to SAC models. We are able to write back using a HANA Cloud database, and then connect it to a live model in SAC, but reading data from a local SAC model, from an external JAVA or Python script is still an open issue, so we are currently having to export the data to excel. We have been looking for documentation on how to copy data from a SAC model back into a hana live model, and we were also looking for documentation on how to access the underling Hana database integrated within SAC, as you can do with Data Warehouse Cloud. Any tips or reference to documentation will be highly appreciated. Thanks, David

[david_stocker · Accepted solution]

Hi David,

With the 2022.Q2 release (in May), SAC will offer up a public REST API for exporting data from models. In 2022.Q4 (November), we plan to release its import counterpart.

This will enable the Java and Python scenarios you describe.

Cheers,

Dave