Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Write back template with multiple connection pools in OACS.

Received Response
41
Views
5
Comments
User_QNBF2
User_QNBF2 Rank 2 - Community Beginner
edited Aug 13, 2024 5:24PM in Oracle Analytics Forum

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

  • User_QNBF2
    User_QNBF2 Rank 2 - Community Beginner

    Hi,

    Did anyone face similar issue?

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    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
    User_QNBF2 Rank 2 - Community Beginner

    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 Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    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
    Robert Angel Rank 8 - Analytics & AI Strategist

    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...