OBIEE configuration

Question

I have my current OBIEE installed in a linux server under oracle directory. Now the current warehouse (ODI and data storage ) has moved to AWS.Can I change any configuration file within this installation to point to the warehouse tables in AWS instead?

I know my articulation of the problem is bit confusing. I will be happy to clarify if needed.

Thanks

You're running an on-premises OBIEE and want to connect to an AWS-hosted Oracle DB is that it? — Chris
The question was more on OBIEE side. Where in OBIEE do I change the database details. I have not installed OBIEE ever. So I dont know where exactly to change the database connection details. — Rina
Hey Christian, I now understand that the connection pool gives me the details about obiee metadata. Still I could not find the info on where to find the connection details for database which holds the actual data thats being reported. I mean the data warehouse database details which OBIEE is reporting from. — Rina

Chris Chris · Accepted Answer · 2017-06-13T07:37:41

Shortcutting your assumed answer: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.Oracle.html#CHAP_GettingStarted.Connecting.Oracle

Creating connection pools: https://docs.oracle.com/cd/E29542_01/bi.1111/e10540/conn_pool.htm#BIEMG1262

OBIEE configuration

1 Answers