Writing Data Back

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.

XMLA

With the XMLA Connector write back can be done as far as the authorizations are set and the MDX commands allow.

ODBO

With the ODBO Connector write back can be done as far as the authorizations are set and the MDX commands allow.

JDBC

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.

Examples

Some examples for SQL statements with the syntax for different databases. multiple values are passed from the application into the SQL statement.

Oracle

SAP Query

Write back is not possible with the SAP Query Connector in Visual Composer.