Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Write back template with multiple connection pools in OACS.

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?
Answers
-
Hi,
Did anyone face similar issue?
0 -
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
0 -
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?
0 -
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.
0 -
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...
0