Write back template with multiple connection pools in OACS.

User_QNBF2

We have created writeback report and it's working fine if we use single connection pool inside writeback template but if we use multiple connection pool it is giving below error.

The system was unable to generate appropriate SQL. Please contact your service administrator?

Is it possible to use multiple connection pool in writeback template? If no, is there any workaround?

User_QNBF2

Hi,

Did anyone face similar issue?

Joel

You haven't said what your data sources are. Are they Oracle databases? I don't believe that this will work with multiple connection pools. My suggestion would be to get the data into one connection by creating a DB link for example from one data source to the other and that way, you can access the 2 data sources through one connection pool

User_QNBF2

Hi,

Yes, we are using Oracle database as data sources and have tables in two different schemas so have to use different connection pools.

You mean we can't use multiple connection pools in the writeback template?

Joel

As I mentioned in my previous post, the quick way around this is to either create a DB link (if objects are in different databases) or create synonyms of one schemas' objects into the other so that  the tables are all accessible from one connection pool.

Robert Angel

If you want to do any real data updates you are better dropping write back and looking into using Apex.

Write back was put there so Oracle could say it is a feature of OBIEE - it is feature - just not a good one, or one you would want to use for anything beyond posting comments in to a free text field. And even then you probably want to think twice about it...