Writing Data Back
System connection: SAP NetWeaver BI, BI JDBC, SAP Query
Question: Is it possible to write data back to any BI data source?
SAP NetWeaver BI
To connect to an SAP NetWeaver BI system, SAP Visual Composer for NetWeaver 2004s uses direct BAPI calls and the BI Web API (although deprecated with SAP NetWeaver 2004s, this API can still be used). The BI Web API itself does not support write back.
If an SAP NetWeaver BI system is connected to the Visual Composer through the XMLA Connector or the ODBO Connector, write back can be done as far as the authorizations are set and the MDX commands allow.
With the XMLA Connector write back can be done as far as the authorizations are set and the MDX commands allow.
With the ODBO Connector write back can be done as far as the authorizations are set and the MDX commands allow.
If a system is connected through the BI JDBC Connector, any SQL command can be used in the SQL Editor or SQL field. Depending on the users' authorizations in the backend, the data structures can be created and changed, and data can be inserted, deleted, or updated.
If a system is connected through the Portal JDBC Connector, you can use stored procedures which are writing data back.
Some examples for SQL statements with the syntax for different databases. multiple values are passed from the application into the SQL statement.
Write back is not possible with the SAP Query Connector in Visual Composer.