Connect Cloud DB in OBIEE 12c RPD

Rajagopal R-Oracle

Hi.,

How to create a connection pool to Connect Oracle Cloud DB(DaaS) to RPD in OBIEE 12c

Thanks

Gianni Ceresa

Hi,

Your DBaaS is a Oracle database, so get the connection details from there (the online management interface), setup security to allow access from remote (ideally by setting your source IP address to avoid issues) and done.

It's just a normal database, the "detail" is you don't use a local address but a public IP ...

Nothing else, use it as a normal Oracle Database

Gianni Ceresa

Maybe this one can help you a bit more: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_QS/oracle_database_cloud_service_dbaas_q…

Rajagopal R-Oracle

Thanks for your response., so the connection pooling creation is exactly same as usual connection pool creation., and we need to use ODBC to connect ., Am I right?

Gianni Ceresa

3357027 wrote: so the connection pooling creation is exactly same as usual connection pool creation., and we need to use ODBC to connect ., Am I right?

Connection pool creating is exactly the same? YES

We need to use ODBC? NO, NEVER !

You never use ODBC to connect to an Oracle Database, you lose functionalities and performance too, you use OCI. For you it is a normal Oracle Database, nothing else.

Depending on the release you selected to create your cloud instance you select that same version in the connection pool details. (11gR2 or 12cR1 or maybe 12cR2, if it's this last one and you can't find it in the RPD take the closest one, 12cR1)

Gianni Ceresa

If you got all you looked for based on your request you can maybe close the thread and mark if required? It would help others looking for the same, right now it's still This question is Not Answered.