Connecting to different databases

Md. Altas

Hi All,

We created a very powerful BOM enquiry report in OBIEE.

Now there are other divisions that want to use it.

Is there any way I can connect to different database using different connection pools?

For example: - In dashboard I can define a Variable Prompt lets say - Source System along with other prompts.

Lets say we have 3 different Oracle instances - AB, XY, Z1

In the prompt is user types 'AB' and then enters part number and hits 'Apply' then OBIEE should connect to AB1 Oracle ERP and pull the data.

If user types XY and enters part number then OBIEE should connect to XY Oracle ERP and fetch data and so on?

Is it possible to define different connection pools and use then based on the prompt?

Thanks

[Deleted User]

Yes you can.

http://dimensionality.ch/2009/10/21/obiee-101341-dynamic-data-source/