Write Back Implementation – OBIEE

iWare Logic > Blog  > Write Back Implementation – OBIEE

Write Back Implementation – OBIEE

Write Back Implementation – OBIEE

Speaking about OBIEE, first thing which comes to our mind is, it is a
reporting and analysis tool and mainly used for viewing data (Selection). But
apart from this there is an advanced feature which allows us to enter or
update the values directly into the database. The feature is called as Write
Back. Users with appropriate permissions can use this feature. This article
includes the general introduction and implementation steps of Write Back

What is Write Back option?
Write Back is the ability to enter or update values directly into a report
and have those values stored directly in to the database. In order to
implement this feature in OBIEE we have to make some changes in the
repository as well as in the presentation services layers. Let’s see, the step
wise implementation of this feature.

Below mentioned are the general steps to be followed before using write back feature.

1. Making the table uncacheable from the physical layer of the repository.
2. Configuring the write back in the connection pool.
3. Granting the privileges of write back to the user from the Presentation Services.
4. Creating a XML Template and specifying the insert and update queries for write back.
5. Enabling write back from the column properties of the column in the request.
6. Specifying the template name in the table view write back properties of the request.

Now to understand this feature, Let us assume a scenario where we have a customer table (containing fields like name, contact number and other details) and a user has to update the contact numbers of the customers very frequently. We will implement the write back feature for this scenario by using the following steps.

(Note : In this article, We are using ORACLE DATABASE with supplier2 schema.)

Read Complete Document

Vishal Shinde