From all the documentation that is available on the SDA(Smart Data Access), it is pretty clear that this technology/feature can be used to remotely Query/Access data from various remote sources(Oracle, SQL Server database etc) inside SAP HANA;
My question is with respect to the capability of SDA to actually update data into these remote sources from SAP HANA;
Is the following scenario possible with SDA?
(1) I have an Oracle based application that has 2 tables
(2) Using SDA, we created this "Oracle system" as a Remote source and we are able query data and even create calculation views using these 2 Oracle tables
Now we want to push data from a HANA calculation view into one of these Oracle tables using SDA; I read that Insert/Updates on virtual/remote tables are now possible with SDA; Does SDA support updating the remote source tables?
We currently use another middleware to push data from SAP HANA system into oracle database; But if SDA has this capability to update data into target systems, then we want to explore that option instead of using a middleware;
Please help me understand if SDA is capable of doing this?